SqlDbx Forum

allanb

Guest

How to set column to NULL in Edit mode

How do I set column to NULL when changing data in a table

maac2002

Member

Re: How to set column to NULL in Edit mode

Edit the cell with F2, delete the actual content, and then press <Ctrl>+0 (zero)
Miguel C.

sqldbxhelp

Administrator

Re: How to set column to NULL in Edit mode

Wow, I did not know that you can do it this way.
Other way to do it is to click on a cell (not double click) and press "Delete" key

allanb

Guest

Re: How to set column to NULL in Edit mode

Thanks. Got it
One more question.
At what point changes commit to database?

sqldbxhelp

Administrator

Re: How to set column to NULL in Edit mode

Update is send to database after cell looses focus or enter key pressed.
Actual commit to database is dependant on Auto Commit setting for Oracle and DB2.
In case of Sybase and MS Sql Server changes automatically committed unless
transaction was started manually