Page 1 of 1

Query component, how to save data

Posted: Wed 21 Aug 2019 06:18
by Ole Ekerhovd
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

Re: Query component, how to save data

Posted: Fri 23 Aug 2019 07:01
by Ole Ekerhovd
Hmmm, no response from Devart, this should be a trivial question.

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

Re: Query component, how to save data

Posted: Wed 28 Aug 2019 12:01
by MaximG
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[])