Re: Number of records returned by query

From: Simon Redfern <simon.redfern_at_remove_mebbc.co.uk>
Date: 1998/04/07
Message-ID: <01bd6236$34cc4440$a268b984_at_pc-189245-2.tv.bbc.co.uk>#1/1


QUERY_HITS shows the number of records fetched into the block so far. i.e. if you have a block that can display 3 records, when you first query, QUERY_HITS will be 3. only when you scroll down will it show more. One [Quoted] [Quoted] solution is to use LAST_RECORD and then get QUERY_HITS. Would be nice to [Quoted] know if there is a more elegent solution.

Simon Redfern.

-- 

email:  (replace AT with _at_) 
simon.redfernATbbc.co.uk

Mark Cudmore <mcudmore_at_kamloops.env.gov.bc.ca> wrote in article
<1998Apr6.163610.10095_at_vmsmail.gov.bc.ca>...

> I was wondering where in the Query process I could get a correct value
from
> the below bit of code?? Specifically what trigger should I put it in to
> get a valid value?
>
> Thanks
>
> Marc Nicholls wrote in message <3516dcf5.0_at_news1-hme0.mcmail.com>...
> >Mark,
> >
> >The simplest way would be to use
> >
> >get_block_property(<block_name or block_id>, QUERY_HITS)
> >
> >which will give you the number of records returned to the block by the
> >query.
> >
> >Regards
> >Marc
> >
> >Mark Cudmore wrote in message
<1998Mar23.085050.10057_at_vmsmail.gov.bc.ca>...
> >>Hi, is there any way to easily find out how many records are returned
to a
> >>block by a query in Oracle Forms 4.5?
> >>
> >>--
> >>Mark Cudmore
> >>email: mcudmore_at_kamloops.env.gov.bc.ca
> >>
> >>
> >>
> >
> >
>
>
>
Received on Tue Apr 07 1998 - 00:00:00 CEST

Original text of this message