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