Yes we're sure the temp file belongs to our VFP application.
Deleting the temp file is only possible if you kill the application otherwise it is in use.

It's not quite sure which sql command causes the problem, but there should only be simple select (joins, unions, ...), insert, update and delete commands - nothing really special.

>Robert,
>
>>On one machine (only one!, it's a Windows 2000) one tempfile is nearly 2 GB in size.
>>Due to this huge tempfile the application hangs.
>>
>>As mentioned before this is can only be monitored on this one machine.
>>
>>Did anybody ever come over such a strange behaviour before or know how to fix it?
>
>Are you sure the temp file belongs to VFP? When the app crashes I assume the temp file doesn't clear out. Have you tried deleting it?
>
>Is it possible that that use has run some code that has a SQL statement that is doing something like a cartesian product?