Thanks - that answered my question. I was trying to combine in one parameter
thanks you!
bonnie
>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
Previous
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