Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify DataBase
Message
From
27/09/2002 07:03:40
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00705080
Message ID:
00705134
Views:
10
>When one (or more) structural index missing or invalid there is no way to open table. I want to verify database and rebuild indexes & relations, but when I run VERIFY DATABASE RECOVER NOCONSOLE always some messages appears on screen: (Do I want to delete this or that). Is there a way to suppress this messages ?
>SET NOTIFY is OFF
>SET TALK is OFF
>SET SAFETY is OFF
>
>TIA
>
>
>Boris
I do the following things
1 keep the copy of the 3 files of the data base container with different name included in exe
2 keep 3 included tables
a) the list of the tables with databases names
b) list of the fields ( types, length,widths, etc) ( key form table 1)
c) list of the indexes with expressions ( key from table b)
Whey?
it can be different type of the crush
container can be broken, idexes were broken etc
When I detect error when program start, I can substitute
databace container form 'frosen in exe' one
I compare 'frosen in exe' tables structures, indexes against existing and
make changes according to frosen structure, if it was difference
I do it sometimes , just nothing wrong happend
I have remote client accros the country.
Sometimes , when we shipp new program version, we add tables, change fields ( add fileds) change or add indexes
So we do changes for our users automatically due to new structure
I can send you samples of these tables, program to keep current working structure and restoring it agains existing tables due to new frosen structure
Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform