>When Reindexing or Repairing "ALL", if the function returns .F., is it possible to know which table(s) were unsuccessful?
There is an oMeta.aErrorInfo array that contains the error information. You might want to do the following sequence:
oMeta.oSdtMgr.ResetError()
oMeta.aErrorInfo=""
oMeta.oSDTMgr.Update("ALL")
The second element of the array has the error message. SDT keeps increasing the size of this array for each error. So aErrorInfo[1,2], [2,2], ..., [n,2] all contain an error message.
To really get at the problem, you may need to loop through all the tables in the DBC and update each separately:
lnRetVal = adbobjects(laTables, "Table")
for i = 1 to lnRetVal
lcTable = laTables[i]
llRetVal = oMeta.oSDTMgr.Update(lcTable)
if NOT llRetVal
endif
endfor
Mark McCasland
Midlothian, TX USA