Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fatal Exception Error
Message
From
05/01/2005 06:04:23
 
 
To
05/01/2005 05:42:20
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00974310
Message ID:
00974328
Views:
33
Have you tried a complete rebuild of both the table and the index? I have seen situation where both a table and it's index seems to be ok, and even a pack and/or a reindex did not fix it. To rebuild the table completely, you have to copy the file twice
lcSafety=SET('SAFETY')
SET SAFETY OFF
USE myTable EXCLUSIVE
COPY TO dummy WITH CDX
USE dummy
COPY TO myTable WITH CDX
ERASE dummy.*
IF lcSafety='ON' && I hate the macro &, so I never use it unless absolutely necessary
  SET SAFETY ON
ENDIF
NB! VFP8 and VFP9 have better error checking of your tables/indexes!


>Thanks Tore, i'm happy to listen to any suggestions that can help resolve it.
>
>If it was a hardware\cabling problem why would it only ever effect one table?
>
>I have seen before where backup software or virus software can screw the indexes but because its only happend to one table i dont believe it can be that.
>
>Jon
Previous
Reply
Map
View

Click here to load this message in the networking platform