Re: Dynamich WHERE IN (..) List in a Cursor

Josef,

I'm new to all of this myself but I think you have to use the NAME_IN built-in function.

Something like:

CURSOR member_cur IS
  SELECT member, salary

     FROM all_member_table
    WHERE member IN NAME_IN(:block.ctl_memers);

I hope I have told you correctly. If not search for name_in help.

Best regards,

Ken.

Buergi Josef wrote in message
<01be130b$fe210f20$4b7d4f8b_at_rac17217.hasler.ascom.ch>...
>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 ??
>
>
>Regards, Josef
>
>josef.buergi_at_ascom.ch
>
>
>
Received on Wed Nov 18 1998 - 21:36:35 CET