Re: Go to a data block and Execute_Query when Form starts??

Dear Mr. Hristidis,

 For a read-only block with the query as a block property, in WEHN TAB-PAGE-CHANGED, I used this:
...
IF :SYSTEM.TAB_NEW_PAGE = 'SEARCH_TAB'
  THEN
    Go_Block('Staff1');
--> /* Verify that we haven't already done the search*/ --> IF Get_Block_Property(:System.Cursor_Block,STATUS) <> 'QUERY'

      THEN
        Execute_Query;

to keep from executing the query again.

Yours truly,
Mike Rainville

McGill University
Montreal, QC, Canada

vagelis Hristidis wrote:

> I want Forms to go to a specific data block and Execute_Query when Form
> starts.
> When I put
>
> Go_Block('student');
> Execute_Query;
>
> in
> When-New-Form-Instance trigger ,when forms starts the data blocks are not
> shown(an empty canvas is displayed), and I have to change tab page so that
> everything becomes ok.
> When I put the above statements in When-Window-Activated trigger, everything
> is ok except that when the user puts focus to another window and then back
> to the forms window these two statements are re-executed.
>
> Thanks in advance .
> Please mail to me.
>
> ----------------------------
> Vagelis S. Hristidis
> Electrical and Computer Engineering
> National Technical University of Athens
> e-mail:exrist_at_cc.ece.ntua.gr
> URL:http://www.cc.ece.ntua.gr/~exrist
Received on Sat Mar 13 1999 - 01:45:57 CET