There are a couple of articles on
www.foxite.com regarding CA's. as well as Other sites. Do a search.
Basically you only need to change the CA's SelectCmd and call CursorFill.
You could also set the CursorSchema property so that SQL's 0/1 is converted to VFP .T./.F.
Also check out the CA builder at
www.mctweedle.com download / files section. This is much better than the VFP one and takes care of the VFP8 255 Chr Property length limit.
Or you could declare your properties in the init of the CA.
Just look at the code the VFP builder generates and also step thru the code so see it in action.
>I am just jumping in to Cursoradaptors and have set up a DE class containing a few CA's. My data is in SQL server. I'm trying to set a parameter in one of my CA's for a logial (SQL bit) field. What I really want is
>
>select names from employees where history in (0,1)
>
>sometimes I just want the 0's and sometimes I just want the 1's so...
>
>select names from employees where history in ?cParameter
>
>This doesn't work when I set:
>
>cParameter='(0,1)'
>cParameter='(0)'
>
>Also, is there anything like macro substitution in the arena?
>
>thanks
>
>bonnie