Re: form 4.5 text item

[Quoted] 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 Thu Dec 24 1998 - 21:59:15 CET