VBScript: Wait for database execution

Question

I connect my script with an MSSQL database using "ADODB.Connection".

Afterwards I'm copying one table to another table (works fine):

Call oDBConnection.Execute("INSERT INTO " & sTargetTable & "SELECT * FROM " & sSourceTable)

afterwards I want to delete all entries of sSourceTable (works also fine):

Call oDBConnection.Execute("DELETE FROM " & sSourceTable )

My question is: Does the second query wait till the first query is completed?

bpgergo · Accepted Answer · 2014-08-28 11:27:05Z

1

In General, the Execute call will return when the SQL (the INSERT in this case) is finished.

Call oDBConnection.Execute("INSERT INTO " & sTargetTable & " SELECT * FROM " & sSourceTable)

Hence the second Execute will be called after the first is finished.

Call oDBConnection.Execute("DELETE FROM " & sSourceTable )

answered Aug 28, 2014 at 11:27

bpgergo

16.1k5 gold badges48 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AHiggins Over a year ago

Hi @jsodemann, if this or any answer has solved your question please consider accepting it by clicking the check-mark. This indicates to the wider community that you've found a solution and gives some reputation to both the answerer and yourself. There is no obligation to do this.

Collectives™ on Stack Overflow

VBScript: Wait for database execution

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related