Re: Forms 5 .. returned no rows help
Date: Wed, 07 Oct 1998 17:15:34 GMT
Message-ID: <6vg7jl$voc$1_at_nnrp1.dejanews.com>
In article <6vg1tq$cuh$1_at_nnrp1.dejanews.com>,
mdesouza_at_YAHOO.COM wrote:
> Hi all
>
> If I execute_query and my forms returns no rows . I need to do certain
> things.. like grey out buttons and inform the user that no records have been
> returned but I have not got a clue how to check when my forms has returned
> rows or not
>
> Is there a proc or in built like NO_DATA_FOUND that I can use to do this test
>
> any help would be appreciated
>
> regards
>
> michael dsouza
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
Hi Michael,
In ON-COUNT form trigger you can use this code:
COUNT_QUERY;
:GLOBAL.REC_HIT := GET_BLOCK_PROPERTY(:SYSTEM.CURSOR_BLOCK,QUERY_HITS);
You'll have a global variable that contains the number of records found.
Igal
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 07 1998 - 19:15:34 CEST