RE: [RBASE-L] - ERASE filespec

[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 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, 2017 6:15 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

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 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 
&.vQuotes + .vfilename2 + .vQuotes)

&vDeleteFileCommand
PAUSE FOR 2
&vCopyFileCommand


Jan

-Original Message-
From: Claudine Robbins mailto:crobb...@iexgroup.com>>
To: "rbase-l@googlegroups.com" 
mailto:rbase-l@googlegroups.com>>
Date: Thu, 2 Feb 2017 19:35:45 +
Subject: [RBASE-L] - ERASE filespec

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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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, 2017 6:15 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

 

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 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 
&.vQuotes + .vfilename2 + .vQuotes)

 

&vDeleteFileCommand

PAUSE FOR 2

&vCopyFileCommand

 

 

Jan

  

-Original Message-
From: Claudine Robbins mailto:crobb...@iexgroup.com> >
To: "rbase-l@googlegroups.com  " 
mailto:rbase-l@googlegroups.com> >
Date: Thu, 2 Feb 2017 19:35:45 +
Subject: [RBASE-L] - ERASE filespec
  

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 .filename2

 

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

 

TIA,

 

Claudine

 

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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 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 
&.vQuotes + .vfilename2 + .vQuotes)

&vDeleteFileCommand
PAUSE FOR 2
&vCopyFileCommand


Jan

-Original Message-
From: Claudine Robbins mailto:crobb...@iexgroup.com>>
To: "rbase-l@googlegroups.com" 
mailto:rbase-l@googlegroups.com>>
Date: Thu, 2 Feb 2017 19:35:45 +
Subject: [RBASE-L] - ERASE filespec

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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Thursday, February 02, 2017 2:41 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

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 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-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

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@googlegroups.com
Subject: [RBASE-L] - ERASE filespec

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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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 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-l@googlegroups.com  
Subject: RE: [RBASE-L] - ERASE filespec

 

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@googlegroups.com  
Subject: [RBASE-L] - ERASE filespec

 

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 .filename2

 

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

 

TIA,

 

Claudine

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - ERASE filespec

[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 
&.vQuotes + .vfilename2 + .vQuotes)

&vDeleteFileCommand
PAUSE FOR 2
&vCopyFileCommand


Jan
-Original Message-
From: Claudine Robbins 
To: "rbase-l@googlegroups.com" 
Date: Thu, 2 Feb 2017 19:35:45 +
Subject: [RBASE-L] - ERASE filespec


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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine
 --
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an 
email to rbase-l+unsubscr...@googlegroups.com 
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout 
[https://groups.google.com/d/optout].

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

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@googlegroups.com
Subject: [RBASE-L] - ERASE filespec

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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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@googlegroups.com
Subject: [RBASE-L] - ERASE filespec

 

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 .filename2

 

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

 

TIA,

 

Claudine

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - ERASE filespec

[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 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 .filename2

 

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

 

TIA,

 

Claudine

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RE: ERASE filespec

[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 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 .filename2

Permissions are ok…  Undoubtedly my fault but I can’t find it, help!

TIA,

Claudine
--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - ERASE filespec

[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 .filename2

Permissions are ok...  Undoubtedly my fault but I can't find it, help!

TIA,

Claudine

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 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 [ownername] [password] so that the new owner 
created the database then LOADed everything.


Once all 5 had different owner names and different passwords I UNLOADed 
again and changed the database name but returned to my preferred owner 
name with no password. As before, I added in a SET USER 
[preferredownername] but with no password then LOADed everything.


When all 5 were completed I checked then saved the original database 
files elsewhere and renamed my new databases to their original names.


I don't pretend to understand what when wrong or why this process was 
what worked. All I do know it all the other things I tried that were 
suggested wouldn't work.


At least I know that there is only a single error anywhere in my 
databases having re-created them so many times and now I can go back to 
finding the data type mismatch in my view!

Thanks again to everyone that offered help.
Regards,
Alastair.

--
You received this message because you are subscribed to the Google 
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to rbase-l+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[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 [ownername] [password] so that the new owner created the 
database then LOADed everything.

Once all 5 had different owner names and different passwords I UNLOADed again 
and changed the database name but returned to my preferred owner name with no 
password. As before, I added in a SET USER [preferredownername] but with no 
password then LOADed everything.

When all 5 were completed I checked then saved the original database files 
elsewhere and renamed my new databases to their original names.

I don't pretend to understand what when wrong or why this process was what 
worked. All I do know it all the other things I tried that were suggested 
wouldn't work.

At least I know that there is only a single error anywhere in my databases 
having re-created them so many times and now I can go back to finding the data 
type mismatch in my view!
Thanks again to everyone that offered help.
Regards,
Alastair.

-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.