Re: Q: ROWNUM in Forms 4.0 ?

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/02/07
Message-ID: <4f8q42$dl_at_gossamer.itmel.bhp.com.au>#1/1

In article <petersen.823529443_at_com1.dwhl.de>, petersen_at_com1.dwhl.de (Helge Petersen) says: <snip>>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
>***************************************************************************
>
>

I havent tried this, but it should work: create a non-base table item in the base block for the row num. create a post-query trigger on the block which runs a cursor which returns the row number.
I think this would work... but I now seem to remeber that row number cant be returned in some versions of SQL (very vague memory) Umm.
Oh well, worth a try at this stage?

HIH
Lee

------/\/\------+---------------------------------------------------
     / / /\     |  Lee Levy, ISSD Systems Development, Del Code (34)
    / / /  \    |  BHP Information Technology,  ACN 006 476 213
   / / / /\ \   |  PO Box 261, Warrawong, NSW 2502, Australia

   \ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-     \ / / / | Internet : levy.lee.ls_at_bhp.com.au

-----\/\/\/-----+---------------------------------------------------

Opinions expressed are mostly my own, so give me some credit. Received on Wed Feb 07 1996 - 00:00:00 CET