Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when rebuilding index using SDT
Message
From
19/12/2006 14:00:59
 
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178286
Message ID:
01178941
Views:
20
Hi Dmitry.

>When I reindex all tables, using syntax:
>
>
>lRetVal = oMeta.oSDTMgr.Reindex("MYDATABASE!")
>
>
>and one of the indexing fails, the oMeta.oSDTMgr.cAlias shows the alias of the very last table in the list of tables and not the one that failed. Do you have any suggestions as to how to find out/report to the user which table index failed?

You'll have to reindex them one at a time, such as:
lnTables = adbobjects(laTables, 'TABLE')
for lnI = 1 to lnTables
  llReturn = oMeta.oSDTMgr.Reindex(laTables[lnI]
* handle llReturn .F.
next
Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform