>Looking at my error handling code to try an research a "locking up" problem. Seeing if any errors produce no message and then do a retry. the 1707 error does a retry without an error message. 1707 is "The structural index file associated with a table file could not be found." Any thoughts on why there would be a retry on a 1707?
>
>Thanks
>
Brenda,

The RETRY command forces the table to be opened and removes the reference to it in the table if the structural index isn't found. Any references to the index (such as SET ORDER TO TAG...) thereafter will generate a different error. If the error handler is well written, it then probably will jump through a routine to re-create it.