I can see that others have had problems with this as well but not how they solved the problem, so I will ask the question again.
I have a dhtmlxGrid with an attached DataProcessor and I have a .NET Connector - so far things are working more or less as expected, but, the Connector is using custom statements (select, update, insert, delete) because it has to add a few extra attributes to the statement before they are executed.
Now, the problem is to get the actual ID of the inserted row from the database (which has an auto-increment/identity column named “Id”).
A new row in the grid gets it’s ID from new Date().valueOf() which of cause isn’t the value that the database will assign to the new row.
So how do I find the new ID of the inserted row so it can be updated correctly back to the grid?