Board index » delphi » If Tquery need transaction command in Tquery.sql.add

Jacob Pedersen

Delphi Developer

Sun, 27 Feb 2005 20:47:48 GMT

If Tquery need transaction command in Tquery.sql.add

As far as I know you cannot execute more than one
sql statement per TQuery.ExecSQL!?

Your sql code looks more like something you should put
in a storedproc in MSSQL7!

--
Jacob Pedersen
AK Techotel
J.Peder...@nospamtechotel.dk
(Remove nospam when replying!)

Other Threads

1. TQuery.sql.add(Sql-query)

2. tquery.SQL.Add..having trouble passing sql string

3. Chaining TQueries: Querying Paradox TQuery result sets using another TQuery

4. Delphi TQuery and Order By sql command

5. error creating cursor handling for TQuery component with Insert SQL command

6. Delphi TQuery and Order By sql command

7. Accessing TQuery from another TQuery's SQL

8. TQuery.SQL or TQuery.Filter: Is one better ?

9. (D2) Limits on TQuery.SQL.Add ???

10. TQuery: create table using sql.add?