RE: [RBASE-L] - ERASE filespec

[Javier Valencia]

Hello Claudine,
 
The two options are there for a reason. One option allows you to quickly view 
the document using the R:Base PDF browser and once you exit, the file is 
closed. The other option allows you to see the document using Acrobat Reader 
and it has a lot more option and allows you to keep the file open; however, 
when a file is  open it cannot be deleted. I believe there is now a command 
that allows you to check if the file is open and if it is indeed open, you can 
display a message asking the user to close the file before it can be deleted.
Hopefully this explains the use of the two buttons…as you know we can always do 
things in more than one way and it is nice for the user to have options.
 
Javier,
 
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
 
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, February 03, 2017 5:29 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec
 
Buddy, et al… and Javier,
 
I think I have figured it out.  The files in question are pdfs.  I’m using a 
form Javier created and it has two “viewing” button options for the pdf file 
being viewed and replaced, one to view in Adobe Reader and one to view in PDF 
viewer.  I wondered about that Javier but never asked…
 
This afternoon, after finding out online that pdfs cannot be overwritten after 
being opened because the system sees them as being “in use” (indeed, sometimes 
there are multiple tabs in the Adobe reader, so they do stay active), I tested 
using the PDF viewer button in my form.  
 
And guess what, that works reliably, every time…
 
So thank you to everyone who tried to help me figure this out.  And, most of 
all, thank you Javier!
 
Claudine J
 
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, February 03, 2017 3:41 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec
 
Nothing works so I’m just going to wait until next Wednesday and see if a new 
Windows Update isn’t released to fix whatever the problem is.  I’m experiencing 
the same behavior on the cloud server too…
 
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Friday, February 03, 2017 6:33 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - ERASE filespec
 
I think, "technically" you DELete records from a database and ERASE files from 
the directory/folder.

I usually make sure that I have the DOS command correct and then in R:Base 
create a variable & activate that:

SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
&vEraseFile 

and

SET VAR vEraseFile TEXT = 'ERASE "C:\Temp\Folder with spaces\*.*" '


Regards,
Alastair.
On 02/02/2017 20:24, Claudine Robbins wrote:
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 J
 
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.

RE: [RBASE-L] - ERASE filespec

[Claudine Robbins]

Buddy, et al… and Javier,

I think I have figured it out.  The files in question are pdfs.  I’m using a 
form Javier created and it has two “viewing” button options for the pdf file 
being viewed and replaced, one to view in Adobe Reader and one to view in PDF 
viewer.  I wondered about that Javier but never asked…

This afternoon, after finding out online that pdfs cannot be overwritten after 
being opened because the system sees them as being “in use” (indeed, sometimes 
there are multiple tabs in the Adobe reader, so they do stay active), I tested 
using the PDF viewer button in my form.

And guess what, that works reliably, every time…

So thank you to everyone who tried to help me figure this out.  And, most of 
all, thank you Javier!

Claudine ☺

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, February 03, 2017 3:41 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

Nothing works so I’m just going to wait until next Wednesday and see if a new 
Windows Update isn’t released to fix whatever the problem is.  I’m experiencing 
the same behavior on the cloud server too…

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Friday, February 03, 2017 6:33 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - ERASE filespec

I think, "technically" you DELete records from a database and ERASE files from 
the directory/folder.

I usually make sure that I have the DOS command correct and then in R:Base 
create a variable & activate that:

SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
&vEraseFile

and

SET VAR vEraseFile TEXT = 'ERASE "C:\Temp\Folder with spaces\*.*" '


Regards,
Alastair.
On 02/02/2017 20:24, Claudine Robbins wrote:
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.

-- 
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] - DB TreeView - trying to highlight nodes

[Stuart Hellman]

I’ve been racking my brain over this one for a while. Would appreciate any and 
all help.

Using a DB TreeView control, I am trying to highlight/position a specific node 
within the tree. I know my logic is good that gets me the node ID that I want. 
However when I refresh the table/control, the incorrect text is highlighted.

Here’s what is happening:
Level 1   <-- click here
Level 2
Level 3
Level 2
Level 3 <-- highlight here (know the node ID)

I select “Level 1” in the control. I determine the node ID of Level 3 and want 
that node to be highlighted. I’ve used the FINDNODE property, but due redundant 
text, the first occurrence of the text is highlighted. The other idea attempted 
is to use the FINDPATHNODE property. The path name passed to the property is 
correct, but the last item that I selected (in this case “Level 1”)  is 
highlighted not the “level 3” node.

