I'm having trouble getting my head wrapped around how this works on one
machine but not other
select (fname)
use
dele file &fname
If the variable fname has the format "tmp12345.dbf" the select won't work,
but the delete will.
If the variable fname has the format "tmp12345" the select will work, but
the delete won't.
Tracy
> -----Original Message-----
> From: John J. Mihaljevic
> Sent: Monday, October 16, 2006 2:48 PM
>
> Hi all,
>
> I have a system that creates a temporary file from an SQL
> statement for reporting purposes. I create a temporary filename:
>
> fname="tmp"+right(sys(3),5)+".dbf"
>
> Then I do an SQL Select statement that ends with:
>
> into table &fname
>
> I do all my processing with that temporary file, including
> printing the report, so I know the file is fine. The problem
> lies in deleting the file at the end. I use the following code:
>
> sele(fname)
> use
> dele file &fname
>
> This seems to be working just fine here on my machine, but at
> our plant in Mississippi (where this application is being
> used on a daily basis), they seem to end up with a lotta
> files on their machine that start with "tmp" followed by five
> numbers and ".dbf".
>
> Any suggestions as to why these files may not be being
> deleted on their end? It's not that the program is blowing up
> before the deleting should be happening...the program is
> running through to completion just fine each time. But for
> whatever reason, my temporary files aren't being deleted.
>
> Thanks very much!
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
