Re: Number of Rows matching query

Look at the count_query built-in. I get that info automatically, however, on the status line in the lower left corner of runform (Query will retrieve XX records).

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)." ?

TIA, -Ian

Karl Wortmann wrote:

> Hi
>
> This is (I believe) a simple question. Apologies in advance for
> missing the obvious/
> incorrect terminology.
>
> I have a master-detail relationship. Deferred & Auto-Query are true.
> When I go to the
> detail block (by clicking on a particular item), I would like to know
> the number of
> rows which the query retrieves. More specifically, I need to whether
> or not any rows were
> found at all.
>
> I looked at Post-Select. Here the help says
> "for example, an action based on the number of records that match the
> query criteria."
>
> This is what I want to do, but for the life of me, I can't find what
> to look at to see
> the number of rows retrieved. Can anyone help?
>
> Thanks in advance.
>
> Cheers
>
> Karl Wortmann
Received on Tue Aug 12 1997 - 00:00:00 CEST