daily trigger via script
Posted on 2006-11-30
i am running fm 8 server with 4 workstations running 8.5 on xp.
i want to add a daily routine to my startup script. but i only want it run once by the first person to login.
i have custom function cdate with the value Get ( CurrentDate )
i have a global field in table homeowner "date printed"
my script looks like this:
if[cdate ≠ homeowner::Date Printed]
set field [homeowner::date printed; cdate]
and then i run my routine.
it worked fine as standalone for me. but now that i am running the database on the server i am getting inconsistent dates in the global field "date printed"
it sets the date ok with the set field command, but then when i exit the program and come back in, "date printed" is either empty or it has a different date so the routine runs every time someone logs in