Query component, how to save data

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ole Ekerhovd
Posts: 8
Joined: Sat 07 Feb 2009 07:43

Query component, how to save data

Post by Ole Ekerhovd » Wed 21 Aug 2019 06:18

Hi

With another component library I could SELECT, UPDATE, DELETE and INSERT data using aQuery.active:=true;

With Devart should I use Execute or ExecSql using the TPgQuery component for UPDATE, DELETE and INSERT?

Regards,
Ole

Ole Ekerhovd
Posts: 8
Joined: Sat 07 Feb 2009 07:43

Re: Query component, how to save data

Post by Ole Ekerhovd » Fri 23 Aug 2019 07:01

Hmmm, no response from Devart, this should be a trivial question.

Well, never mind, a Google search gave me the answer.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Query component, how to save data

Post by MaximG » Wed 28 Aug 2019 12:01

You can execute UPDATE, DELETE and INSERT statements using the Execute method of the TPgQuery component (https://www.devart.com/pgdac/docs/devar ... xecute.htm) or the ExecSQL method of the TPgConnection component (https://www.devart.com/pgdac/docs/devar ... m.object[])

Post Reply