Page 1 of 1

Postgresql and sequence

Posted: Wed 03 Jun 2009 19:52
by namikgungor
Hello.
how can i obtain value for sequence field when i was insert a new record?

Posted: Thu 04 Jun 2009 09:27
by Plash
You can set the DMLRefresh property of TPgQuery to True. In this case the TPgQuery component uses an INSERT statement with the RETURNING clause. The field value in the dataset is filled automatically when you post a record.