>>>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.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.