Re: Newbie question - Data blocks and Arguments
From: DanHW <danhw_at_aol.com>
Date: 23 Aug 1999 22:33:23 GMT
Message-ID: <19990823183323.21816.00003929_at_ng-fm1.aol.com>
Date: 23 Aug 1999 22:33:23 GMT
Message-ID: <19990823183323.21816.00003929_at_ng-fm1.aol.com>
>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
>
A slightly better solution migh be to use a form parameter - less overhead than an entire block, plus you could call it from another form very easily.
Dan Hekimian-Williams Received on Tue Aug 24 1999 - 00:33:23 CEST