Re: Number of Rows matching query

I posted a similar question not long ago, and found that query_hits does not work for me... maybe it's a Sun/Sparc bug. I dunno, but it always returned 0. I had to do a count_query and dig the number out of the returned message in an on-message trigger.

Carol

In article <01bcabf0$8d445e20$d3793ec2_at_naheed.abbas.ans.alcatel.co.uk>, Alex Cairns <Wastit_at_Hotmail.com> wrote:
>
>
>Ian C. Sellers <"ian"_at_mystical.net (temporarily out-of-order)> wrote in
>article <5sq606$1q4_at_news-1.boco.co.gov>...
>
>> Another related question: Has anybody got a nice piece of code that will
>> allow me to display in a text item on the form "Now viewing record
>> (Current_Record) of (Total_Records_Retrieved)." ?
>
>Use the When_New_Record Trigger and use this code
>DECLARE
> my_block BLOCK := FIND_ITEM('block_name')
>BEGIN
> :another_block.text_item := 'Now viewing record
>'||GET_BLOCK_PROPERTY(my_block,current_record)||' of
>'||GET_BLOCK_PROPERTY(my_block,query_hits) ;
>
Received on Tue Aug 19 1997 - 00:00:00 CEST