Re: Dynamich WHERE IN (..) List in a Cursor
Date: Thu, 19 Nov 1998 15:03:44 GMT
Message-ID: <731c04$coq$1_at_nnrp1.dejanews.com>
In article <01be130b$fe210f20$4b7d4f8b_at_rac17217.hasler.ascom.ch>,
"Buergi Josef" <josef.buergi_at_ascom.ch> wrote:
> Hello
>
> I'm trying to do the following:
>
> I have a Forms45 field called :block.ctl_members containing
> 'BUERGI','MERZ','FREI' in a running form.
>
> Now I like to open a cursor
>
> CURSOR member_cur IS
> SELECT member, salary
> FROM all_member_table
> WHERE member IN (:block.ctl_memers); --> means WHERE members IN
> ('BUERGI','MERZ','FREI' )
>
> Why does this not work. Or -how can I generate the IN clause reading from a
> field ??
You can't replace a list with a variable. Perhaps you could instead say e.g. WHERE INSTR(:block.ctl_members, member) > 0;
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 16:03:44 CET