親テーブルと子テーブルがありました 親テーブルの外部キーで参照されるキーの値が変更(削除、更新)されました 子テーブルの参照するキーの値はどうしますか リンク参照 連鎖参照整合性制約

経験者の意見 Composite primary keys versus unique object ID fieldstackoverflow.com

PostgreSQL 外部参照留め書き 参照する側 が 参照される側 に無い要素を insert, update をすることはできない https://www.postgresql.jp/document/8.1/html/tutorial-fk.html

やること 甲. UIButton の境界線太さを設定しました 乙. 底(bottom) の境界線だけ更に微調整で太くしたくなりました (立体的な影をつけるイメージ) 乙. を実現する 前提 iOS 8.1 iPad Air (シミュレーター) 登場人物 CustomButtonsViewController(.xib | .h …

後述の「課題」が残った方法である事、ご承知下さい やること left_arrow.png(130x46 x1) を (50x50 x1) へ等比率画像に変換する 変換画像をボタン(200x200) に埋め込む 前提 iOS 8.1 iPad Air (シミュレーター) 登場人物 CustomButtonsViewController(.xib …

やること xib で作成したモックのボタンレイアウトを コードで内部処理して 下を例としたボタンレイアウトに変更する 前提 ストーリーボードは使わない iOS 8.1 登場人物 CustomButtonsViewController(.xib | .h | .m) 内部処理 .xib .h #import <UIKit/UIKit.h> @interface</uikit/uikit.h>…

xib に view - viewButton を設置 viewButton へ UIButton を 1 個設置 このボタンのレイアウトをコードで変更するときに from のコードを書くと表題のエラーが出る ので、to にすればよい from UIView *buttonView = self.viewButton.subviews[0] to UIView…

UISplitViewController で 2 つの ViewController を 1 つの画面に表示する 結果イメージ 前提 Storyboad, Segue は使わない Xcode 6.3.1 iOS 8.1 登場人物 LabelsViewController(.xib | .h | .m) (左側に出す画面) ButtonsViewController(.xib | .h | .m) (…

delegate(デリゲート) は 何か 他のオブジェクトがイベント通知を受けた時 このオブジェクトの代わりにアクションを実行するオブジェクト an object that acts on behalf of another object when that object encounters an event in a program 何ができるの…

結果イメージ テキストフィールドに @"out me" を入力 Send ボタンを押下する 別画面が開いて @"out me" が表示される 前提 Storyboad, Segue は使わない Xcode 6.3.1 iOS 8.3 登場人物 InputViewController(.xib | .h | .m) (値を受け渡す ViewController) …

to simplify creation of instance for many types Class Clustersdeveloper.apple.com

Draft article what is GoF Delegation The Gang of Four is wrong and you don't understand delegation - Saturn Flyer with Jim Gaywww.saturnflyer.com non-free article Using prototypical objects to implement shared behavior in object-oriented s…

It's just a mark to categorize. No impact on code. reference thanks for your knowledge sharing What is the significance of #pragma marks? Why do we need #pragma marks?stackoverflow.com #pragmanshipster.com

The completion block is used for doing any tasks after presenting the view controller reference thanks for your knowledge sharing what should go into completion in presentViewController?stackoverflow.com UIViewController Class Referencedev…

In this article, let VC as ViewController will output create base VC sub VC add sub VC to base VC create base VC In this article base VC is TopViewController(.h | .m) Main.storyboard Main.storyboard TopViewController.h #import <UIKit/UIKit.h> @interface </uikit/uikit.h>…

error snippet InternalInconsistencyException nib but the view outlet was not set background Created custom ViewController Combined it to another ViewController Could loaded xib with 'initWithNibName' But above error happened after build fi…

error Snippet Terminating app due to uncaught exception ‘NSInternalInconsistencyException', reason: 'Could not load NIB in bundle: check If you're working on project 'testproject' 1 XYZ.xib exist on Xcode IDE under directory 'testproject' …

just have resources or mange the resources Views Manage Your Application’s Visual Content View Controllers Manage Views Manage Resources Respond to Events Coordinate with Other Controllers Often Work with Containers May Be Presented by Oth…

2015-05-05 13:31:24.441 ProjectName[993:42467] *** Terminating app due to uncaught exception 'NSUnknownKeyException', reason: '[<XYZViewController 0x10caafd70> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key view.' check 1st arg of U</xyzviewcontroller>…

If use 'group by', set will be divided to subgroups. implements CREATE TABLE membeers ( name text, age integer, home text ); -- abbreviated insertion... SELECT * FROM members; name | age | home ---------+-----+--------- shimano | 25 | tott…

description(snippet from reference) The SQL HAVING Clause is used in combination with the GROUP BY Clause to restrict the groups of returned rows to only those whose the condition is TRUE. reference SQL: HAVING Clause

related to NOT IN ; sql - Red > Green > Refactor > Red snippet from reference >>-+-expression1--+-----+--IN--+-(--fullselect1--)---------+-+->< | '-NOT-' | .-,---------------. | | | | V | | | | +-(------expression2---+--)-+ | | '---express…

snippet from reference 4 Concepts 4.1 Data types A data type is a set of representable values. The logical representation of a value is a <literal>. The physical representation of a value is implementation-dependent. A value is primitive in that it</literal>…

snippet from reference The term cardinality actually has two different meanings depending on the context of it’s usage one meaning is in the context of data modeling and the other meaning is in the context of SQL statements. . . when the w…

snippet from reference 8.8 <exists predicate> Function Specify a test for a non-empty set. Format <exists predicate> ::= EXISTS <table subquery> General Rules 1) Let T be the result of the <table subquery>. 2) If the cardinality of T is greater than 0, then the result of the <exists predicate> is tr…</exists></table></table></exists></exists>

solution to odd action at NOT IN (...only result) (avoid record If NULL is included) SELECT * FROM members; id | name | age | home ----+---------+-----+--------- 1 | takagi | 23 | tottori 2 | kinashi | 19 | tottori 3 | itano | 20 | osaka 4…

非参考のお願い ... 内容不正確のため 非参考のお願い ... 内容不正確のため 非参考のお願い ... 内容不正確のため subview on main view will do Set components on Main.storyboard as you want Main.storyboard respond to TopViewController(.m | .h) Cr…

template @try { // process may include exception } @catch(NSException *e) { NSLog(@"Name: %@", [e name]); NSLog(@"Reason: %@", [e reason]); // append if any process exist } ex @try { SampleCustomViewController *viewController = [nib instan…

use instancetype readable (type safe) ex. generally in ‘init’ … ‘init’ returns 'the instance’ so it’s clear if it’s written ‘instancetype is returned’ (id) init; // what type will be returned? (instancetype) init; // ah ... instance will b…

ib(interface builder) Graphical Editor for designing UI components nib The resulting interface is stored as a .nib file short for NeXT Interface Builder xib no-compiled nib (XML formatted) Referred to ib and nib xib