Probably missing something, just don’t know what.

Thanks in advance for your advice.



[cid:image94d946.JPG@a2c51fa3.48894fad]

Stuart Hellman
Software Designer
Email:shell...@qmiusa.com
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1029

www.qmiusa.com




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

 

  As a last resort you could add the following to your code  I’m assuming you 
are running this from R:Base X

 

Buddy

 

 

*Add to your code**

  OUTPUT doerasfile.bat

  WRITE 'DEL' .vfilename2

  WRITE 'COPY' .vfilename1 .vfilename2

  OUTPUT TERM

 

  LAUNCH doerasfile.bat

 

End Code***

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, February 3, 2017 4:41 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - ERASE filespec

 

Nothing works so I’m just going to wait until next Wednesday and see if a new 
Windows Update isn’t released to fix whatever the problem is.  I’m experiencing 
the same behavior on the cloud server too…

 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Friday, February 03, 2017 6:33 AM
To: rbase-l@googlegroups.com  
Subject: Re: [RBASE-L] - ERASE filespec

 

I think, "technically" you DELete records from a database and ERASE files from 
the directory/folder.

I usually make sure that I have the DOS command correct and then in R:Base 
create a variable & activate that:

SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
&vEraseFile 

and

SET VAR vEraseFile TEXT = 'ERASE "C:\Temp\Folder with spaces\*.*" '


Regards,
Alastair.

On 02/02/2017 20:24, Claudine Robbins wrote:

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.

-- 
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]

Nothing works so I’m just going to wait until next Wednesday and see if a new 
Windows Update isn’t released to fix whatever the problem is.  I’m experiencing 
the same behavior on the cloud server too…

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Friday, February 03, 2017 6:33 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - ERASE filespec

I think, "technically" you DELete records from a database and ERASE files from 
the directory/folder.

I usually make sure that I have the DOS command correct and then in R:Base 
create a variable & activate that:

SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
&vEraseFile

and

SET VAR vEraseFile TEXT = 'ERASE "C:\Temp\Folder with spaces\*.*" '


Regards,
Alastair.
On 02/02/2017 20:24, Claudine Robbins wrote:
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] - Another question relating to LOAD/UNLOAD

[Stephen Markson]

I can’t replicate your issue. I can tell you that “£” is the UTF8 encoding for 
“£”, ie CHAR(163). So there must be some setting’s causing this.

Try this:

OUPUT temp.txt ANSI
UNLOAD STRUCTURE FOR whatever
OUTPUT SCREEN

Then look at temp.txt.


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: February-03-17 1:31 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

Thanks,

I'm using UNLOAD STRUCTURE just to the screen

I tried UNLOAD STRUCTURE ANSI but, not surprisingly, no luck.

Regards,
Alastair




On 03/02/2017 14:48, Stephen Markson wrote:
Are you unloading to a file like this?

OUTPUT filename
UNLOAD…
OUTPUT SCREEN

If so, try this:

OUTPUT filename ANSI

This is new syntax to accommodate both ANSI and UTF-8 encoding schemes.


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

Thanks - that's actually the way I'm seeing it.

In RBENGINEX.CFG it shows as: CURRENCY£ PREFIX2 B

and only £ appears in the Configuration Settings applet.

Regards,
Alastair.


On 03/02/2017 12:59, Mohammed wrote:
Try unload structure only separately without data and see

Mohammed Sattar
Sent from my iPhone

On Feb 3, 2017, at 6:06 PM, Alastair Burr 
mailto:adbb...@outlook.com>> wrote:
Hopefully an easier one:

I noticed and "corrected" the following line in the output files from all my 
unloads yesterday:

SET CURRENCY '£' PREF 2 B

which I changed to:

SET CURRENCY '£' PREF 2 B

but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple explantation?

Thanks for any clarity offered,
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.

--
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] - Another question relating to LOAD/UNLOAD

[Alastair Burr]

Thanks,

I'm using UNLOAD STRUCTURE just to the screen

I tried UNLOAD STRUCTURE ANSI but, not surprisingly, no luck.

Regards,
Alastair





On 03/02/2017 14:48, Stephen Markson wrote:
Are you unloading to a file like this?

OUTPUT filename
UNLOAD…
OUTPUT SCREEN

If so, try this:

OUTPUT filename ANSI

This is new syntax to accommodate both ANSI and UTF-8 encoding schemes.


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

Thanks - that's actually the way I'm seeing it.

In RBENGINEX.CFG it shows as: CURRENCY£ PREFIX2 B

and only £ appears in the Configuration Settings applet.

Regards,
Alastair.

On 03/02/2017 12:59, Mohammed wrote:
Try unload structure only separately without data and see

Mohammed Sattar
Sent from my iPhone

On Feb 3, 2017, at 6:06 PM, Alastair Burr 
mailto:adbb...@outlook.com>> wrote:
Hopefully an easier one:

I noticed and "corrected" the following line in the output files from all my 
unloads yesterday:

SET CURRENCY '£' PREF 2 B

which I changed to:

SET CURRENCY '£' PREF 2 B

but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple explantation?

Thanks for any clarity offered,
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.

--
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] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

I had what I hoped might be a brainwave to solve the data type mismatch on this 
view by forcing my non-column data to the type it needed to be.
I amended the view definition to:

CREATE VIEW `LiveAlbumsViewTEST` +
(DiscIdNum,  TrackNumber, Concert_Date,  Venue,   
IWasThere, VenueName,  +
VenueMainName,   VenueFirstName,  ItemTitle, PlayingTime, 
MatrixNumber,  ReleaseSequence,+
DiscPurchase,OrigPurchase,DiscRelease,   OrigRelease, 
ReleaseType_ID,Artist, +
Producer,DiscLabel,   ArtistName,ArtistMainName,  
ArtistFirstName,   DiscType,   +
FullDiscType,TrackTitle,  TrackTime, TrackArtistName)   
 +
AS SELECT +
T1.DiscIdNum,T1.TrackNumber,  T1.Concert_Date,   T1.Venue,
T1.IWasThere,  T2.Full_Name,   +
T2.Main_Name,T2.First_Name,   T3.AllTitles,  T3.PlayingTime,  
T3.MatrixNumber,   T3.ReleaseSequence, +
T3.DiscPurchase, T3.OrigPurchase, T3.DiscRelease,T3.OrigRelease,  
T3.ReleaseType_ID, T3.Artist,  +
T3.Producer, T3.DiscLabel,T3.FullName,   T3.MainName, 
T3.FirstName,  T3.DiscType,+
T3.FullDiscType, T4.All_Titles,   T4.Playing_Time,   T5.Full_Name   
 +
FROM LiveAlbums T1, All_Names T2, Track_Zero_View T3, Tracks T4, All_Names T5   
  +
WHERE T1.Venue = T2.IdNum AND T1.DiscIdNum = T3.DiscIdNum AND T1.DiscIdNum = 
T4.DiscIdNum +
 AND  T1.TrackNumber = T4.TrackNumber AND T4.Artist = T5.IdNum  
  +
UNION SELECT +
(INT('0')),  (INT('0')),   T21.Concert_Date, T21.Venue,  
(ULC('Y')),   T22.Full_Name, +
 T22.Main_Name,   T22.First_Name, (ULC('N/A')), (RTIME(0,0,0)),  
(ULC('N/A')),(INT('0')), +
(RDATE(01,01,1900)), (RDATE(01,01,1900)), (INT('19')),  (INT('19')), 
(INT('0')),   T21.Artist,+
(INT('1')),  (INT('1')),   T23.Full_Name,T23.Main_Name,   
T23.First_Name, (ULC('N/A')),   +
(ULC('N/A')),(ULC('N/A')),(RTIME(0,0,0)),T23.Full_Name  
  +
FROM Concerts T21, All_Names T22, All_Names T23+
WHERE T21.Venue = T22.IdNum AND T21.Artist = T23.IdNum +
GROUP BY T21.Concert_Date, T21.Venue, T22.Full_Name, T22.Main_Name, 
T22.First_Name, +
 T21.Artist,   T23.Full_Name, T23.Main_Name, T23.First_Name

When I create the view with COLCHECK set OFF it is created so there are no 
syntax errors.
I checked the displayed data type in the browser and it is a perfect match for 
the types I expect.
In any case, the columns repeated in the union have to match and the alias name 
is the only variation.
The column names tend to indicate their type as well.

But:

If I take out the column names (all the text in brackets) the view is still 
created but on checking in the browser the first column shows as a DATE
DiscIdNum is without any doubt an INTEGER - it is the primary linking column of 
the database. Nevertheless, having got my unload file from my problem with the 
owner password it was fairly easy for me to check through the views for 
DiscIdNum. In almost every case when an alias is used it is the alias for the 
first column and the column selection is T1.DiscIdNum. In every other case 
there is a correct match.
In other words everything looks right.

