I have some questions about Server-side scripting.

All concern my problem with record numbering. In the topic on this matter (see: http://fmforums.com/forum/topic/83982-continuous-numbering/ ) I was suggested to write the script on the server side.

I enclose a simple example in the attachment. I would be very much obliged for your opinion on it.

Main guidelines of the example:

1) The script must be operational round the clock.

2) The script reads a line from table T2, processes it (adds values of the fields AAA to BBB) and writes down the sum in the field CCC in the table T1.

3) The script deletes the processed record in the table T2.

4) When the script works, many users (client side) may add new records to the table T2.

Two questions.

1) In the example above the main loop is repeated 10 (ten) times.

I planned the server to turn the script operational once a day. The main loop would be infinite. The script would be started at 00:01 a.m. and would work for 23 h 59 min.

Has somebody any idea how to make the script turned on after the server rebooted?

My idea is to have the Bash script turned operational by crontab. Has somebody any experience with such a solution? Is my approach correct? Or maybe sb knows the better one?

2) Do you know the best way how to check from client side that the server side script is working?

Server-side scripting.zip

I close this topic. My idea is crazy and not effective.