Re: Newbie question - Data blocks and Arguments
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: Mon, 23 Aug 1999 18:59:37 GMT
Message-ID: <tSgw3.120$tS.3760_at_nntp.csufresno.edu>
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Mon Aug 23 1999 - 20:59:37 CEST
Date: Mon, 23 Aug 1999 18:59:37 GMT
Message-ID: <tSgw3.120$tS.3760_at_nntp.csufresno.edu>
In article <7prt1c$9k7$1_at_nnrp1.deja.com>, <newbie22_at_my-deja.com> wrote:
>Is it possible to create a data block that
>will accept an argument that will be used
>in the where clause? I've done this in PLSQL
>functions and procedures, and in ProC.
Create a control block above the base-table block, with the selection item. In the base-table block, set the where-clause to: Col_A = :Ctrl_Blk.Select_Itm
Create a key-Exeqry trigger (form-level) that does:
Go_Block('TBL_BLOCK');
EXECUTE_QUERY;
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Mon Aug 23 1999 - 20:59:37 CEST