Devart Forums

Stellar wrote: ↑Tue 08 Feb 2022 15:48 Hi Ronaldo!

Thanks for contacting us.

TDataSetProvider independently generates an SQL statement for adding a record to the database.
We cannot influence which SQL statement will be generated by TDataSetProvider.
Not the best option, but to update the records you can reopen the dataset, for example:

Code: Select all

ClientDataSet1.Close; 
ClientDataSet1.Open; 

You can fully work with SQL Server using Devart dbExpress Driver for SQL Server. But we recommend you to use our other SDAC components: https://www.devart.com/sdac/ and UniDAC: devart.com/unidac. They are better in performance and functionality than using dbExpress technology, and also allow you to get the value of the identifier when adding a record.

Best regards,
Sergey