Trigger on open database
if i put this script into a button on a table form it works.
do as server
for a in select JobDockets where 'Job Bag' <= 13980 do
a.(SupplierQuote := null);
a.(SupplierConfirmation := null);
a.(SupplierVisual := null);
a.(Misc := null)
end
end
However - Ideally, I want this to auto run when I open the database. However if i put it into options - trigger after open . The script is accepted and runs on open but it don't work and do update takes place
any suggestions
P.s I am using a set number for testing on job bag but will replace with something like
for a in select JobDockets where 'Job Bag' <= 'Job Bag' - 400 do (or along those lines)
2 replies
-
Hi Mel
I have a couple of scripts that don't like 'do as server'. No idea why not. So have you tried taking this out, or would it all take too long?
Regards John
-
Yep it was exactly that John
seems that 'do as server' is not liked but a log in script
wonder why?
Content aside
- Status Answered
- 1 yr agoLast active
- 2Replies
- 75Views
-
2
Following