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