>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.