ADO AddNew not updating identity field
Posted on 2012-08-31
I have a VB6 application that has been in production for some time. But now the .AddNew/.Update is throwing an error 'Cannot insert the value NULL into <column name>', where <column name> is defined as an Identity column. Has always worked fine,, but now it is failing.
It appears from the message that the .AddNew is not incrementing and populating the column prior to the .Update.