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
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

 

 

  • 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.