>I have build an application for synchronizing tables between two NT 4 (SP6) servers.
>I use SQL Queries to determine if records on the source server are newer than the records on the target server.
>
>The problem i encounterd is that every morning the message appears : NOT ENOUGH DISKSPACE FOR C:\TEMP\TEMPFILE.TMP although there's 1,95 GB of diskspace.
>
>Due to the large size of the tables the tempfile wil be also large so far i can understand the problem.
>
>The question is :
>Is there a possibility to delete the tempfile without shutting down the application. Trying to delete the tempfile while the application is running is not possible because FOXPRO is using the file.
>
>Does anyone know how to tackle this problem
>
>
>Thanks in advance
>
>Eric de Bruin

Clean up the temp directory when you start your application (check, if file is not used (by fopen, fclose), then delete it). You can also check for free space using George Tasker function from the FAQ section here before doing your query. Finally, make sure, you don't produce a cartesean product...