Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: NOFILTER?
Thread ID: 310763 Message ID: 310844 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Sunday, June 26, 2011 12:36:06 AM         
   


> Hi Russell,
>
> >
> > Hi Boris,
> >
> > Sorry but there is something I'm not getting here.
> >
> > I do have a READWRITE clause as I need it to overcome the error:
> >
> >
> >
>
> (You do not get that error since you do use ReadWrite already, right?)
>
>
>
> > I am not adding any additional fields but I am adding another record with INSERT.
> >
> > So, in this situation, am I ok with just READWRITE rather than READWRITE NOFILTER?
> >
>
> I'd take it that way:
> If you want to get a writable SQL result cursor, you'd use the ReadWrite clause.
> If you want to make sure that the DBF('resultCursor') actually is a temporary file, as opposed to eventually being the From table DBF itself, you'd use the NoFilter clause.
> If you want both, you can use both if you find that way more readable. But technically you do not necessarily need a "NoFilter" if there is a "ReadWrite" clause, since VFP would "no(t)filter" in that case anyway.
>
>
> hth
> -Stefan

Ok - thanks Boris and Stefan.

ENTIRE THREAD

NOFILTER? Posted by Russell Hill @ 6/24/2011 7:57:00 AM
RE: NOFILTER? Posted by Borislav Borissov @ 6/24/2011 8:18:00 AM
RE: NOFILTER? Posted by Russell Hill @ 6/24/2011 8:29:57 AM
RE: NOFILTER? Posted by Borislav Borissov @ 6/24/2011 8:37:07 AM
RE: NOFILTER? Posted by Russell Hill @ 6/24/2011 11:33:38 AM
RE: NOFILTER? Posted by Stefan Wuebbe @ 6/24/2011 12:26:54 PM
RE: NOFILTER? Posted by Russell Hill @ 6/26/2011 12:36:06 AM
RE: NOFILTER? Posted by Mike Yearwood @ 6/25/2011 7:02:04 PM
RE: NOFILTER? Posted by Tamar Granor @ 6/25/2011 7:18:27 PM
RE: NOFILTER? Posted by Mike Yearwood @ 6/25/2011 7:45:47 PM
RE: NOFILTER? Posted by Tom Saddul @ 6/27/2011 5:49:34 AM
RE: NOFILTER? Posted by Samir H. @ 6/27/2011 6:05:59 AM
RE: NOFILTER? Posted by Tom Saddul @ 6/27/2011 1:19:56 PM
RE: NOFILTER? Posted by Russell Hill @ 6/26/2011 12:38:34 AM
RE: NOFILTER? Posted by Tom Saddul @ 6/26/2011 3:40:20 AM
RE: NOFILTER? Posted by Russell Hill @ 6/26/2011 1:46:36 PM
RE: NOFILTER? Posted by Samir H. @ 6/26/2011 2:35:17 PM
RE: NOFILTER? Posted by Russell Hill @ 6/26/2011 11:10:49 PM
RE: NOFILTER? Posted by Jun Tangunan @ 6/27/2011 2:23:20 AM
RE: NOFILTER? Posted by Mike Yearwood @ 6/27/2011 4:06:05 AM
RE: NOFILTER? Posted by Jun Tangunan @ 6/27/2011 5:24:15 AM
RE: NOFILTER? Posted by Mike Yearwood @ 6/27/2011 9:49:47 PM
RE: NOFILTER? Posted by Mike Yearwood @ 6/27/2011 9:53:19 PM
RE: NOFILTER? Posted by Jun Tangunan @ 6/28/2011 1:31:56 AM
RE: NOFILTER? Posted by Mike Yearwood @ 6/28/2011 2:17:07 AM
RE: NOFILTER? Posted by Jun Tangunan @ 6/28/2011 2:57:26 AM
RE: NOFILTER? Posted by Mike Yearwood @ 6/28/2011 3:43:17 PM