Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error and tables corrupted after reindexig
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Titre:
Error and tables corrupted after reindexig
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Divers
Thread ID:
01659599
Message ID:
01659599
Vues:
54
Hi there,

I have been using the database-toolkit in alot off apps to update
the structure of tables, to reindex and to repair them if necessary.
In my newest app the updatimg of the tables works well but the
indexing of the tables in the database destroys some tables and
adds indexes to some tables on some fields which are not intended to be.

Thie is the code I use:
cDatabase = oApp.cDatalocation + oApp.cDatabase
open database (cdatabase)
ot = newobject("dbcxmgr","d:\stonefield\sdt\source\dbcxmgr.vcx","",.F.,oApp.cDatalocation)
ot.setdatabase(dbc())
ot.osdtmgr.reindex('ALL!ALL',.T.)
release ot
close database
if plusesprache
   cMess = readini("DBREORG","FERTIG",oGSprache.messini)
else
   cMess = "Fertig"
endif      
messagebox(cMess,64,cProgtitle)
The only two differences to other apps are:

- It uses VFP9
- It uses autoincrement-integers

can anybody tell me what I am doing wrong?

Thanks in advance

Thomas
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform