Re: form 4.5 text item
Date: Fri, 25 Dec 1998 15:24:04 -0500
Message-ID: <3683F463.4B633769_at_prodigy.net>
To get the number of records retrieved by query, I used get_block_property(blk_id,QUERY_HITS) built in. Count_Query would require an additional database hit.
Ashok Upadhyay wrote:
> Create two display items 1. For current record
> in trigger when-new-record-instance you can assign :display_item1 :=
> :system.cursor_record for current record.
>
> 2. In Post query trigger of the block you are querying have a global
> variable an keep incrementing it (POS-QUERY fires for each record fetched)
> . At the nd you will have total number of record fetched. Assign this
> value to second display item.
>
> Alternatively you can use COUNT_QUERY built in to get total number of
> record..there is a tech bulletin available in oracle's support side to
> make it work.
>
> Thanks
> Ashok
>
> ayub khan wrote:
>
> > I have a problem I want to create two text items on the canvas and I
> > want
> > to get in one item total number
> > of records of my query and on other item I want displaying records
> > number
> > please tell me what triggers I should use and where
> > I would appriciate that.
> >
> > thanks Happy holidays
Received on Fri Dec 25 1998 - 21:24:04 CET