Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which is more practical, cursor adapter or SQL passthrou
Message
From
21/05/2012 06:42:56
 
 
To
21/05/2012 01:59:36
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01543874
Message ID:
01543901
Views:
65
That doesn't explain why SPT is "better" for read only operations and CA for everything else.

>OK, I'll chime in, then.
>
>I've been doing SPT for ten years now, and still do, for many things. Was using remote views as well, and also KrAkin dataclasses on a couple of projects. CA wins outright, simply because it has the level of automatic operation which surpasses that of remote views - the CA can do a lot of it for you - but it's automatic the only way I like it: you can override it anytime you want. And you actually can catch the SQL statements it sends, which you can't do with views. OTOH, it creates these statements for you, which with SPT you have to roll on your own. And it has all the hooks you may want to write.
>
>For me, the CA is the best of both worlds, plus some.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform