>>>>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
That's another way to approach this problem but I like the solution by Borislav. I think, we may try tomorrow to work in SelectCmd direction.
If it's not broken, fix it until it is.
My Blog