>>>Hi everybody,
>>>
>>>I have a cursoradapter class and would like to parameterize the where clause.
>>>
>>>1) Can this be done?
>>>2) How can I do this?
>>>
>>>Thanks in advance.
>>
>>1) Yes.
>>2) Like parametric views. Use ?Var for a parametric variable.
>>
>>Check Thread #
944961>>
>>Cetin
>
>Hi Cetin,
>
>I was just reading this thread. But we have more complicated situation. Basically, I have a search form, and I do not know which fields user is going to fill. I am working with VFP native data, though it doesn't make a difference. So, I need to be able to costruct "where" clause on the fly in the Cursor Adapter. Do you have suggestions how can we accomplish that?
>
>Thanks again.
Not a complex situation, doable since foxpro 1.x.
It doesn't make a difference if that's native or CA or SPT. Prepare your parameters like:
... where nID between ?nMinId and ?nMaxID,;
dDate between ?dMin and ?dMax ....
etc. If parameter known store it to min and max otherwise use possible min and max values.
Cetin