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

[IF]

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.

.
.
.
.
.
.
.
.

..

.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.

.

[Connor McDonald]

When you query, include the rowid in the sql and return it into a hidden
item.

hth
connor
--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

[IF]

Thank you very, very much for your help.

Regards

[Alex Filonov]

IF <tlf...@terra.es> wrote in message news:<9336cugeqoeffn76a...@4ax.com>...

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

[IF]

Thanks a lot. This is a much simpler solution.

Thanks again.
Regards

On 22 Apr 2002 15:09:03 -0700, afil...@yahoo.com (Alex Filonov)
wrote:

[Ta Xiong7]

errr
how abt creating a field in the table block using the rowid name and
reference it like :block_name.rowid
you don't have to display/show on the canvas
but if it's just normal update of the record itself, why bother to code, let
forms handle it ;-))
rgds

"IF" <tlf...@terra.es> wrote in message

news:tf71cugud00juohir...@4ax.com...