Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack corrupts database
Message
De
18/03/2005 18:12:14
John Tomblin
Service Station Systems, Inc.
San Jose, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Pack corrupts database
Divers
Thread ID:
00997512
Message ID:
00997512
Vues:
73
I use a simple procedure to pack all tables in the database:

open database v:\data\dlog3\DlogData exclusive
TableCount = adbobjects(Tbls, "Table")

for ctr = 1 to TableCount
use Tbls[ctr] exclusive
pack
endfor

When run from Foxpro (compiled into the exe), this works just fine.
When run from the runtime most of the indexes are corrupted: left with 0 bytes and the tables cannot be opened again. "Index does not match... delete index file ..."

I thought that this was probably something wrong in the DBC so, I created a new DBC, added all of the tables, added settings, stored procs, etc. Same results on the new database.

Any ideas? Do others experience this? Is it a known bug? Is there a solution?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform