Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 Tags
Subject: RE: SQL SELECT
Thread ID: 154493 Message ID: 154576 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Tuesday, December 18, 2007 2:31:05 AM         
   


> >
> > I get it. Thanks Andy. Is it best to use NOFILTER or READWRITE or even both together? What's the difference?
>
> NOFILTER forces the creation of a physical cursor file, but the resulting cursor is still read-only. This is a little faster than using READWRITE which also creates the physical cursor but the resulting cursor is updatable.
>
> So if you only need to create this for display - use NOFILTER but if you want to be able to update columns in the cursor directly then use the READWRITE option.
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA

Thats the term - NoFILTER I was looking for, not Buffering.

Bernard

** If you see someone without a smile, give em one of yours :) **

ENTIRE THREAD

SQL SELECT Posted by Russell Hill @ 12/17/2007 9:58:28 AM
RE: SQL SELECT Posted by surinder singh @ 12/17/2007 10:09:34 AM
RE: SQL SELECT Posted by Russell Hill @ 12/17/2007 12:53:57 PM
RE: SQL SELECT Posted by Bernard Bout @ 12/17/2007 11:02:39 AM
RE: SQL SELECT Posted by Russell Hill @ 12/17/2007 12:55:08 PM
RE: SQL SELECT Posted by Andy Kramek @ 12/17/2007 12:41:35 PM
RE: SQL SELECT Posted by Russell Hill @ 12/17/2007 12:53:05 PM
RE: SQL SELECT Posted by Andy Kramek @ 12/17/2007 11:56:56 PM
RE: SQL SELECT Posted by Bernard Bout @ 12/18/2007 2:31:05 AM
RE: SQL SELECT Posted by Russell Hill @ 12/18/2007 8:03:05 AM