Thanks, but I am unable to do that. There is no file datetime stamp because the file does not exist in the directory shown by "show scratch".
Kenny 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 >
