Re: How to know the rowid of a record inside a Forms block

IF <tlfbi98_at_terra.es> wrote in message news:<9336cugeqoeffn76anjhgg8s47oklnrs93_at_4ax.com>...
> Thank you very, very much for your help.
>
> Regards
>
> On Sun, 21 Apr 2002 18:30:28 +0100, Connor McDonald
> <connor_mcdonald_at_yahoo.com> wrote:
>
> >IF wrote:
> >>
> >> In order to define an On-Update record, I need to know the rowid of
> >> the records inside a block. How can I do it in Forms 6i?
> >>
> >> Thanks in advance
> >>
> >> P.S. The On-Update trigger I want to define is something like this:
> >>
> >> Update emp
> >> set column1=:emp.clumn1
> >> where rowid = xx
> >>
> >> where xx is the rowid of the record.
> >>
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >>
> >> ..
> >>
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >>
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >> .
> >>
> >> .
> >
> >When you query, include the rowid in the sql and return it into a hidden
> >item.

You don't even need to do that. Each block based on a table (as opposed to view) has hidden item :rowid. This is real rowid of the record and can be referenced as any other item. The only restriction: you can't modify it (of course!)

> >
> >hth
> >connor
Received on Tue Apr 23 2002 - 00:09:03 CEST