Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set values to NULL (and set value to string "NULL") #332

Open
p-behr opened this issue Feb 7, 2025 · 0 comments
Open

Set values to NULL (and set value to string "NULL") #332

p-behr opened this issue Feb 7, 2025 · 0 comments
Assignees

Comments

@p-behr
Copy link

p-behr commented Feb 7, 2025

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.

Image

Image

@worksofliam worksofliam self-assigned this Feb 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants