HowTO: make *Query Analyzer*?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Frenk3
Posts: 8
Joined: Mon 19 Sep 2005 09:42

HowTO: make *Query Analyzer*?

Post by Frenk3 » Wed 06 Feb 2008 18:40

Hi,
I would like to make simple SQL tool inside an application that would execute sql statements. The problem is that I don't know if user entered a query or execute statement. Furthermore, I also don't know if sql will return one or more resultsets.
Which component can I use that offers me result *detection* and fethcing(if result are one or many recordsets)?
Rgds,
Frenk

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Thu 07 Feb 2008 09:56

Please try to use the TMSQuery.Execute method and the TMSQuery.IsQuery property.

Frenk3
Posts: 8
Joined: Mon 19 Sep 2005 09:42

Post by Frenk3 » Sun 10 Feb 2008 18:42

Thanks. That was what I was looking for.
Rgds,
Frenk

Post Reply