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


> > Hi guys,
> >
> > I just have a couple of quick question regarding the Buffering mode :
> >
> > currently I use =
> >
> > 1. For the Master form = I use buffering mode 5.
> > For the Transaction form = I use buffering mode 3 for the header table
> > and buffering mode 5 for the detail table.
> >
> >
> > is this allright..? It's because I read in some vfp books thats says we should
> > always use buffering mode 5
> >
> > 2. In my older application,
> > In my transaction form. I use only TABLEUPDATE AND TABLEREVERT --WITHOUT -- BEGAN AND END TRANSACTION.. and buffering mode 5 for both header and detail table.
> >
> > it works fine for a couple years ( single user )
> > however when it is being used by multi user.. It seems have to loose some data in monthly basis. Like twice a month
> >
> > Can someone explain this..? it's because the BUFFERING MODE or because of the MISSING BEGAN AND END TRANSACTION...?
> >
> > thank you so much..
>
> 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..

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