Toad World® Forums

Toad Data Point 3.5: Error Posting Changes Value Cannot be Null


I was wondering if anyone knows the answer. I am receiving an the following prompt every time that I attempt to update a table in our database, using TOAD Data Point 3.5

Error Posting Changes: Value cannot be Null, Parameter name: Key Do you want to keep your changes so you can edit them?

More about the error:

  1. If I say yes, or no, and commit the changes it always reverts back to the old data file.

  2. There is no key on the table, and every column is nullable

  3. Other tables in my work schema give the same error so it is not the table itself.

  4. Colleagues using a different version of TOAD can make the update.

Any help you can provide will be appreciated.

Are you using a variable to update a field in the table?

What kind of database are you trying to update (Oracle, SQL Server, Sybase, etc.)?

Is there an identity column?

Try upgrading to 3.6

Also if you post your SQL statement it can help but it sounds more like a 3.5 problem.