Apple script to reset serial value

[cas305]

Hey all, I need an apple script to reset the serial value back to "1" on a field called SequenceNumber when the script is ran. I am going to use it on Filemaker server and I am going to schedule the script to run through the scheduler program in filemaker server. I would set it up as a filemaker script but I only want it to reset once a day and not everytime a user quits out of the database. Any help or suggestions would be great. The filemaker script I used for this is:

Set Next Serial Value["SequenceNumber", "1"]

The script works great in filemaker but had it doing it on a restart and everytime a user quit out of the filemaker database it would reset it and i only want it to reset a midnight every day. Thanks again

[jfmcel]

Sounds like you could just set an Applescript...

Tell application "FileMaker Pro"

do script "reset serial"

end tell

and set the script to run at 12:00am

[cas305]

Man story of my life...... making everything harder than it needs to be. Thanks for showing me the error of my ways!

[cas305]

Ok can anyone help me out with this??? I set up my applescript as stated above and it works fine for Filemaker pro. But i am using this on filemaker server it doesn't like the word script, says Expected end of line but found script when I change it from pro to server. Any ideas?:?

[Anatoli]

In server is nothing to run your request. You can do it on workstation only.

[keshalyi]

Your best bet, is to include in the applescript a few steps to have it open FMPro, and then open the database. Then run your script, and close the application. Fraid you can't do it in Server. Tsk!