Page 1 of 1

HowTO: make *Query Analyzer*?

Posted: Wed 06 Feb 2008 18:40
by Frenk3
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

Posted: Thu 07 Feb 2008 09:56
by Challenger
Please try to use the TMSQuery.Execute method and the TMSQuery.IsQuery property.

Posted: Sun 10 Feb 2008 18:42
by Frenk3
Thanks. That was what I was looking for.
Rgds,
Frenk