Carl Karsten wrote: > Uwe Grauer wrote: >> Ed Leafe wrote: >>> On Mar 30, 2007, at 5:03 PM, Uwe Grauer wrote: >>> >>>> may i ask what a "VFP remote view" is? >>>> Is it just like a view (create view a_view(...)) in database terms >>>> or is this some sort of special VFP related term? >>>> If it is a view in database terms, it would be just like a table. >>> It's a VFP thing. Local views go against local Fox tables; remote >>> views work with servers such as Microsoft SQL Server or MySQL. There >>> is a lot of stuff besides a SQL definition: parameters, updating >>> information, etc. >>> >> So it is something like a simulation of a database view? >> > > like, yes. but different :) > > read http://fox.wikis.com/wc.dll?Wiki~VfpViews~VFP > > and feel free to ask questions. I need more discussion on the subject to get > a > better feel for what is is that is so great. they are great, but they have > some > rough edges too. which have been softened with tools and techniques, but > sometimes that drives things into an odd place. > > I want something like them for Dabo, but not sure what.
The biggest flaw in VFP's views is that they are tied to a DBC, which by default are shared by who knows how many people. And querying a view results in VFP wanting to write information to the DBC, which can result in "view definition has been changed" errors for other people and poor performance. The code associated with views needs to be compiled, which is also saved in the dbc. A huge mess, if you ask me. Local views are somewhat manageable, but why use remote views when SQL Passthrough is available and so much faster. -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users
