In addition to what Bernard replied, about the best you do to parameterize your in list is:
WHERE History in (?nParm1, ?nParm2)
If you only need 1o match one value, set nParm1 and nParm2 to that same value.
>I am just jumping in to Cursoradaptors and have set up a DE class containing a few CA's. My data is in SQL server. I'm trying to set a parameter in one of my CA's for a logial (SQL bit) field. What I really want is
>
>select names from employees where history in (0,1)
>
>sometimes I just want the 0's and sometimes I just want the 1's so...
>
>select names from employees where history in ?cParameter
>
>This doesn't work when I set:
>
>cParameter='(0,1)'
>cParameter='(0)'
>
>Also, is there anything like macro substitution in the arena?
>
>thanks
>
>bonnie
Mark McCasland
Midlothian, TX USA