Paul McNett wrote: > 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.
include the dbc as part of the exe, and everyone gets a private/local copy and that problem goes away. The code associated with views needs to be compiled, which > is also saved in the dbc. huh? > A huge mess, if you ask me. Local views are > somewhat manageable, but I agree with the messy part, but to me that isn't the essance of a view. > why use remote views when SQL Passthrough is > available and so much faster. A) they aren't significantly faster - the significant hit is server processing and or through put of the result set. B) SPT alone isn't updateable. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users|[EMAIL PROTECTED]
