Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unatended index recreation
Message
From
10/08/2001 06:12:52
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
08/08/2001 15:10:51
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00541136
Message ID:
00542185
Views:
23
>>
>>open database myData
>>use myTable
>>delete tag all                   && Either this or 'index...' line cause
>>*...
>>index on Something tag Something && Database is invalid. Please validate
>>
>>And yes it's invalid for one of tags in cdx is missing from DBC.
>>
>>
>>open database myData
>>use myTable
>>on error retry
>>delete tag all
>>on error
>>*....
>>on error retry
>>index on Something tag Something
>>on error
>>
Works as an 'ignore and do it' case (and really I want to ignore and proceed.)
>>Question is can somebody think a 'silent' and non 'lowlevel hacking' way of doing this w/o 'on error ...' ?
>>
>>PS : validate data recover works but not is silent. This is for unattended mode.
>>TIA
>>Cetin
>
>Would a hidden form with bogus Error method code work? It would just return to the next command after executing Error().

Yes J,
It would but I didn't want to rely on error at all.
delete tag all
unexpectedly doesn't work all the time and with or w/o error it doesn't clear all tags all the time. I took a more radical route and directly erase .CDX files (play with DBC a little first). Longer route but works 100% w/o error.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform