As I wrote in my comment, I would not set the existing value to null. Instead, a computed column seems like a better option to me. Also, varchar(1) is the second worst data type you can choose (nvarchar(1) is even worst). First, if you know you only ever going to have a fixed length string, … Read more
I can’t constrain it to the specific button though because I don’t have IBOutlets and would rather not add them Then you are totally stuck. Your requirements are self contradictory. Without a reference to the button of some kind, you cannot possibly make a constraint to it programmatically. There is no “whoever my nearest neighbor … Read more
The old way of doing this is a multi-step process: add the column which will be the primary key update the column enforce the primary key. Something like this: create sequence t23_id; alter table t23 add id number; update t23 set id = t23_id.nextval ; alter table t23 add constraint t23_pk primary key (id); In … Read more
Auto Layout dynamically calculates the size and position of all the views in your view hierarchy, based on constraints placed on those views. For example, you can constrain a button so that it is horizontally centered with an Image view and so that the button’s top edge always remains 8 points below the image’s bottom. … Read more