Re: How to update DB from reports

Hi,
use the format trigger of the repeating frame. There you can flag every record, that is shown in the report. Be careful not to use a "total page number" function, not to mark the records, that you didn't show at the screen.

In the trigger use: update table set rep_flag='Y' where prim_key=:prim_key;

Reg Kai

Dwayne King <dwayne_king_at_bigfoot.com> wrote in article <gZJr3.37801$um6.444421_at_news2.rdc1.on.home.com>...
> Hi there,
>
> I have a report where I want to run a stored proc after each page of a
> report (to mark the data on that page as printed). What type of trigger
> should I use to do that?
>
> The after page trigger doesn't fire after the first page, so I can't use
> that (unless I make a dummy first page I guess). I also want to make
sure
> that it doesn't fire more than once if the user navigates back.
>
> Thanks in advance
>
> DK
>
>
>
Received on Tue Aug 10 1999 - 15:47:14 CEST