Re: Total records in block

use EXECUTE_QUERY(ALL_RECORDS)

Jap Boon Churn wrote in message <37CA095D.D70F9B8A_at_pc.jaring.my>...
>Hi,
>
>I'm new to Oracle Developer and currently using Forms.
>
>Can someone tell me how do I get the value for the number of records in
>a data block including those that are not yet displayed until we scroll
>down.
>
>I have try to use this method :
>last_record;
>v_rowcount := Get_block_property('BlockName', Query_hits);
>
>This method can be applied when I perform the above action using a
>button and setting the mouse and keyboard navigate for the button to NO.
>
>However, what I want is to be able to get the number of records in
>current block after entering something in an item and move to another
>item in the when_item_validate trigger. This is very important as I
>cannot use the above method cos it needs to go to last record and this
>will cause an error message.
>
>Hope someone can answer by question as soon as possible.
>
>Thanks a lot.
>
>
>
Received on Mon Aug 30 1999 - 10:52:16 CEST