deleting DBF files

[blumash]

I run a screen where I need a temporary DBF file ,I create this file during the run of the screen by :

CREATE dbf &user (prdcat c(15), amount n(4), supdat d(8), prcperun n(10))

In some stage of the program I don't need anymore this file & I delete it by :

delete file &user.dbf

for some reason I don't receive any error massage , the file was not deleted , he is still there & I can't find out what's the problem , why is the file not being deleted.

Thank's

 

[alvechurchdata]

The . tells the macro to stop processing. If you've got "Test" in the variable user then the command is coming out as [TT]DELETE FILE Testdbf[/TT].

You need two periods. Try this to see what I mean:

user = "Test"
USE &user.dbf      && Error message "Can't find file Testdbf"
USE &user..dbf     && Test.Dbf opens

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[JRB-Bldr]

You might have more reliable results if you used fully-pathed macro substitution variables such as:

mcStartUp = SYS(5) + SYS(2003)
mcDBF = mcStartUp + "\Temp\User.dbf"

CREATE DBF (mcDBF) (prdcat c(15),;
                 amount n(4),;
                 supdat d(8),;
                 prcperun n(10))

<Do Whatever>

SELECT User
USE
ERASE (mcDBF)
* If you have created an Index on the DBF, don't forget to erase the CDX file as well.

One side note: I find that in a multi-user environment it works best if I have all of my Temp files created on the local workstation rather on the server (default drive/directory) so that there is no conflict/over-write from other concurrent users.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[crewchiefpro6]

Sounds like you could create a cursor which will automatically be deleted when you exit foxpro.

instead of create dbf try this:

create cursor user blah blah blah

you can use them like a dbf if you include readwrite at the end also.

 

[blumash]

Thank's guy's , I silved the problem , the advice of alvechurchdata was helpfull , in the delete file..... I put 2 dots instead of 1.

Thank's again

 

[alvechurchdata]

The double-dots solve the immediate problem but CrewChief's idea might solve a lot of future problems too.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dbMark]

Also, you don't have to use macrosubstitution. Here is faster equivalent code:

DELETE FILE (user+".dbf")

dbMark