SqlDbx
You are not logged in.
Pages: 1
How do I set column to NULL when changing data in a table
Edit the cell with F2, delete the actual content, and then press <Ctrl>+0 (zero)
Miguel C.
Offline
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
Offline
Thanks. Got it
One more question.
At what point changes commit to database?
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
Offline
Pages: 1