Is there some approach for executing many sql (at least 2 sql) once?

[wxjshr]

As follows:

start transaction;

sql1;

sql2;

commit;

LV hava many vi for executing sql,but it occur problem when they deal with many sql once. Is there some approach for executing many sql once?

[MikeS81]

Hi wxjshr,

what do you mean? Do you want to write to two databases at the same time? Can you explain please?

Mike

[威海的风]

As follows sql:

start transaction;

update table_1 set money=money-50;

update table_2 set money=money+50;

commit;

I want the sql block execute one time,Labsql can do that?

[威海的风]

Hi,Mike

labsql executes only one sql at one time,am I right?

Now I want labsql executes a sql block at one time .How can I do that?

Thanks!

[MikeS81]

Hi 威海的风,

can you upload your vi? I'm don't understand what you try to do and why.

Mike

[威海的风]

I just want to execute two sql at one time.Is there a VI can do that?

[MikeS81]

Hi 威海的风,

what about using a loop? Is it a solution for you?

Mike

[威海的风]

Thanks , Mike!

Is there no method do that?

[MikeS81]

Hi 威海的风,

sorry, i can't tell you if such a funtion exists. Can you explain why you need it? I'm very interested in what you try to do.

Mike

[smercurio_fc]

I'm confused. You're already creating a command string that contains multiple SQL statements. What is the problem? What database are you using, and which driver are you using? I know that certain databases and/or drivers (e.g., MS Access and Jet) do not allow the execution of multiple SQL statements.