Re: Q: ROWNUM in Forms 4.0 ?

Clive Bostock <clive_at_shimmer.demon.co.uk> writes:

>In article <petersen.823081494_at_com1.dwhl.de>, Helge Petersen
><petersen_at_com1.dwhl.de> writes
>>Hi all,
>>
>>I'm trying to show the ROWNUM in a Multi Record Block in Forms 4.0, without
>>any success.
>>It's possible to select/query the ROWNUM, but when inserting or updating
>>records it results in ORA-01747: invalid column specification.
>>
>>I also tried to display the ROWNUM or record number with
>>:SYSTEM.CURSOR_RECORD, but was unable to get the right values
>>during block or record navigation.
>>
>>Can anyone help ?
>>Thanks in advance
>>
>>***************************************************************************
>>Helge Petersen Datenbank- und Systemadministrator
>>Draeger Synematic GmbH D-23558 Luebeck, Germany
>>Tel. 0451/882-4044 Fax -3031 Email petersen_at_dwhl.de
>>***************************************************************************
>>
 

>ROWNUM isn't a column in the table, it is assigned by Oracle as it picks
>up the rows from the table. Consequently you cannot update it as a
>column or guarantee the value assigned to a given row (especially if
>using an ORDER BY).
 

>Clive Bostock
 

>Senior Consulant
>KPMG (Health Systems)
 

>All opions expressed are those of my
>own and not my employer.

Hi Clive,

I know that I can't update (or insert) a ROWNUM.

What I want is to show (select) the ROWNUM in a multi record block and avoid Forms from automatically generating UPDATE table (ROWNUM, ...) when I'm changing and commiting a record.

Is this possible ?

Helge Petersen                          Datenbank- und Systemadministrator
Draeger Synematic GmbH                  D-23558 Luebeck, Germany
Tel. 0451/882-4044   Fax -3031          Email petersen_at_dwhl.de
***************************************************************************