Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which table failed the Reindex?
Message
 
 
À
20/12/1999 15:40:00
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00306399
Message ID:
00306643
Vues:
21
>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
       * Updating of table failed code here
    endif
endfor
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform