PDA

View Full Version : ZEROFILE COMMAND



Hanna Philippi
25-Jan-2005, 11:46 AM
Hi Again

I recently converted one accounting application from version 3.01c to
version 3.2
Some of the reports used previously saved the records in a temp file that
would be exported to dbf file for other uses
my reports uses in the past the zerofile command on the temp file that is
not available anymore in cersion 3.2(I presume).
What is the best way to erase the data from the temp file instead of loop
and delete?

thks

David Martinko
25-Jan-2005, 12:33 PM
Use the attached package... and then use the line below. Replace "MyFile"
with the filename you wish to use.

Send Add_Tempfile MyFile.File_Number

What it does... it creates a copy of a datafile from your filelist to a
temporary folder on your C:\Temp. When your program exits, the tempfile is
removed also. By using the Send Add_Tempfile, it creates a new empty copy of
the file and opens it for the local user only. No need for zerofile, just
send add_Tempfile again and it's empty again.

This pkg may not work for you if you are using df3.2, it was written for
VDF10. Some of the commands are the same so you may be able to reverse
engineer it for your df3.2 system... I hope you have or are moving it to VDF
soon, though.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com

"Hanna Philippi" <hphilippi@icecorp.ca> wrote in message
news:uhZEc1vAFHA.1912@dacmail.dataaccess.com...
> Hi Again
>
> I recently converted one accounting application from version 3.01c to
> version 3.2
> Some of the reports used previously saved the records in a temp file that
> would be exported to dbf file for other uses
> my reports uses in the past the zerofile command on the temp file that is
> not available anymore in cersion 3.2(I presume).
> What is the best way to erase the data from the temp file instead of loop
> and delete?
>
> thks
>
>

Ben Weijers
25-Jan-2005, 02:28 PM
I don't know why you think zerofile is not supportd in 3.2, it is. There is
a difference though. In order to use zerofile in 3.2 you must open the table
exclusive.

Regards,

Ben Weijers
Data Access Worldwide