If you do a RECCOUNT() and then increment a variable counter in the SCAN, do you arrive at the same number of records?
Fred On Thu, Jan 2, 2014 at 4:07 PM, Jeff Johnson <[email protected]> wrote: > HNY Fred! Set deleted is on but there are no deleted records in the > source table. There is no active filter and no index file. > > > Jeff > > Jeff Johnson > SanDC, Inc. > (623)-582-0323 > > www.san-dc.com <http://www.san-dc.com> > www.cremationtracker.com <http://www.cremationtracker.com> > www.arelationshipmanager.com <http://www.arelationshipmanager.com> > > > On 1/2/2014 3:57 PM, Fred Taylor wrote: > >> Corrupted index or active filter? SET DELETED? >> >> Fred >> >> >> On Thu, Jan 2, 2014 at 3:50 PM, Jeff Johnson <[email protected]> wrote: >> >> I am scanning a dbf and inserting records into a sql server table. For >>> some reason for the first half of the table it is skipping 440 records. >>> After half way through it is up to date. >>> >>> Immediately after I load the table I do a select on it and that tells me >>> I >>> skipped all of those records. >>> >>> I don't know if it skipped the records or my subsequent query is not >>> selecting all of the records. >>> >>> Any ideas? >>> >>> -- >>> >>> Jeff >>> >>> Jeff Johnson >>> SanDC, Inc. >>> (623)-582-0323 >>> >>> www.san-dc.com <http://www.san-dc.com> >>> www.cremationtracker.com <http://www.cremationtracker.com> >>> www.arelationshipmanager.com <http://www.arelationshipmanager.com> >>> >>> >>> >>> >>> --- StripMime Report -- processed MIME parts --- >>> multipart/alternative >>> text/plain (text body -- kept) >>> multipart/related >>> text/html >>> image/jpeg >>> --- >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksq5gfy3iv-pujm-hiezi0ix--ap+avs6wm3upcs_i0...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
