Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: jon bing
  
 Surabaya
 
 jon bing
 Tags
Subject: RE: Buffering mode
Thread ID: 310612 Message ID: 310797 # Views: 25 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Friday, June 24, 2011 12:54:17 PM         
   


> >
> > Does this mean that your useras work directly with editing your main data tables, Master and Transaction?
> > In accordance with the VFP recommendations the user should work on an updatable cursor representing a suitable subset of the storage tables. These cursors are local views or CursorAdpater objects. The source tables are not buffered, the cursors are. TableUpdate() passes the modifications back into the source tables. If the tables are interdependant a tranaction can be applied so one can roll back if either update fails.
> >
> > -Anders
>
> I never use the local view, I use the table as data environment and put the buffermode for that table. I guess it's not the right way.. well I will try to check it out again.. Thank you Anders..

An advantage of using the VFP paradigm of views is that is makes it a much easier to switch to a remote ODBC or OLEDB connected SQL database for storage and integrity and security.


-Anders

ENTIRE THREAD

Buffering mode Posted by jon bing @ 6/23/2011 1:47:44 AM
RE: Buffering mode Posted by Stefan Wuebbe @ 6/23/2011 9:30:40 AM
RE: Buffering mode Posted by jon bing @ 6/24/2011 1:51:59 AM
RE: Buffering mode Posted by Anders Altberg @ 6/23/2011 12:20:10 PM
RE: Buffering mode Posted by jon bing @ 6/24/2011 1:54:39 AM
RE: Buffering mode Posted by Anders Altberg @ 6/24/2011 12:54:17 PM