>>>As I understand VALIDATE DATABASE checks only Database and rebuild databases index, but it do nothing with tables in it.
>>>
>>>And I want to write universal function to fix database and tables (indexes) in it. But I don't know how many and which tables is in given database. Is there any function like ATABLES(), which put list of tables into array?
>>>
>>>Giedrius
>>
>>ADBOBJECTS("myarray","TABLE")
>
>On a related note, I have a program which sends all DBF's in a directory to an array, uses them exclusively, and simply issues a reindex. However, I have recently had the indexes corrupted without reason, i.e. all indexes are deleted from the CDX.
>
>The program runs on a Citrix WinFrame server (NT 3.51) while the DBF's reside on a Novell 3.12 server. Nothing has changed with the WinFrame nor the Novell server since the program successfully executed over a month ago. Have you encountered this before? Should I consider VREPAIR on the Novell server?
>
>The last error message that I saw was a FoxPro error indicated "File Write Error". The network drive certainly was not write protected, and if the files were read only, how could Fox still delete all the index tags?
>
>Thanks,
>Jack Mendenhall
>RMI

I'm not Novell expert at all and can give just few guesses. When tags are get deleted it's not necessarily means deletion of file, just CDX file gets corrupted but it can be still there. Network environment always posessome threat to data integrityn especially index corruption when server goes down right after data field (part of field expression) changed but before index pointer changed. Any of these situations indicates network problem, the only ways to do something on application side is to have scheduled backup and index recovery program: mild (reindexing) and hard (deleting tags and indexing from scratch with programmatic restoring RI triggers)