[sqr-users] Passing Variables to Inline Views

[CARFREH1@Nationwide.com]

Here is a problem I am running into right now:

begin-select
.
.
.
from table_a a,
          table_b b,
          (select col1, col2, col3 col4
           from table_c, table_d
           where col5 in $var1) c
where
.
.
.
This will not pass the var1 values ('aaa','bbb','ccc'...) into the inline
view properly as no data is returned. however if a single value is passed:
      where col5 = $var1
It works fine.

I have tried messing with single quotes, [ and ] and [$where] clauses and
none have worked.  Could really use some help at this point.



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users