Lots records not being posted in table, identity_column shows missing records 
Author Message
 Lots records not being posted in table, identity_column shows missing records
Hello,

I just ran a loop that took records from a FoxPro table and put them in a
SQL Server 7 table. The program is in C++ and it appears to read all the
records from FoxPro but there were 360,000+ rows in FoxPro and only 47,880
in SQL Server. I use an identity_column and it is missing a lot of numbers.
So it appears that SQL Server is getting the records, using up identities
but not posting the records.

Any ideas?

Thanks, Tom



Sun, 29 Sep 2002 03:00:00 GMT
 Lots records not being posted in table, identity_column shows missing records

Tom,

I would guess that the INSERTs are being rolled back because of invalid data.
Can you identify one of the missing rows, and try to insert it manually to see
if it works or not?

------------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.


Quote:
> Hello,

> I just ran a loop that took records from a FoxPro table and put them in a
> SQL Server 7 table. The program is in C++ and it appears to read all the
> records from FoxPro but there were 360,000+ rows in FoxPro and only 47,880
> in SQL Server. I use an identity_column and it is missing a lot of numbers.
> So it appears that SQL Server is getting the records, using up identities
> but not posting the records.

> Any ideas?

> Thanks, Tom



Sun, 29 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. one table with lots of records or more table with less records

2. Record showing in VB but not showing in SQL enterprise manager

3. ADO Updates to SQL Server not Showing, though records affected shows true

4. Select showing missing records

5. how to make new records posting show

6. Counting Records in Table not Connected to Records in Another (SQL Newbie)

7. I am getting duplicate records, I mean everything is duplicate even Access record number

8. Is there any way to show current record/total record number

9. Select not returning records based on Date I am using

10. What am I missing in Data Report SHOW?

11. I am not able to Sort ADO Hierarchical record set data

12. First record in Recordset not shown in DataReport


 
Powered by phpBB® Forum Software