Devart Forums

Is it possible to use serial field and UniDAC will get value on client (DataSet) automatically like it does with MSSQL or I must have sequence in database and define KeySequence like with Oracle database in DataSet ?

I found out I have to modify INSERT SQL (exclude serial field and add RETURNING field) and set Query Options.ReturnParams to True.

Is this proper use or should UniDAC do this automatic ?

Best Regards,
Radovan Antloga

The current version of UniDAC does not support generating INSERT statements with RETURNING automatically.

So you should manually assign such statement to the SQLInsert property, or use the KeySequence property.