Wait while AdoCommand.Execute return

From: Julian Maisano (maisanosys_at_yahoo.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 02:46:15 -0600

(I've written this kind of code all the time and I've never had problems,
but I just want to be sure whether it is fine to write this way or not)

1: AdoCommand.SqlText := INSERT in "table1"
2: AdoCommand.Execute;
3: AdoCommand.SqlText := insert in "table2" that requires data inserted in
"table1" due foreign keys
4: AdoCommand.Execute;

Can the line 4 be executed before that the line 2 has finished?

I mean, does the program stop while line 2 is in execution?

Does it have to do with the rdbms used?
and.. what about ado.net?

Relevant Pages