>>
>>There are such and such experts. I know a lot doing SET FILTER. Don't need to argue on that. :)
>>
>>I will look at changing the SQL on the fly. Go you alter the SELECTCMD of the CA? Or do you argue about variables to parameter a where clause? I can not set up a higher ten possible fields to query. Not for a single "=" comparsion and not on a variety of LIKE = == $ INLIST operators. 6 parameters per field, ICASE to determine? VFP's SQL engine will die with C0..05 on complexity. That I know for shure. SET FILTER uses only the active ones or none, that's a lot faster and less complex.
>
>
>I do not alter the SELECTCMD. BeforeCursorFill has a cSelectCmd parameter that you can provide to fill the cursor (by the default the SelectCmd itself).
Ah! You alter the cmd that gets into action. Now that I think of it I do this with a SQL Update in a special situation. Thanks for clarification.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]