General information
Title:
Cursoradaptor parameters
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only