>>>>>Whatever a view can do, CA does, plus twice as much with half the overhead.
>>>>
>>>>How is it half the overhead?
>>>>
>>>>If I have to see, say, the customer name associated with an invoice as well as the amount, why is a CA more efficient than using a view?
>>>
>>>1. don't need the dbc
>>>2. can do it all in code (prgs), and you only need pass the handle. Don't need the named connection (aka DSN) to edit it.
>>>2.b you can subclass your CA's at will, can't do that with views.
>>
>>1. I don't need a dbc to use a SQL view from VFP.
>>2. I create a handle once when opening the program and use it for all SQL operations. I started with DSN's so I still use them but I've used DSNless connections (all .prg) in later apps.
>>
>>3. Never saw a need to subclass a SQL view.
>
>Oh, I meant comparison with VFP-side views. As for SQL views, there's still the matter of what you use VFP-side to connect to them. Even there you still have the choice.
OK. I never used a VFP View.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.