Re: PowerBuilder SQL statement problem

In a previous posting, Mario Andreoli (marioa_at_bonk.io.org) writes:
> 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

I would try to include quotations in your variable :lsvNameList.

:lsvNameList := 'John'
 instead of
:lsvNameList := John

Good luck!!!

--
Pierre Jr. Beaudry