Having a script wait for results

[pmconaway]

I have a script that importing records from via ODBC. It is a SQL database. Basically, I need to populate some subfields in another table based on the query results. A simplified version of the query would be "Select * from teacherdata where StateID = FMPDB:stateid" The script runs through the records in table A (which includes a value in the stateID field) and populates table B with the results of the query. I'm basically pulling down 1 record at a time from a secordary database.

My problem is that Table A has 1491 records and after a successfull run of the script Table B only had a little over 1300 records. My guess is that the query didn't return results before the script advanced to the next record and sent another query.

Is there a way to have a script wait for the results to be returned from the query before going on to the next step?

Thanks.

Edited January 27, 2006 by Guest

[Robert Kidd]

Could you use something like:-

Loop

Exit loop if IsValid(A to B relationship)

Pause 1 second

End loop

You might want to add a counter to the loop to exit the loop after say 20 seconds