Re: Number of Rows matching query

From: Alex Cairns <Wastit_at_Hotmail.com>
Date: 1997/08/18
Message-ID: <01bcabf0$8d445e20$d3793ec2_at_naheed.abbas.ans.alcatel.co.uk>#1/1

[Quoted] 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 Mon Aug 18 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Karel Jankovsky: "Forms error - FRM40735 Pre_Form trigger raised unhandled exception ..."
Previous message: Dante A. Notari-Locher: "Re: I/O Error in temporary file C:\temp\4.tmp..."
Maybe in reply to: Karl Wortmann: "Number of Rows matching query"
Next in thread: Karel Jankovsky: "Forms error - FRM40735 Pre_Form trigger raised unhandled exception ..."
Reply: hurd carol: "Re: Number of Rows matching query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message