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

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.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

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