Re: Forms 4.5 Questions

Hi,

  COUNT-QUERY block-level trigger could help you.

 By example:
  Trigger COUNT-QUERY:
  DECLARE
    myCount number;
  BEGIN

• User function that count retrieved records (you have to define it) myCount := my_count_query_function;
• Now change block property Set_Block_Property('MY_BLOCK', QUERY_HITS, myCount); END;

      Yann.

Scott Haas a écrit :

> 2 questions regarding actions in Forms 4.5 (on OpenVMS 7.1)
>
> 1. Is there anyway to change the Count that appears in the lower left
> corner of the console window. Our main table is not a base table and
> therefore the Count is always 0. The books suggest that these fields
> are not changeable, but I was wondering if anyone had a workaround.
>
> 2. Whenever I try to query to a large table and write a message to the
> console (ie. life sign), the message always is displayed after the query
> has returned all of the rows. If I executed the message line first,
> then the execute_query, you would think that the message would be
> displayed (ie. message like 'Working ..'). But that's not the way it
> works on this VMS platform. Any ideas. Again the reason for this
> question is related to a non-base table.
>
> TIA,
> Scott
Received on Tue Oct 19 1999 - 17:55:09 CEST