Not surprisingly, then, if I create with COLCHECK set ON I get the data 
mismatch in union error.
I have even tried (INT(T1.DiscIdNum)) at the start of the select but it didn't 
help.

Before I just accept having to run with COLCHECK set off has anybody and other 
ideas?

Thanks & regards,
Alastair.




On 28/01/2017 17:35, Javier Valencia wrote:
Alastair,
I believe Stephen is on the right track. One way to check is to start adding 
(or subtracting) columns one at the time, when you add (or subtract) the column 
that is creating the problem the error will show (or disappear if subtracting 
columns) and that should give you the name of the column creating the issue and 
you can investigate further if it has a different definition on an existing 
table or perhaps on another active view.

Javier,

Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson
Sent: Friday, January 27, 2017 1:13 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Alistair, if the COLCHECK setting is solving the problem, that may indicate 
that one of view column aliases is the same as a column name in some other 
table with a different datatype.


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegrou

RE: [RBASE-L] - Another question relating to LOAD/UNLOAD

[Stephen Markson]

Are you unloading to a file like this?

OUTPUT filename
UNLOAD…
OUTPUT SCREEN

If so, try this:

OUTPUT filename ANSI

This is new syntax to accommodate both ANSI and UTF-8 encoding schemes.


Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Another question relating to LOAD/UNLOAD

Thanks - that's actually the way I'm seeing it.

In RBENGINEX.CFG it shows as: CURRENCY£ PREFIX2 B

and only £ appears in the Configuration Settings applet.

Regards,
Alastair.

On 03/02/2017 12:59, Mohammed wrote:
Try unload structure only separately without data and see

Mohammed Sattar
Sent from my iPhone

On Feb 3, 2017, at 6:06 PM, Alastair Burr 
mailto:adbb...@outlook.com>> wrote:
Hopefully an easier one:

I noticed and "corrected" the following line in the output files from all my 
unloads yesterday:

SET CURRENCY '£' PREF 2 B

which I changed to:

SET CURRENCY '£' PREF 2 B

but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple explantation?

Thanks for any clarity offered,
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.

--
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] - Another question relating to LOAD/UNLOAD

[Alastair Burr]

Thanks - that's actually the way I'm seeing it.

In RBENGINEX.CFG it shows as: CURRENCY£ PREFIX2 B

and only £ appears in the Configuration Settings applet.

Regards,
Alastair.


On 03/02/2017 12:59, Mohammed wrote:
Try unload structure only separately without data and see


Mohammed Sattar
Sent from my iPhone

On Feb 3, 2017, at 6:06 PM, Alastair Burr 
mailto:adbb...@outlook.com>> wrote:

Hopefully an easier one:

I noticed and "corrected" the following line in the output files from all my 
unloads yesterday:

SET CURRENCY '£' PREF 2 B

which I changed to:

SET CURRENCY '£' PREF 2 B

but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple explantation?

Thanks for any clarity offered,
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.

-- 
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] - Another question relating to LOAD/UNLOAD

[Mohammed]

Try unload structure only separately without data and see 


Mohammed Sattar
Sent from my iPhone

> On Feb 3, 2017, at 6:06 PM, Alastair Burr  wrote:
> 
> Hopefully an easier one:
> 
> I noticed and "corrected" the following line in the output files from all my 
> unloads yesterday:
> 
> SET CURRENCY '£' PREF 2 B 
> 
> which I changed to:
> 
> SET CURRENCY '£' PREF 2 B 
> 
> but I also noticed that it got changed back in subsequent unloads.
> Presumably there's an simple explantation?
> 
> Thanks for any clarity offered,
> 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] - ERASE filespec

[Alastair Burr]

I think, "technically" you DELete records from a database and ERASE files from 
the directory/folder.

I usually make sure that I have the DOS command correct and then in R:Base 
create a variable & activate that:

SET VAR vEraseFile TEXT = 'ERASE C:\Temp\*.*'
&vEraseFile

and

SET VAR vEraseFile TEXT = 'ERASE "C:\Temp\Folder with spaces\*.*" '


Regards,
Alastair.

On 02/02/2017 20:24, Claudine Robbins wrote:
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.

[RBASE-L] - Another question relating to LOAD/UNLOAD

[Alastair Burr]

Hopefully an easier one:

I noticed and "corrected" the following line in the output files from all my 
unloads yesterday:

SET CURRENCY '£' PREF 2 B

which I changed to:

SET CURRENCY '£' PREF 2 B

but I also noticed that it got changed back in subsequent unloads.
Presumably there's an simple explantation?

Thanks for any clarity offered,
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.