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

Oops! I'm wrong. I misunderstood, sorry ...

Use string operations.

Valery A. Sorokin wrote:
>
> Try this:
>
> CURSOR member_cur IS
> SELECT member, salary
> FROM all_member_table
> WHERE UPPER(member) = UPPER(:block.ctl_members);
>
> I hope this will help you.
>
> Buergi Josef 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 ??
> >
> > Regards, Josef
> >
> > josef.buergi_at_ascom.ch
>
> --
> Valery A. Sorokin
> ProSoft, Russia, Moscow, Information Systems Division
> Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
> E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
> http://www.dd.ru

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru