Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error and tables corrupted after reindexig
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Error and tables corrupted after reindexig
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01659599
Message ID:
01659599
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform