PowerBuilder SQL statement problem

I'm having a problem in PowerBuilder 3.0a with an embedded SQL statement (running against an Oracle backend):

SELECT first_name
FROM my_table
WHERE col_name IN ( :lsvNameList ) ;

Hardcoded the lsvNamelist variable would look like 'John','Henry','Joe' and so on.
When I try to build this string in a variable and pass that it always returns a
sqlcode of 100 (no data found). Yet if I take the exact same SQL statement and hardcode the variable contents it works??!!

Is there something I'm missing here ????

Thanks

Mario Andreoli
marioa_at_io.org Received on Wed Mar 15 1995 - 15:04:08 CET