Devart Forums

Hi,
I'm using ClientDataSet + TDataSetProvider to insert record in a single table.
In the event AfterUpdateRecord of the TDataSetProvider i'm making a database connection (using the same TSQLConnection of TSQLDataSet connected) to get the SCOPE_IDENTITY the inserted row, but it is always returning 0 (or null) ..
Any idea about this problem?
There may be some bug with the driver?

Tks for attention

Hello,

To obtain the new value of an autoincrement field, you have to refresh a dataset (close and open TClientDataSet). This is a specifity of dbExpress work with autoincrement fields.