On Thursday, November 11, 2010 06:36:30 pm Paul McNett wrote: > On 11/11/10 5:29 PM, John Fabiani wrote: > > On Thursday, November 11, 2010 05:04:25 pm Paul McNett wrote: > >> On 11/11/10 5:01 PM, John Fabiani wrote: > >>> Wait - just re-thinking a bit. After the new() the RowCount should > >>> again report zero (unless "ss" is the default). > >> > >> I think the filtering should happen when filter() is called. > >> > >>> Hmmm - of course I think the RowCount should follow the filter. > >> > >> So if you've filtered on a field value and then you change the value of > >> that field in one of the records, you want that record to get filtered > >> out immediately? I think that would be user-hostile. > >> > >> Paul > > > > Maybe - but that's how I think - the filter would still apply as far as > > RowCount is concerned. > > You want RowCount to have special treatment? So even though there are 4 > records, including one that no longer matches the filter, you'd want > RowCount to report 3? > > I'd like some of what you are smoking, John! :) > > Paul
depends: 1. RowCount reports 2 2. set filter RowCounts reports 0 3. new() - RowCount reports 0 4. set the value to the filter in the new record - RowCount reports 1 5. remove the filter RowCount reports 3 In above case the RowCount is following the filter. And I guess you believe that might be user-hostile. But RowCount could also follow the real table. In that case it would report 1. RowCount reports 2 2. set filter RowCounts reports 2 3. new() - RowCount reports 3 4. remove the filter RowCount reports 3 So in my mind the question is does RowCount reports the actual number of rows or not when a filter is applied. An added question would be - how does scan work with filtered tables after adding a new(). It's been so long since I dealt with VFP filters I can't recall how they worked. But I do not recall having any issues with row counts of a filtered table. What do the other ORM's do with filters with respect to row counts and scan. Like you said when Ed returns he'll provide his thoughts. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
