Hi Ria,

You wouldn't have such hard time to find what caused the error if you had decent error handler in place. Take a look at great article 'Error handling in VFP' by Doug Hennig at http://stonefield.com/techpap.html.


>Hi,
>I have a program that has been running perfectly for the last one month. This program extracts data from an HP database to a Foxpro database. It is automated to run as a night job.
>
>But yesterday, the program gave the error 'Invalid subscript reference'. The log files that have been created, gives us a vague idea of where exactly the program crashed. These are the lines of code in which this error had to happen.
>
< snip >