Re: Q: ROWNUM in Forms 4.0 ?

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. Received on Sun Feb 04 1996 - 00:00:00 CET