>>>We've been writing new VFP apps with SQL-Server backend. We use a cursoradaptor class we built and it's doing what we need it to do. It seems like there are very few people using cursoradaptor. My questions is... What are you all using to retreive, update, etc. data between VFP and SQL-Server?
>>>Thanks,
>>>Mark
>>
>>I use CAs and SPT. NO VIEWS :-)
>>Working with CAs is veery easy nd they are very flexible.
>
>Hi Borislav,
>
>Can you please elaborate more on advanatages of CA over SPT and Remote Views? I had an interview recently and I was also suggesting a use of CAs over SPT because they ease all data related operations. However, I was told, that hiding complexity is not always a good thing and with SPT you have a better control of what's going on.
>
>So I'd really appreciate more comments on this topic.
>
>Thanks in advance.

Naomi, I can't think of the advantages right now, it is almost midnight here ;-)
But one of the biggest advantage, on top of my head, is that with CA you could use ADO, not only ODBC.
Also CA is an object, you could do everything you want with it, like any other objects.
If you create an object based on SPT, you must program all things which are already there in CA. I don't see any differences between that object and CA :-), except DataSourceType of course.
Also in CA you have CursorSchema, in SPT you didn't, you can't map a field types to another (VFP ones). I use it basically because of DateTime fields where I don't need time portion of the field.
Also, I have a principle - Do not reinvent the wheel, just make it better :-).
OK, I will have more control over my class based on SPT, but is that class will be fast as CA?
Did it would have no bugs in it? I don't say CAs doesn't have any bugs, but until now I didn't notice any.
All CAs works as I expect.