Re: Total records in block

Why don't you use Count_Query built-in in Key-ExeQry trigger and On-Message trigger (message_code is 40355) to get the number of records?

Hope this helps.

Jap Boon Churn wrote:
>
> 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.

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru