DML Refresh

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dschuch
Posts: 75
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

DML Refresh

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
Posts: 22
Joined: Thu 29 Jan 2009 23:28
Location: Italy

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
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

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
Posts: 22
Joined: Thu 29 Jan 2009 23:28
Location: Italy

Post by badmood » Thu 29 Oct 2009 10:44

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

Sergio

dschuch
Posts: 75
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

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.

Post Reply