Forum Discussion

mrezahoseini's avatar
mrezahoseini
Contributor
10 years ago

Execute Several Queries at once in one connection

I would like to Execute serveral queries at once and don't know how to do it   my code is like this:     var AConnection, Driver; AConnection = ADO.CreateADOConnection(); AConnection.Conne...
  • mrezahoseini's avatar
    mrezahoseini
    10 years ago

    I solved it we can use "AConnection.Execute_(str);" after each query

     

    we should not concat queries and convert them into one string

     

    we should execute each query lonely

     

     

mrezahoseini's avatar
mrezahoseini
Contributor

I solved it we can use "AConnection.Execute_(str);" after each query

 

we should not concat queries and convert them into one string

 

we should execute each query lonely

 

 

AlexKaras's avatar
AlexKaras
Champion Level 3
10 years ago

Hi,

 

Yes, your finding was correct - ADO, which is a background data provider for both ADO and DDT objects does not support batch executions and is limited to one SQL instruction per command.