Waiting for db to insert record?

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
Thu Aug 28 07:46:33 CDT 2003

Excellent, I was sort of hoping it would.

Cheers

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uM57i5VbDHA.3080@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" <zammit_joe@hotmail.com> wrote in message
> news:OB90qZVbDHA.1280@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).
> >
> >
>
>