Re: PowerBuilder SQL statement problem

In article <3k8adp$ga_at_charnel.ecst.CSUChico.EDU>, kelfink_at_ecst.csuchico.edu says...
>
>In article <3k6s4o$k5i_at_ionews.io.org>,
>Mario Andreoli <marioa_at_bonk.io.org> wrote:
>>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
>
 [snip]
>
>Also, though, I think you can use a string array argument to a
>datawindow, and possibly you can get away with what you're trying. I
>haven't personally tried it, though.
>
Yes, I have a DW talking to Oracle7 using a string array variable for the retrieval argument and it works perfectly.

-- 
Cheryl Suter             E-mail to:  chor_at_chevron.com