In the event that the .CDX file does not exist, opening the .DBF
_usually_ causes an error-enough to stop the program. I have been
looking for a way to keep this from happening, such as an argument in
the 'use' command that instructs foxpro to ignore the missing .CDX
file.

Of course I can, and do, test for the existence of the appropriate
files, but I want to recover in the process, not get a call that the
program does not work.

Thanks,

John

P.S. I rtfm!

On 24.07.2010 03:04, John R. Sowden wrote:
Hi John,

IIRC, something like this used to work in Fox 2.x:

lcError = On('Error')
ON ERROR *
USE theTable ALIAS theAlias && IN 0 SHARED AGAIN
ON ERROR &lcError
llSuccess = USED('theAlias')



hth
-Stefan

John R. Sowden <jsowden (AT) americansentry (DOT) net> was inspired to say
When I've had similar problems[1] I've added a routine that deletes the
CDX and rebuilds the index. That's worked for me.

[1] Such as a member of staff deciding that the data is there
and they'd look at it using Excel!

Mike