This discussion is archived
1 Reply Latest reply: Oct 5, 2012 6:39 PM by Gary Graham RSS

Cannot Save NULL value to database

PPlatt Explorer
Currently Being Moderated
I cannot save a null value through the data tab in the multi-row updates pane. It always gives me an error such as "Invalid number". It works fine through normal SQL update statement. Is there a preference somewhere to turn this on?
thanks in advance
Paul P
  • 1. Re: Cannot Save NULL value to database
    Gary Graham Expert
    Currently Being Moderated
    Hi Paul,

    Just use the backspace key to obliterate any existing value -- that makes it null. Afterwards, if you refresh or close/reopen the object, the data tab will display any null as the value set in Tools | Preferences | Database | Advanced | Display Null Value As .

    Regards,
    Gary
    SQL Developer Team

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points