Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 Tags
Subject: RE: NOFILTER?
Thread ID: 310763 Message ID: 310766 # Views: 72 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Friday, June 24, 2011 8:18:00 AM         
   


> Hi all,
>
> I'm running some SQL SELECTs with GROUP BY where I also want to sum the COUNTs and SUMs and INSERT a summation record at the bottom of the result cursor.
>
> This is easy enough and the need for READWRITE is intuitively obvious.
>
> I notice that many people use READWRITE NOFILTER but is this (a) required or (b) useful or (c) just habit?
>
> What does READWRITE NOFILTER do for me in this situation that READWRITE alone would not?
>
> Is the decision to use READWRITE or READWRITE NOFILTER one that should be made on a case by case basis or is there an across-the-board best practice with this decision?
>
> TIA.
>
> Russell.

No,
When you use READWRITE useless is redundant.
Also, there is no need to use NOFILTER if you add an additional field in your SELECT like this:
SELECT *, CAST(0 as int) AS AddField FROM SomeTable

When you use aggregate functions you again may not use NOFILTER.
:-)



-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

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