DML Refresh

dschuch · Post by **dschuch** » Wed 28 Oct 2009 11:13

Hy, i'm sure, i saw it somewhere but i can't find it again.

Where to find some documentation about DMLRefresh support?

Daniel

badmood · Post by **badmood** » Wed 28 Oct 2009 19:56

I'm also searching some sample about DMLRefresh.

Anyone?

In the help I can't find it.

Plash · Post by **Plash** » Thu 29 Oct 2009 07:57

This property is described in the help of other DACs (ODAC, IBDAC, UniDAC). Its description is the following:

Use the DMLRefresh property to refresh record by RETURNING clause when insert or update is performed.

We'll add the description into the PgDAC help in the next build.

badmood · Post by **badmood** » Thu 29 Oct 2009 10:44

Thank you, I'll check it as soon as I can.

Sergio

dschuch · Post by **dschuch** » Thu 05 Nov 2009 23:42

the point is that DML Refresh uses RETURNING.
So a very easy way is also to look here:

http://www.postgresql.org/docs/8.4/inte ... pdate.html

as you can see statements like

UPDATE table SET col=col+1 RETURNING col

are possible.