RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Claudine Robbins
Thanks Buddy. I’ll check it out. From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Thursday, February 02, 2017 5:47 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - ERASE filespec Claudine Try “SET TRACE ON” right before your ERASE and t

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Buddy Walker
Claudine Try “SET TRACE ON” right before your ERASE and then take a look at the variable. Don’t forget to “SET TRACE OFF” right after the ERASE Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, February 2, 20

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Claudine Robbins
Thanks Jan. I tried this to no avail. ☹ From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen Sent: Thursday, February 02, 2017 2:30 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - ERASE filespec Claudine, You can try this (untested). SET VAR vQuo

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Claudine Robbins
I have. What gets me is the fact that it works at the R:> prompt. And it used to work just fine. Are there any SETtings that would affect this command? It acts like it’s a permission issue or a bad Windows update… I haven’t tried Jan’s suggestion yet… From: rbase-l@googlegroups.com [mailto:r

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Buddy Walker
Claudine You could try using & instead of a dot Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, February 2, 2017 3:24 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - ERASE filespec Thanks Dan and Bud

Re: [RBASE-L] - ERASE filespec

2017-02-02 Thread jan johansen
Claudine, You can try this (untested). SET VAR vQuotes = (CVAL('QUOTES')) SET VAR vfilename1 TEXT = NULL SET VAR vfilename2 TEXT = NULL SET VAR vDeleteFileCommand TEXT = ('DELETE ' + .vQuotes +.vfilename2 + .vQuotes) SET VAR vCopyFileCommand TEXT = ('COPY ' + .vQuotes + .vfilename1 + .vQuotes

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Claudine Robbins
Thanks Dan and Buddy, ERASE or DELETE get the same result. No spaces in filename2. Both filename1 and filename2 are UNC. Commands work at R:> prompt… From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Thursday, February 02, 2017 2:01 PM To: rbase

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Buddy Walker
Sorry send button to easy to hit :) If the filename2 contains spaces then you will need to enclose in filename2 in quotes. Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, February 2, 2017 2:36 PM To: rbase-l@googl

RE: [RBASE-L] - ERASE filespec

2017-02-02 Thread Buddy Walker
Claudine Does your filename2 contain spaces? Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, February 2, 2017 2:36 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - ERASE filespec Hello all, I’m having a

[RBASE-L] - RE: ERASE filespec

2017-02-02 Thread Dan Goldberg
I just use delete filespc Not sure about erase Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, February 2, 2017 11:36 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - ERASE filespec Hello all, I’m having a bit of

[RBASE-L] - ERASE filespec

2017-02-02 Thread Claudine Robbins
Hello all, I'm having a bit of a headache with an ERASE filespec command which has worked reliably for weeks, works reliably from the R:> prompt and yields "Failed deleting... (2262)" then "Cannot create destination file (2086)" from within a form when I: ERASE .filename2 And COPY .filename1 .f

Re[2]: [RBASE-L] - View: Union / Group By - Success!

2017-02-02 Thread Bruce Chitiea
THAT was one heroic piece of work! Good news. Bruce Chitiea SafeSectors, Inc. 909.238.9012 Mobile -- Original Message -- Sent: 2/2/2017 8:11:19 AM Subject: Re: [RBASE-L] - View: Union / Group By - Success! From: "Alastair Burr" To: "rbase-l@googlegroups.com" Cc: At last: success: I n

Re: [RBASE-L] - View: Union / Group By - Success!

2017-02-02 Thread Alastair Burr
At last: success: I now have all 5 of my databases with the same users and the same owner and no passwords. The way I have been able to get there was by UNLOADing each one and changing the database owner name in the output file and giving it a different password there. I added in a SET USER [o