Re: How to update DB from reports

From: Kai Sodemann <>
Date: 10 Aug 1999 13:47:14 GMT
Message-ID: <01bee337$19cfae60$>

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 <> wrote in article <gZJr3.37801$>...
> 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
> 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

Original text of this message