the server log file will typically show what errors (if any) it hit while executing the script. The script may never have reached that point of the code.
Also keep in mind that server-side schedules also run the file's "on open" script so the error may happen there if there are incompatible script steps in the script.
checked the log...but there is n error ...
If I simply write this script...
Go to Layout["temp"(Temp)"]
Go to Layout["Main"(Main)"]
still its not working...
whats wrongs in this???
Is there a value in the max_time field for all records in the table?
Exactly. I suspect you will need to obtain the max–time value through a cartesian relationship.
max_time is contain global value.There is no relationship between Temp and Main Table
Because the script is running ‘server side’ the global will have whatever value was there when the file was closed when locally hosted on FMP, not FMS, which may be no value at all.
To make this work the field must be either a calculation, a stored field (not a global), or set as part of the script.
I recommend that whatever calculation you use to populate the Temp::max_time field be used to populate the Main::time field.
Hey Thanks for reply..but still im not getting you...In this case what should I have to do....???I wan to set the max_time's value in the main::time field.
How does the value get into the max_time field?
Use the exact same method to set the main:time field instead.
max_time field contain the max(temp::timestamp).So I want to set this value into main table.because once all fields of temp table are set the ..all records will be deleted ... Using main:time i want to search records thats why i created this field as global field.If I set this fild as calculation field than prb is if anyone delete any record from the main table than main:time's value will be change ...