Hi all. I have a script that performs finds across records in several tables and sets foreign keys to allow summing at a higher level, using several self-join relationships.

the script works perfectly when i have the file stored locally. once i put it on the FM8A server, it does not seem to update the records every time. although if i walk through the debugger while its on the server, it will update the records and works perfectly.

I have no idea what would cause it to act differently on the server. its almost as if it is running too fast to update, because if i step through it in the Debugger it works fine. Does anyone have any ideas??

Thank you!!

Could be any number of things, including record locking by other users.

Try posting a jpg of the script steps; it might help clarify.

thanks for the reply. i dont think it was record locking since i was the only user in the file at the time. also the related records that are being updated in the scipt will only be accessed by the individual who created them. the main script does call two subscripts, i wonder if that has anything to do with it.

i know that the calculations and script work, its the inconsistency when its on the server that really bothers me. is there any possibility that it is a cache issue or something like that?

once i get more time ill try and post the script.

thanks!

Are you using any Plug-Ins?

I've experienced identical problems with a couple of plug-ins that I use.

Edited January 10, 200818 yr by Guest

no plugins. i added a 'freeze window' script step at the beginning of the scripts based on someones recommendation, and it *seems* to be helping, although i have NO idea why that would make any difference. i also lowered the cache a little, just to experiment.

im still stumped on the cause though.

You might try a pause script for one second in various places in your script. Just to see what happens. Sometimes it's very telling.

Clarification:

Placing a pause script step in your script in various places, one at a time will not always tell you WHAT the problem is but it will ususally tell you WHERE the problem is.

Edited January 12, 200818 yr by Guest

Do you have any file references?