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

Try this:

 CURSOR member_cur IS
[Quoted]    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