Dynamich WHERE IN (..) List in a Cursor

From: Buergi Josef <josef.buergi_at_ascom.ch>
Date: 18 Nov 1998 15:56:19 GMT
Message-ID: <01be130b$fe210f20$4b7d4f8b_at_rac17217.hasler.ascom.ch>

Hello

[Quoted] I'm trying to do the following:

[Quoted] [Quoted] 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 ??

Regards, Josef

josef.buergi_at_ascom.ch Received on Wed Nov 18 1998 - 16:56:19 CET