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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement