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@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 - 13:59:37 CDT