Re: SQL*Forms 3.0 - trigger advice needed

frampton_at_mail.flarc.edu.on.ca (Steve Frampton) wrote:

>Actually...I did think of a stupid way. The "KEY-NXTBLK" trigger would
>fill the fields of a dummy block that doesn't get displayed. The
>"PRE-QUERY" trigger of screen #2 would load values from the dummy block,
>and then clear out the dummy block afterward, thus guaranteeing it only
>happens once.

Yep, that is the way we do it too!

>Is there a better way to accomplish this? By the way, another thing I
>would like is the ability to change the record on screen #1 if any
>changes were made to the same record on screen #2. Currently I've got to
>re-query the records.

I don't know of any other simple solution.

Regards
Thomas R Skinner
Allgas Energy Ltd
('Fixed in the next release' or 'The Patch is in the mail') Received on Wed Jun 12 1996 - 00:00:00 CEST