On 11/21/11 14:39, Sytze de Boer wrote:
> What do you recommend ?
>
> When my system opens it checks for a couple of CDX files
> If it can't find them, it automatically re-indexes all files
> In this instance, my error routine checks if its error 1707 and if so,
> "return"
>
> Occasionally, the system needs to open a table which was not auto-reindexed
> (and for which the CDX was "lost")
> When a user tries to open this table, it results in a "no table is open"
> error
>
> Do any of you have this type of occurrence and what do you recommend
My startup file checker checks for _all_ CDX's, not just a few, and
rebuilds any that are missing. (Does not "re-index", builds a complete
new one.) The cure for all suspected indexing problems is then simple;
"Delete the .cdx and re-start the program."
My ErrTrap routine contains this:
if error() = 1707 or upper(message(1)) = "STRUCTURAL CDX FILE NOT FOUND."
*-- ignore it, because our programs will build the index.
retry && which will open the file
endif
..which I think is the same thing you do.
Note that building all index files anew has a valuable by-product;
documentation of all index tags in a single spot.
Dan Covill
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
