>Jim,
>
>Hi,
>
>>How are you importing? Is it through APPEND FROM? Is it using IMPORT? Is it using SELECT?
>
>I'm using a do while !eof() routine and passing this data from the source
>tables (order header, order detail) through a filter and recording the results into three tables, customer, order header, order detail.
>
>>
>>Are there many indexes on the table you are importing to?
>
>Yes, there are several indexes in all the three files.
>
>>You may have temp files that are filling up the disk, as soon as you acknowledge the error VFP erases the temp files.
>
>I figured this could be it, but how can I prevent this type of error from happening?. It takes for the whole routine about 7-8 hrs to get completed, I have an error trapping routine, but at one point I have to cancel the process, because doesn't find even room to record the error in my error log.
>
>I there a way to deal with the temp files and empty them somehow?
>
>
>Thanks Jim,
>
GIl,

Can you post soem of the code inside the do loop? Appending and replacing should not build up tmep files the way you are seeing it. BTW, there is no control over the temp files other than where they will be created. Also you may want to replace your do while not eof() loop with a scan. Scan is faster than do while not eof().