FoxPro/DOS 2.6 error if no .CDX file - 07-23-2010 , 08:04 PM
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
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.
P.S. I rtfm!
Re: FoxPro/DOS 2.6 error if no .CDX file - 07-24-2010 , 03:04 PM
On 24.07.2010 03:04, John R. Sowden wrote:
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')
Re: FoxPro/DOS 2.6 error if no .CDX file - 07-29-2010 , 07:09 AM
John R. Sowden <jsowden (AT) americansentry (DOT) net> was inspired to say
CDX and rebuilds the index. That's worked for me.
 Such as a member of staff deciding that the data is there
and they'd look at it using Excel!