Re: commit when leaving record

ok, but this solution has you actually reaching the next record before doing any saving. and i don't want it just to save without prompting, so i need to read the record status. and reading the record status in a WHEN-NEW-RECORD is always going to return "QUERY" when scrolling through query results.

i've tried setting a parameter ("CHANGED_FLAG") upon leaving the record, then checking the flag in a NEW-RECORD trigger. if changed_flag = Y, then commit. but, this, too, is not ideal. you are not looking at the changed record when you are prompted. plus, this does not change the record_status of the changed record.

seems like there should be an easy solution to this. but i'm yet to find it...

thanks for the help.
-mt

Huwski wrote in message <35a35a57.16628682_at_news.geccs.gecm.com>...
>Michael, try using the 'WHEN-NEW-RECORD-INSTANCE' Trigger, This WILL
>allow you to use 'restricted' built-ins ( commit and so on ).
Received on Wed Jul 08 1998 - 18:03:21 CEST