Devart Forums

Hi,
I used to use the components from Microolap, and they seemed to handle serial(autoinc) fields automatically when used in a grid such as the one from DevExpress.

Currently if I have a table opened and I insert a row I have to refresh the whole dataset to get the autoinc number to populate.

Thanks,

Snorkel

You should set the DMLRefresh option of TPgQuery to True. In this case PgDAC generates INSERT statement with the RETURNING clause to get back inserted field values.

Thanks for the info.
Does using returning work on all versions of PostgreSQL?
I thought that was a newer feature of 8.3 or 8.4.

Later,

Snorkel

RETURNING is supported starting with PostgreSQL 8.3. But there is no other way to get back a value generated in the database.

Plash wrote:RETURNING is supported starting with PostgreSQL 8.3. But there is no other way to get back a value generated in the database.

I looked in the docs and it seems 8.2 also supports it:

http://www.postgresql.org/docs/8.2/inte ... nsert.html

You are right, RETURNING is supported starting with PostgreSQL 8.2.