You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using UPDATE: you can set a column value to NULL by typing NULL in the field.
If the column is less than 4 characters I am not sure how to set it to null ("NULL" won't fit).
I have not had a need, but I also don't see any way to set the value to the string "NULL" (i.e. UPDATE file SET field = 'NULL').
If you double-click in fld1 and type NULL it will set the value to null.
If you double-click in fld2 and attempt to type NULL it won't fit and can't set the field to null value.
The text was updated successfully, but these errors were encountered:
When using
UPDATE:
you can set a column value to NULL by typing NULL in the field.If the column is less than 4 characters I am not sure how to set it to null ("NULL" won't fit).
I have not had a need, but I also don't see any way to set the value to the string "NULL" (i.e. UPDATE file SET field = 'NULL').
create table qtemp.testfile
( fld1 char(4), fld2 char(3) );
insert into qtemp.testfile
values('', '');
update: select * from qtemp.testfile;
If you double-click in fld1 and type NULL it will set the value to null.
If you double-click in fld2 and attempt to type NULL it won't fit and can't set the field to null value.
The text was updated successfully, but these errors were encountered: