Re: hit_query problem

From: <igal_at_healthstreet.com>
Date: Thu, 30 Apr 1998 11:53:34 -0600
Message-ID: <6iaaae$tl8$1_at_nnrp1.dejanews.com>


In article <1998042819485600.PAA12850_at_ladder03.news.aol.com>#1/1,   jseeman102_at_aol.com (JSeeman102) wrote:
>
> I am trying unsuccessfully to use the hit_query feature in Forms 4.5. What
> happens is that I use the following syntax in a post-query trigger:
>
> :<block name>.<field name> := get_block_property('<block name>',hit_query);
>
> What should happen is that the variable to the left of the assignment
operator
> should receive the number of rows retrieved by the query, but instead it
shows
> zero. How can I fix this problem so that the variable accurately reflects
the
> number of rows? I'd appreciate any help you can give me. Thank you.
>
> Jeff Seeman
> 415-972-8804
>

Hi Jeff,
For some reason, the query_hits property of the block is valid only in the ON-COUNT trigger. Only there you can catch the number of records retreived. Place a COUNT_QUERY built in in that trigger and then :<block name>.<field name> := GET_BLOCK_PROPERTY(block_name, QUERY_HITS);

Igal

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 19:53:34 CEST

Original text of this message