Looking into a recordset until it returns a result

[Bill]

I currently connect to two servers. One is IIS, that runs my asp and
sql server, and the other is an AS400, that also cranks out data.
Sometimes I have to wait for data I submit to the as400 to finish
being processed before it kicks back the recordset. If my page runs
before the as400 is done, it crashes. To put a delay into the page to
give the as400 plenty of time to finish, I've been placing a simple
loop for x = 1 to 1000000000 before proceeding to trying to display
the recordset.

What I'd like to do is find a loop that will keep looping if the
recordset is not populated, and then display once it is. Does anyone
know how I would do this?

Thanks,

Bill

[Tim Williams]

How do you "submit" data to the AS400? Doesn't sound as though you are just
querying the system...

tim

"Bill" <bi***********@gospellight.com> wrote in message
news:8d**************************@posting.google.c om...

I currently connect to two servers. One is IIS, that runs my asp and
sql server, and the other is an AS400, that also cranks out data.
Sometimes I have to wait for data I submit to the as400 to finish
being processed before it kicks back the recordset. If my page runs
before the as400 is done, it crashes. To put a delay into the page to
give the as400 plenty of time to finish, I've been placing a simple
loop for x = 1 to 1000000000 before proceeding to trying to display
the recordset.

What I'd like to do is find a loop that will keep looping if the
recordset is not populated, and then display once it is. Does anyone
know how I would do this?

Thanks,

Bill