I solved a particularly difficult Internal Consistency Error and wanted
to share it with you all in case it will help someone in the future.
When saving a new record in an application the error popped up and
closed down VFP.
I will skip over all of the things I tried to fix it like Stonefield
because none of them worked.
Step 1 was to validate database. It showed that one table could not be
reindexed. I deleted the CDX and rebuilt it manually and when I went to
save, it said that the primary key was violated and deleted the primary
key index.
I did a select on the primary key to see if there were any duplicates
and the answer was yes. One record was repeated twice. I deleted the
duplicates, packed the table, and created the primary key.
That solved the problem.
Unanswered questions, how did a record get repeated twice without
throwing some sort of primary key violation? Once the records were
repeated, VFP silently deleted the primary key index. The application
wanted that primary key index to add a record and shut down when it
didn't find it, displaying an Internal Consistency Error dialog.
I hope this helps someone in the future.
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
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.
