Waiting for db to insert record?

[Paul]

Hi all

Just a quick question more about the flow of an asp page. IF I have code as
below: -

MyDBConnection.Execute "Insert Record Into A Table"
MyRecordset.Open "Retreive the same record from the table"

Is there any chance that the connection process (Inserting the record) will
not have completed by the time I try to retrieve the record. I.E. will the
asp page wait for the insert to complete before continuing to open it (the
next command in the page).

[Paul]

Excellent, I was sort of hoping it would.

Cheers

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uM**************@TK2MSFTNGP11.phx.gbl...

Yes, it will wait. It's a single threaded process where only one
instruction is executed at a time.

Ray at work

"Paul" <za********@hotmail.com> wrote in message
news:OB**************@tk2msftngp13.phx.gbl...

Hi all

Just a quick question more about the flow of an asp page. IF I have code

as

below: -

MyDBConnection.Execute "Insert Record Into A Table"
MyRecordset.Open "Retreive the same record from the table"

Is there any chance that the connection process (Inserting the record)

will

not have completed by the time I try to retrieve the record. I.E. will the asp page wait for the insert to complete before continuing to open it (the next command in the page).