Hi Venelina,

Long time no hear.. hope you are well....

Anyway, it is the CA Adapter by Mark McCaseland and it works great. I have been working through the night and I have found the problem in my syntax:

THIS.cSelectcmdfilter = 'SHEETTYPE = ?cBudget'

Whereas before I had no '?' mark...
Also, I moved the call from the before cursor build to the method which builds the select statement (I am away from my VFP machine so I don't have the correct method name)....

Thanks

Ric

>Hi Ric
>
>How do you use your cSelectCmdFilter property?
>May be you could use parametrized query?
>
>>Hi all.....
>>
>>I am having a bit of bother with teh CA Adapter. I am simply trying to set a filter. I have placed the following in the beforecursorfillevent:
>>
>>THIS.cSelectcmdfilter = 'SHEETTYPE = cBudget'
>>
>>The variable does exist, but every time I try to use a filter (any), the object does not appear to instantiate correctly. Am I putting my filter in the correct place? syntax?
>>
>>Thanks in advance