Looping scripts and external Data

[pmconaway]

I have a script I'm in the process of writing. Here is the pseudo code for what I want to do.

--- start of pseudo code ----

Go to first record of attendee list

Does attendee have associated person record?

If not import record from external database (Oracle- connected via ODBC)

Go to next record until end of attendee list.

--- end of pseudo code ------

My question do I have pause somewhere in the script to allow for the import to finish up or will the script wait until the import is complete before moving onto the next script step? I want to be able to loop this script and make sure that I don't run into timing issues.

Paul

[theOx26]

I'm certainly not an authority, but I would think you are ok to run without pausing it. If you import records from a filemaker db, it will wait until the last step is done. In any other situation I can think of, it waits for the previous step to finish before it goes onto the next step.

It never hurts to just try it and see. Testing is always a part of development.

[mr_vodka]

Would you not be able to just find those that do not have an associated record and then import those at once shot?

[pmconaway]

Would you not be able to just find those that do not have an associated record and then import those at once shot?

I would love to this post is related to my post in the External Data source forum. Until I can get a view created that I can link to, I figured this is the easiest way to import just the records I need from the external Oracle table. I have the key I need to retrieve records from the external table already in FMP.