Fred: Nope. It is skipping inserting records into the SQL table.
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 4:15 PM, Fred Taylor wrote:
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/[email protected]
** 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.
