Page 1 of 1
DML Refresh
Posted: Wed 28 Oct 2009 11:13
by dschuch
Hy, i'm sure, i saw it somewhere but i can't find it again.
Where to find some documentation about DMLRefresh support?
Daniel
Posted: Wed 28 Oct 2009 19:56
by badmood
I'm also searching some sample about DMLRefresh.
Anyone?
In the help I can't find it.
Posted: Thu 29 Oct 2009 07:57
by Plash
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.
Posted: Thu 29 Oct 2009 10:44
by badmood
Thank you, I'll check it as soon as I can.
Sergio
Posted: Thu 05 Nov 2009 23:42
by dschuch
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.