I would encourage Kenny to check the file dateTime stamp that shows the same
filename. I expect the file was never overwritten and is one that was
created in that location and the others are in another.
----- Original Message -----
From: "Javier Valencia" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, April 21, 2010 10:01 PM
Subject: [RBASE-L] - RE: Need help on (filename(0)) and Scratch settings -
RBase 7.6.8.3031 for Windows full and compiled versions.
Kenny,
This is the command I use to set my scratch file:
CLEAR VAR vChkFile
SET VAR vChkFile INTEGER = NULL
SET VAR vChkFile = (CHKFILE('C:\TEMP'))
IF vChkFile <> 1 THEN
MD C:\TEMP
ENDIF
SET SCRATCH C:\TEMP
I wrote a little snippet to test the filename(0) function as follows:
-- Code to test FILENAME(0)
SET VAR vFile = (FILENAME(0))
WRITE .vFile
SET VAR vFile = (FILENAME(0))
WRITE .vFile
SET VAR vFile = (FILENAME(0))
WRITE .vFile
SET VAR vFile = (FILENAME(0))
WRITE .vFile
SET VAR vFile = (FILENAME(0))
WRITE .vFile
RETURN
When Irun the code from the R> prompt, I get the following results:
R>run x.rmd
C:\TEMP\4bcfaace.$$$
C:\TEMP\4bcfaacf.$$$
C:\TEMP\4bcfaad0.$$$
C:\TEMP\4bcfaad1.$$$
C:\TEMP\4bcfaad2.$$$
R>run x.rmd
C:\TEMP\4bcfaad6.$$$
C:\TEMP\4bcfaad7.$$$
C:\TEMP\4bcfaad8.$$$
C:\TEMP\4bcfaad9.$$$
C:\TEMP\4bcfaada.$$$
R>run x.rmd
C:\TEMP\4bcfaadb.$$$
C:\TEMP\4bcfaadc.$$$
C:\TEMP\4bcfaadd.$$$
C:\TEMP\4bcfaade.$$$
C:\TEMP\4bcfaadf.$$$
R>run x.rmd
C:\TEMP\4bcfaae4.$$$
C:\TEMP\4bcfaae5.$$$
C:\TEMP\4bcfaae6.$$$
C:\TEMP\4bcfaae7.$$$
C:\TEMP\4bcfaae8.$$$
Which is the expected behavior. Is this where you are getting repeated
filenames?
Also, if you are using the generated names and you have a path with long
names and/or spaces, you definitely need to enclose the expression in
quotes. You might try setting the scratch setting to something simple such
as C:\TEMP and see if that helps. BTW, I am on 7.5.
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
<mailto:[email protected]> [email protected]
_____
From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp
Sent: Wednesday, April 21, 2010 5:25 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Need help on (filename(0)) and Scratch settings -
RBase
7.6.8.3031 for Windows full and compiled versions.
Hello List, I thought I had a pretty good understanding of temp files and
scratch settings but.
Recently, my programs have started having more and more failures to
create
temporary files in several situations for multiple users.
Scratch files are always set to tmp unless I change it during
troubleshooting. I created a button to capture scratch setting to verify
location.
The problem does not start immediately after a new session, reports and
(filename(0)) work as expected as first.
But after a while, (1st issue) printing a very simple report to the screen
with no breaks or eeps results in an error
C:\docume~1\kenny\locals~1\temp\4bcf107f.$$$ not found! This error is
displayed twice even though the report looks OK. These messages are
displayed because I have the error messages set ON in order to report if
no
data found (2059) (error variable stays at 0 even when no data). I
checked
the scratch directory above and there were $$$ files in the scratch
directory but not the one reported in the error.
Once this happened, (2nd issue) I tried running a different style of
report
that captures a select statement or tally to a text file. I test for the
existence of the result of set v vfname text = (filename(0)) and if it
does
not exist, pause for 1, then try again. The loop failed the 5 times it
loops, aborted. Each failure was the same file name exactly. I thought
the
filename is created by/affected by the time (seconds?) but I waited over
an
hour (same session) and it is still failing to create this same exact file
name.
Is there a way to seed this process (filename(0)) with a new filename so
my
users do not have to close and start a new session?
I changed my scratch setting to c:\ and it still reported
C:\docume~1\kenny\locals~1\temp\4bcf107f.$$$ not found! Same file, same
location.
Any Ideas what I have done to cause this or what is happening?
Confused in OKC,
Kenny
