>>>#DEFINE ALL_LOC "(All)"
>>>
>>>lcColor = IIF(THISFORM.cboColors.VALUE = ALL_LOC, "", ALLTRIM(THISFORM.cboColors.VALUE))
>>>
>>>REQUERY("your_view")
>>
>>
>>It works when I change the variables by hand to "", but when i send
>>the value "" in the program I get a data type mismatch. (My key
>>values are integers). I cant see why it works one way
>>and not the other...
>
>Christopher,
>
>I don't know why it's not working with integers I haven't tested this situation. In SQL the wildcard % would work with both char and int data, not sure how to deal with this in FP.
>
>Kim
As far as I know Wildcards can be used for Character expressions only.
Edward Pikman
Independent Consultant