Query execute vs open question

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
snorkel
Posts: 384
Joined: Tue 08 Aug 2006 15:10
Location: Milwaukee WI USA

Query execute vs open question

Post by snorkel » Wed 24 Dec 2008 15:56

Hi,
In other PGSQL Delphi libraries ( I wont' mention the names) if you execute a query that returns a result using using myquery.execute it totally errors out. Is the Devart solution smart enought to know the difference between a set returning query without have to resort to nast regular expressions to figure out if the query is a Select etc vs a execute like create table or INSERT or UPDATE etc.

Thanks,

Snorkel

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 29 Dec 2008 09:11

Yes, PgDAC can detect if a SQL statement returns a record set.

Post Reply