Hi Ric,

It's good that all is OK :-)

>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