Changing table data to NULL doesn't work...requires a workaround #57

Activity

1. Samnan commented on Oct 11, 2022

   

   Samnan

   on Oct 11, 2022 via email

   Owner

   More actions

   You have to use the hotkey 'Shift + Delete' on Windows and 'Fn + Backspace' on Mac when editing the column. This will properly generate sql with NULL instead of "NULL" command.

   …

   ----------------------------- Samnan ur Rehman Consultant / Senior Software Developer about.me/samnan

   On Sun, Apr 10, 2022 at 7:40 AM odonov8 ***@***.***> wrote: The "Update Records" tab has issues when I change table data to NULL Let's say I have a table called "table_name" and column "column_name". I set Data Type = int, Length = 6, and Default value = NULL. And let's say the data under "column_name" is 24. When I try to retype the data NULL and then click on "Update Records", I get the following error: Error occurred while executing the query: Incorrect integer value: 'NULL' for column 'column_name' at row 1 1 UPDATE table_name SET column_name="NULL" WHERE id="11" The only workaround I could find for this is copying the query and then removing the quotes around the "NULL" like this: UPDATE table_name SET column_name=NULL WHERE id="11" then I select the UPDATE query, click on the "Query" tab, and all is good. Is there any other workaround for this? — Reply to this email directly, view it on GitHub <#57>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAGVEICZMOO7TI6R5KVT4UTVEI5SJANCNFSM5TAEMLSQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>