Jim,
I'm using the standard single quote for R:Base - I hadn't even thought about
using "erase", "del" is just the DOS command that works in R:Base. Maybe if
you're trying to future-proof your code, though, you should stick to what
you're doing - if Mr Gates is going to remove DOS from Windows...
Regards, Alastair.
----- Original Message -----
From: "Jim Limburg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 9:11 PM
Subject: Re: Win2k - (ENVVAL('TEMP')) and spaces in this setting --
warning/headsup/solution
> Alastair
>
> I tried your DELETE command and it seemed to work, but the documentaion
says
> to use ERASE for getting rid of files. DELETE is a SQL command for getting
> rid or rows in tables and so on...
>
> With the ERASE command the single quote method seems to work flawlessly...
> that is with my revised code.. I had sent some bad code the first time
> through...
>
> Maybe this depends on a persons QUOTE setting... Are you using a
double-quote
> instead of a single-quote as your database default for the QUOTES setting?
>
> Interesting.
> Jim
>
>
> --- Alastair Burr <[EMAIL PROTECTED]> wrote:
> > Jim,
> >
> > I don't know if it helps or if you know already and it doesn't work for
what
> > you're trying to do but double quotes around the path/filename should
> > resolve the problem:
> >
> > set var vFileName text = ' " d:\blah blah blah\blah.fle " '
> > del .vFileName
> >
> > works in RBW6.5 under W98 (I've left spaces around the quotes to try and
> > make them stand out more).
> >
> > Regards, Alastair.
> >
> >
> > ----- Original Message -----
> > From: "Jim Limburg" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, February 15, 2002 7:07 PM
> > Subject: Re: Win2k - (ENVVAL('TEMP')) and spaces in this setting --
> > warning/headsup/solution
> >
> >
> > > I apologize, there was a good boo-boo in the code I had earlier.
> > > Here is the corrected version.
> > >
> > > SET VAR vm_temp TEXT = NULL
> > > SET VAR vm_temp = (ENVVAL('TEMP'))
> > > IF vm_temp IS NOT NULL THEN
> > > --This will store temp files in Windows/Temp directory on a Win98
> > machine
> > > --On NT or 2000 it will be in the WINNT/TEMP dir or depending on how
> > > --security is set up it could be defined like:
> > > --C:\Documents and Settings\jlimburg.TCORPNT1\Local Settings\Temp
> > > --This presents a problem because it has a space in the line so it
> > > --needs to be put between single quotes to work.
> > > SET VAR vm_locatespace = (SLOC(.vm_temp,' '))
> > > IF vm_locatespace > 0 THEN
> > > SET VAR vm_temp1 = ((CHAR(39)) + .vm_temp + (CHAR(39)))
> > > SET VAR delfiles TEXT = ('ERASE ' + (CHAR(39)) + .vm_temp + '\' +
+
> > > '*.$$$' + (CHAR(39)))
> > > ELSE
> > > SET VAR vm_temp1 = .vm_temp
> > > SET VAR delfiles TEXT = ('ERASE ' + .vm_temp + '\' + '*.$$$')
> > > ENDIF
> > > SET SCRATCH &vm_temp1
> > > SET ERROR MESSAGES 2926 OFF
> > > SET ERROR MESSAGES 2077 OFF
> > > &delfiles
> > > SET ERROR MESSAGES 2077 ON
> > > SET ERROR MESSAGES 2926 ON
> > > ELSE
> > > SET SCRATCH ON --This will store temp files in the current directory
> > > SET VAR vm_temp = (CVAL('CURRDIR'))
> > > SET VAR vm_locatespace = (SLOC(.vm_temp,' '))
> > > IF vm_locatespace > 0 THEN
> > > SET VAR delfiles TEXT = ('ERASE ' + (CHAR(39)) + .vm_temp + '\' +
+
> > > '*.$$$' + (CHAR(39)))
> > > ELSE
> > > SET VAR delfiles TEXT = ('ERASE ' + .vm_temp + '\' + '*.$$$')
> > > ENDIF
> > > SET ERROR MESSAGES 2926 OFF
> > > SET ERROR MESSAGES 2077 OFF
> > > &delfiles
> > > SET ERROR MESSAGES 2077 ON
> > > SET ERROR MESSAGES 2926 ON
> > > ENDIF
> > > CLEAR VAR vm_%, delfiles
> > > SET FILES 60
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Got something to say? Say it better with Yahoo! Video Mail
> > > http://mail.yahoo.com
> > > ================================================
> > > TO SEE MESSAGE POSTING GUIDELINES:
> > > Send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: INTRO rbase-l
> > > ================================================
> > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > > ================================================
> > > TO SEARCH ARCHIVES:
> > > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
>
> __________________________________________________
> Do You Yahoo!?
> Got something to say? Say it better with Yahoo! Video Mail
> http://mail.yahoo.com
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
