Dan, really appreciate your comment A difference in your return is in my error return if the error is 1707, I RETURN from the error prg You do a RETRY Will that make a difference ?
On Tue, Nov 22, 2011 at 12:05 PM, Dan Covill <[email protected]> wrote: > 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 > [excessive quoting removed by server] _______________________________________________ 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/cag1nny_vay_camewu7adxy5swozdiryr_bpkyccjienowft...@mail.gmail.com ** 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.
