Re: Number of record retrieved by Query - Forms 45
Date: Tue, 1 Sep 1998 10:29:12 -0700
Message-ID: <6shand$fve$1_at_nnrp02.primenet.com>
Use COUNT_QUERY on the block and store the output number to a dummy field. You can trap the on-message trigger and use the translate function to trap the record_count.
You can also use the SYSTEM.LAST_RECORD built-in to check if you are on the last record of the block and disable your buttons appropriately.
HTH
Prasad Chavali
Bernadette Pinto wrote in message <1998083111571476740_at_zetnet.co.uk>...
>I'm trying to write a little bit of PLSQL to enable and disable the
>default navigation butons according to the current
>:system.trigger_record. (I.e., when this is 1 then the up and scroll
>up buttons are disabled.).
>
>Can anyone tell me how to determine how many records are held in the
>current block? I need to know the highest sequence number before I
>can diasble the other 2 navig buttons./
>
>Thans
>
>B. Pinto
>
>
Received on Tue Sep 01 1998 - 19:29:12 CEST