folks, we have a db, that's feeded by several other (web-published) dbs (see my other posts for details, please). we'd like to set up a script that: 1. checks wethere there are any records, 2. if yes, picks up the oldest (by date changed), 3. executes a (sub-script, do applescript), 4. deletes the record. so finally we end up in an empty db, sooner or later .... background: we are feeding the seperate db with applescripts that takes lots of time to execute. by this feeding we avoid the web-connected db to wait for the result of the applescript. any help appreciated by: phonoguy.

The script is below. Rather than running it in a loop in FileMaker, I think I would make a "cron" job that calls an Applescript that calls the FileMaker script. You could use iDo Script Scheduler in OS 9 or CronniX for OS X.

Show All Records

If [status (CurrentFoundCount) = 0 ]

.. Exit Script

End If

#

# Set up the sort order and then save the script.

# By date will put the oldest as the first record

Sort [Restore]

#

#specify "wait for event completion"

Send Apple Event (your applescript)

#

Delete Record [no dialog]

this sounds way good. thank you very much. there are running other applescripts on this machine, maybe that's a problem? ...oh, but: this is not an applescript-forum ;-). thank you again, says phonoguy.