Re: [RBASE-L] - RE: RMail 11 - Error

[Alastair Burr]

If the comma is important could the CHAR funtion be used for it and 
concatenated into the text variable.


Maybe even concatenated in quotes:

(“John Doe" + (CHAR(44)) & "M.D.”)

(“John Doe" + "," & "M.D.”)

Regards,

Alastair.

ps: IF 44 is not a comma it's my eyes!

On 16/08/2024 16:02, 'Karen Tellef' via RBASE-L wrote:
Hmmm, interesting!  I never thought of email names with commas in it!  
I'll have to remember to check that!



Karen



On Friday, August 16, 2024 at 09:58:11 AM CDT, Steve Thorson 
 wrote:



Apparently, the issue for me was in the Recipient. My variable, 
vFullName, had a comma in it (“John Doe, M.D.”) which throws the 
ADD_RECIPIENT command off. After removing the comma, the eep worked 
flawlessly…


Steve

*From:*rbase-l@googlegroups.com  *On Behalf 
Of *Steve Thorson

*Sent:* Thursday, August 15, 2024 11:50 PM
*To:* rbase-l@googlegroups.com
*Subject:* [RBASE-L] - RMail 11 - Error

The RMail plug in is giving me an error within an eep I’ve written and 
I’m not sure what is causing it.  The error is: “-ERROR- Cannot send 
e-mail message. (Invalid address)”


I’m using a template “RFANotice.RMT” which I’ve placed into other 
scripts and it produces a nicely formatted email.  Variables flowing 
into the plugin appear to be in order. I’ve even hard coded the email 
recipient for testing:


SET VAR vRecipient TEXT = ("v1|ADD_RECIPIENT" & .vFullName & 
"sthor...@afsafund.org")


PLUGIN RMail v1|CLEAR LOG

PLUGIN RMail v1|CLEAR_ALL

PLUGIN RMail v1|SHOW PROGRESS

PLUGIN RMail v1|MESSAGE_TYPE HTML

PLUGIN RMail v1|ACCOUNT_NAME AFSA_MSEmail

PLUGIN RMail .vRecipient

PLUGIN RMail v1|ADD_REPLY_TO kthor...@afsafund.org

PLUGIN RMail v1|ORGANIZATION "American Fibromyalgia Syndrome Association"

PLUGIN RMail v1|PRIORITY NORMAL

PLUGIN RMail v1|TEMPLATE_NAME RFANotice.RMT

PLUGIN RMail v1|SEND

I’m not sure how do debug this.  Does anyone have some ideas?

Thank you!

Steve Thorson

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/IA1P221MB086417EA60F9207D2A3BAF52A2812%40IA1P221MB0864.NAMP221.PROD.OUTLOOK.COM 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/IA1P221MB0864BB2F2C6129EED62FDF63A2812%40IA1P221MB0864.NAMP221.PROD.OUTLOOK.COM 
.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2106512490.7048431.1723820536796%40mail.yahoo.com 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/AM7PR10MB3189FD1A6AC7AADB57476E74AC812%40AM7PR10MB3189.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - Copy of files suddenly stops working

[Alastair Burr]

Yes, but a very long time ago now I had backup copying problems and 
ended up with errors that eventually were solved by everything being 
right not necessarily just what appeared to be wrong. I remember 
expanding all the variables so that the command was simply copy: 
"sourcefiles" "destination" - so without the &var and with quotes to 
allow spaces


Stupid question I'm sure but there really are files to copy at the time?

Has windows been upgraded? If so defaults might not be the same.

Good luck, Alastair.


On 26/06/2023 15:59, 'jim schmitt' via RBASE-L wrote:

Thanks, Alastair:

Yes, there are three spaces in the VF_TO variable, but isn't the 
'cannot open source file' referring to the 'C:\UBILL\*.*' of the copy 
command ?


Still searching.     Jim


On Monday, June 26, 2023 at 10:50:22 AM EDT, Alastair Burr 
 wrote:



Looks to me that you have a space, just before AM - possibly due to 
date/time format change. Filenames with spaces need to be in double 
quotes  for system copy.


Rwgards. Alastair.

On 26/06/2023 15:01, 'jim schmitt' via RBASE-L wrote:

Good Moring, group:

I have a Utility Billing program running at several villages, and the 
backup routine which does a backup to an external drive has failed 
lately at 3 clients with the same error message of 'cannot open 
source file (2085).  I wrote the routine years ago, and it is quite 
simple.  I create a variable of 'location/name/time/date' for where 
we are sending the data to (VF_TO}'.   This is because the operator 
may do multiple backup on any given day.


The command is:  COPY C:\UBILL\*.* &VF_TO

Sample trace attached. Am i doing the simplest way for a backup or 
others have a better way. ??

Any 'blues' clues.

Thanks for any assistance.

Jim
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 
<http://www.rbase.com/support/usersgroup_guidelines.php>

---
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>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2029899591.5130715.1687788099654%40mail.yahoo.com 
<https://groups.google.com/d/msgid/rbase-l/2029899591.5130715.1687788099654%40mail.yahoo.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DUZPR10MB80996122BF106084F681C3D0AC26A%40DUZPR10MB8099.EURPRD10.PROD.OUTLOOK.COM 
<https://groups.google.com/d/msgid/rbase-l/DUZPR10MB80996122BF106084F681C3D0AC26A%40DUZPR10MB8099.EURPRD10.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/338283074.5153202.1687791564491%40mail.yahoo.com 
<https://groups.google.com/d/msgid/rbase-l/338283074.5153202.1687791564491%40mail.yahoo.com?utm_medium=email&utm_source=footer>.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DUZPR10MB80994FC06D8B9FB77E6D6956AC26A%40DUZPR10MB8099.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - Copy of files suddenly stops working

[Alastair Burr]

Looks to me that you have a space, just before AM - possibly due to 
date/time format change. Filenames with spaces need to be in double 
quotes  for system copy.


Rwgards. Alastair.

On 26/06/2023 15:01, 'jim schmitt' via RBASE-L wrote:

Good Moring, group:

I have a Utility Billing program running at several villages, and the 
backup routine which does a backup to an external drive has failed 
lately at 3 clients with the same error message of 'cannot open source 
file (2085).  I wrote the routine years ago, and it is quite simple.  
I create a variable of 'location/name/time/date' for where we are 
sending the data to (VF_TO}'.   This is because the operator may do 
multiple backup on any given day.


The command is:  COPY C:\UBILL\*.* &VF_TO

Sample trace attached.  Am i doing the simplest way for a backup or 
others have a better way. ??

Any 'blues' clues.

Thanks for any assistance.

Jim
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2029899591.5130715.1687788099654%40mail.yahoo.com 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DUZPR10MB80996122BF106084F681C3D0AC26A%40DUZPR10MB8099.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - add week

[Alastair Burr]

Dan, try ADDDAY:

set var vIntweeks = 8 (or whatever)

(ADDDAY(.vdate, (.vIntweeks * 7) ))

Use -7 to go back in time

Regards, Alastair.

On 10/03/2022 15꞉19, Dan Goldberg wrote:

I have a need to add 8 weeks to a date variable. I looked and noticed 
there is not an addwk function like addday and addmon


Has anyone added a number of weeks to a date variable?

TIA

Dan Goldberg

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EF8EF9B%40EXCHANGE10 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DB9PR10MB4585EA852883B93120D1FD02AC0B9%40DB9PR10MB4585.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group

[Alastair Burr]

Facebook has been uninstalled and deleted from my devices and will not 
be reinstalled.


I use  No Script to keep its insidious scripts at bay.

Enough said,

Alastair.


On 14/12/2021 19꞉51, A. Razzak Memon wrote:

Tuesday, December 14, 2021

Dear R:BASE Community,

We all know first-hand the fulfillment and joy of helping one another 
and sharing with R:BASE users online.


With the past Email List Servers, and now current Google Group, the 
R:BASE community members have been paying it forward for decades.


As such, we are proud to introduce an additional way to seek help and 
share R:BASE knowledge with the community, the R:BASE Community 
Facebook Group!


As with Facebook posts, your shared group content may receive 
feedback/reaction from members in form of likes, wows, etc., with 
comments and shares.


Use the below URL to join the R:BASE Community Facebook Group, and 
let's start a whole new way of sharing our R:BASE knowledge!

https://www.facebook.com/groups/958182905107520

While you all join the group and get ready, we are planning to go live 
on January 3rd, 2022.


Please Note: This Google List Server will no longer be active 
effective January 3, 2022.


Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DB9PR10MB4585EFDB092F313C767056E6AC769%40DB9PR10MB4585.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - drag and drop pictures from outlook

[Alastair Burr]

Would connecting to Outlook on- line in a Web Browser control on a form 
allow drag and drop?


Regards,

Alastair.

On 24/06/2021 14꞉58, Dan Goldberg wrote:


Thx never done it from another program before. Sure there is a way as 
other programs allow this.


Dan Goldberg

*From:* rbase-l@googlegroups.com  *On Behalf 
Of *jan johansen

*Sent:* Thursday, June 24, 2021 3:58 AM
*To:* rbase-l@googlegroups.com
*Subject:* Re: [RBASE-L] - drag and drop pictures from outlook

Dan,

I'm not sure how you accomplish this.

You have rightly noted that you have the "on drop" eep that you can 
work with.


But the initiate "on drag" doesn't really work because you attempting 
to grab something outside of R:Base.


Perhaps Mike Byerly or Razzak knows a trick on this one.

Jan

From: Dan Goldberg mailto:d...@lancecamper.com>>
To: "rbase-l@googlegroups.com "
mailto:rbase-l@googlegroups.com>>
Date: Wed, 23 Jun 2021 20:14:22 +
Subject: [RBASE-L] - drag and drop pictures from outlook

So we have a customer support ticket system in Rbase.

Currently I have it setup where they link files to the ticket.

1. save the attached files from outlook to desktop

2. In Rbase When they click on “link the files” they select the
file(s) with the plugin and it copies it into an attachment folder
with a unique name.

They would like to be able to just drag the files from outlook  to
the rbase ticket and it will automatically do the same. I can do a
“on drop” on a form button but I do not know how to have it grab
the file info to copy/rename the dropped file.

Anyone done this?

Dan Goldberg

--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php

---
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
.
To view this discussion on the web visit

https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E9245BB%40EXCHANGE10

.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/WC20210624105809.660006%40jjcalibrations.com 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E926002%40EXCHANGE10 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DB9PR10MB458520AFD0BA16F18AA87233AC079%40DB9PR10MB4585.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - convert text to time data type

[Alastair Burr]

Try the function: (CTXT(arg))

Regards, Alastair

On 29/01/2021 05꞉41, 'R Hopkins' via RBASE-L wrote:


Dan,
  Here is another technique for a converting variable of type time to 
a vaiable of type text, and it is very simple.


SET VAR  vtime TIME = 10:11:22
SET VAR vtxt TEXT = &vtime       --This works
SET VAR vtxt TEXT = (&vtime)     --This does not works

But to work, you can't put parenthesis around the expression

R Hopkins

-Original Message-
From: Dan Goldberg 
To: rbase-l@googlegroups.com 
Sent: Wed, Jan 13, 2021 7:26 am
Subject: RE: [RBASE-L] - convert text to time data type

Thx guys. I think this gives me an idea!
Dan Goldberg
*From:* rbase-l@googlegroups.com  *On Behalf 
Of *Buddy Walker

*Sent:* Wednesday, January 13, 2021 7:13 AM
*To:* rbase-l@googlegroups.com
*Subject:* RE: [RBASE-L] - convert text to time data type
Dan
  You could create another column newTimeCol and set it to time
  UPDATE table SET newTimeCol = oldTextCol
   This should work as long as each row has AM or PM in it
   You could also just change the column from text to time. This may 
caused problems with reports/forms etc.

Buddy
*From:* rbase-l@googlegroups.com  
mailto:rbase-l@googlegroups.com>> *On 
Behalf Of *Dan Goldberg

*Sent:* Wednesday, January 13, 2021 9:58 AM
*To:* 'rbase-l@googlegroups.com' >

*Subject:* [RBASE-L] - convert text to time data type
I have a text field that a user selects from for each hour.
8:00 AM
9:00 AM
10:00 AM
….
I need to convert that to a time format so I can use it in 
calculations. I do not see a function to do so. Anyone know how I can 
convert it?

TIA
Dan Goldberg
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A21FB%40EXCHANGE10 
.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000d01d6e9be%24865abd40%24931037c0%24%40comcast.net 
.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A22AE%40EXCHANGE10 
.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php 


---
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 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1025492020.104991.1611898886306%40mail.yahoo.com 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/DB6PR1001MB09682B8397520904BCA46028ACB99%40DB6PR1001MB0968.EURPRD10.PROD.OUTLOOK.COM.

Re: [RBASE-L] - Linking to a pdf file or jpeg

[Alastair Burr]

And if that doesn't work try double quotes in the variable:

set var vfilename text = ' "c:\program files\test.pdf " '  -- I've put a space 
to make them show up, the spaces are not needed.

IF that doesn't work, I've found creating a variable for the path and another 
for the name does:

set var vpathname text = ' "c:\program files\" '

set var vfilename text = ' "test.pdf" '

set var vPathFileName = (.vpathname + .vfilename)  -- + NOT & - else you get a 
space!!

(Don't ask why this should make any difference but my experience is that it 
does.)

If you're using the same folder regularly then the 2 variables might help 
anyway...

Regards,
Alastair


On 23/01/2019 15꞉24, 'Karen Tellef' via RBASE-L wrote:
Put the filename into a variable.  As an example, put a PDF file into your 
"c:\program files"  directory.  You can see that directory name has a space in 
it.

Then do this:
set var vfilename text = 'c:\program files\test.pdf'
launch .vfilename


Karen



-Original Message-
From: dkfowler6179 
To: RBASE-L 
Sent: Wed, Jan 23, 2019 9:13 am
Subject: [RBASE-L] - Linking to a pdf file or jpeg

Using latest version.  Trying to understand how to be able to allow a user to 
open a pdf file or photo file from a form.  The hurdle I'm having trouble with 
is generating the path to the resource.  I don't want to have to enter a path 
or file name into each entry.  I need to be able to generate the path and open 
the file based on info already in the table/entry.  When I've tried so far, I 
end up with spacing in the generated path that causes the path to be incorrect.
Any help is appreciated.
David Fowler
Roto-Rooter

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Possible e-mail or list problem?

[Alastair Burr]

A few days ago I replied to Dan Goldberg using the reply button in my e-mail 
software (Mozilla Thunderbird) and then later wondered why I hadn't had the 
message returned to me as usual via the list.

This has happened a few times and I have simply re-posted my post if it was 
still relevant.

This morning, however, I noticed that my post to Dan hadn't returned and I 
looked to see if it was in my "Sent" box - it was - but, by chance, it caught 
my eye that it had been sent to Dan directly and not to the list.

The source contains this:


X-Original-Sender: d...@lancecamper.com
X-Original-Authentication-Results: gmr-mx.google.com;   spf=softfail
 (google.com: domain of transitioning 
d...@lancecamper.com does not designate
 199.102.107.209 as permitted sender) 
smtp.mailfrom=d...@lancecamper.com
Reply-To: rbase-l@googlegroups.com


Has anybody got any idea what might be going on?

Regards,
Alastair.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - How to use "Controlled_column_names" table for column definition enforcement in views.

[Alastair Burr]

Interesting, I, too, had a problem with this a while ago.

I had/have a view that causes me a problem with column type(s) that does not 
seem to be solved with a pre-defined table to "fix" the column type.

However, I have not been able to prove that the problem is with the view. For 
me, it is a relatively complicated view but I wouldn't think it complicated for 
R:Base. It's resolved by simply turning ColCheck on or off as required.

I chose not to waste more time looking for the answer when I had a work-around. 
Nevertheless, I would be grateful if you find a solution if you would post it 
here.

Regards,
Alastair.



On 16/04/2018 18:37, 'rehan wyne' via RBASE-L wrote:
Yes.
I also tried by setting COLCHECK OFF. Such that Project command may work and do 
not raise error i.e. "As Column XYZ is used in another table, its type cannot 
be redefined."

Rehan Wyne

On Monday, April 16, 2018, 6:44:53 PM GMT+5, Alastair Burr 
<mailto:adbb...@outlook.com> wrote:


Do you have COLCHECK set to ON to specify checking?

Regards,
Alastair.

On 16/04/2018 13:08, 'rehan wyne' via RBASE-L wrote:
Hello All,

I have defined all controlled column names and their data types in 
"controlled_column_names table", that will be enforced in creating a view when 
using similar columns names.

After a view is created, I noticed it did not picked up the column data type as 
defined in controlled_column_names.

A view's column definition could be build from sum(XYZ) or union of columns 
from different tables.

I am facing a type mismatch error when I use "Project Temporary" command.

I am using R:Base X Enterprise 10.0.3.


Any Clue ?


Rehan Hamid Wyne

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - How to use "Controlled_column_names" table for column definition enforcement in views.

[Alastair Burr]

Do you have COLCHECK set to ON to specify checking?

Regards,
Alastair.

On 16/04/2018 13:08, 'rehan wyne' via RBASE-L wrote:
Hello All,

I have defined all controlled column names and their data types in 
"controlled_column_names table", that will be enforced in creating a view when 
using similar columns names.

After a view is created, I noticed it did not picked up the column data type as 
defined in controlled_column_names.

A view's column definition could be build from sum(XYZ) or union of columns 
from different tables.

I am facing a type mismatch error when I use "Project Temporary" command.

I am using R:Base X Enterprise 10.0.3.


Any Clue ?


Rehan Hamid Wyne

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.

Fwd: Re: [RBASE-L] - Elapsed time in HH:MM format

[Alastair Burr]

This didn't seem to appear yesterday:


 Forwarded Message 
Subject:Re: [RBASE-L] - Elapsed time in HH:MM format
Date:   Sat, 13 Jan 2018 08:35:52 +
From:   Alastair Burr <mailto:adbb...@outlook.com>
Reply-To:   adbb...@outlook.com<mailto:adbb...@outlook.com>
To: dkfowler6179 <mailto:dkfowler6...@comcast.net>


Look at the ADDSEC funtion and use:

(ADDSEC(0:00:00,int))
or
(ADDSEC(0:00:00, .Var))

As long as your elapsed time is less than 24 hours you should be fine.

Regards,
Alastair.

On 13/01/2018 02:10, dkfowler6179 wrote:

I've been able to get elapsed time between a start and end time as a real 
number.  Need to get this to HH:MM format though.  Columns ckin and ckout are 
datetime format (as time sometimes span from one day to the next).  I'm sure 
this is something pretty simple, but I haven't been able to figure it out.

Thanks for any help.
David Fowler



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Password error

[Alastair Burr]

Again, this went to Mike from my reply button - apologies.

 Forwarded Message 
Subject:Re: [RBASE-L] - Password error
Date:   Fri, 16 Jun 2017 16:48:29 +0100
From:   Alastair Burr <mailto:adbb...@outlook.com>
Reply-To:   adbb...@outlook.com<mailto:adbb...@outlook.com>
To: mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com>


If it adds any clarity below are the examples from my five databases with the 
lines immediately preceeding and following copied & pasted directly from the 
output files:

SET FASTLOCK OFF
CREATE SCHEMA AUTHOR Books HATTON
CREATE TABLE `Various_Menus` +

SET FASTLOCK OFF
CREATE SCHEMA AUTHOR General HATTON
CREATE TABLE `Dummy` +

SET FASTLOCK OFF
CREATE SCHEMA AUTHOR MultiDat HATTON
CREATE TABLE `ApplicationSetting` +

SET FASTLOCK OFF
CREATE SCHEMA AUTHOR Records HATTON
SET USER HATTON none
CREATE TABLE `All_Names` +

SET FASTLOCK OFF
CREATE SCHEMA AUTHOR Visuals HATTON
CREATE TABLE `Various_Menus` +

Using R:BASE X, U.S. Version, Build: 10.0.2.20307

As you can see the fourth database adds an extra line.

The output files are created in a loop so nothing is different between them.
I can edit out the rogue line and then rebuild the database but. so far, this 
extra line will reappear sooner or later.
Before I stopped spending any more time on it I did not think it was caused by 
the backup process.
If I had any suspicions at all it was that maybe it was to do with mistyping 
the user name at some point but I couldn't find a way to prove it. In the end 
it was easier just to type none when needed.

Regards,
Alastair.


On 16/06/2017 16:13, mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com> 
wrote:
Good morning to all:

Thank you, Razzak, for your response.  Your comments and questions are valid 
and I appreciate the professional manner in which they were expressed.  I truly 
mean that.

I'll take it from here for completing my long overdue upgrade process.

Regarding the original question, I did a "from the ground up" rebuild of the 
database in question.

One of the structure files provided an insight into the password issue.

Here is the output of the structure file for the ID_MASTER table:

SET QUOTES=NULL
SET QUOTES='
SET DELIMIT=NULL
SET DELIMIT=','
SET LINEEND=NULL
SET LINEEND='^'
SET SEMI=NULL
SET SEMI=';'
SET PLUS=NULL
SET PLUS='+'
SET SINGLE=NULL
SET SINGLE='_'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
SET CURRENCY ' ' SUFF 0 B
DISCONNECT
SET STATICDB OFF
SET ROWLOCKS ON
SET FASTLOCK OFF
CREATE SCHEMA AUTHOR MILL2250 PUBLIC
SET USER PUBLIC none
CREATE TABLE `ID_MASTER` +
(`ID` INTEGER, +
 `FILE_NAME` TEXT (26), +
 `STARTED` DATETIME, +
 `COILNUMBER` TEXT (20), +
 `STCD_NO` INTEGER, +
 `STCD_DASH` TEXT (12), +
 `GRADE` TEXT (4), +
 `MELTCODE` TEXT (6), +
 `TIME_STAMP` DATETIME, +
 `NO_FILE` INTEGER, +
 `LAST_PASSNUM` INTEGER, +
 `PASS_FOOTAGE` INTEGER, +
 `COMPLETEDOK` INTEGER, +
 `DIRLEFT` INTEGER, +
 `RTE_GAUGE_MIN` DOUBLE, +
 `RTE_GAUGE_MAX` DOUBLE, +
 `ROLL_START` DATETIME, +
 `ROLL_STOP` DATETIME)
CREATE INDEX IM_ID_IDX ON `ID_MASTER` (`ID` ASC)

Note the "SET USER PUBLIC none" line.  That's the command that apparently 
caused the problem and I have no explanation or knowledge as to when, how or 
why that particular setting was ever set.

Whatever the case, I removed that command from each structure file before doing 
the re-build.  I then unloaded the structure again to make sure that it was 
truly gone.  So far so good.

I anticipate that the problem has been addressed.

Thanks again to everyone that contributed to this discussion.  It has been a 
valuable exchange.

May everyone have a safe and enjoyable weekend.


Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659



From:"A. Razzak Memon" <mailto:raz...@rbase.com>
To:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>,
Date:06/16/2017 07:03 AM
Subject:Re: [RBASE-L] - Password error
Sent by:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>




Good Morning, Mike:

Thanks for the clarification. Yes, I did notice, thus no response
from me until someone suggested to submit a bug. My reaction was to
get this cleared right away. Why fake news?

Having said that, if I remember correctly, and looking at our
records, my entire development team has spent many many hours to
address all your reported items related to R:BASE X Enterprise
(Version 10), including some cool enhancements. They provided you
with private updates, etc. for your testing and verification. Since
there were no further reports or any pending items for a long time, I
am just curious as to what is preventing you from taking advantage of
all those fixes and enhancements in R:BASE X Enterpr

Re: [RBASE-L] - Password error

[Alastair Burr]

I spent days editing the unload file(s); using SET USER and a few times I 
thought I had conquered it but eventually the need for NONE appeared again.

As far as I recollect (always dangerous) neither NONE nor PUBLIC ever used to 
appear in the unload file - only the owner password if one existed for the 
owner name. (Prior to that only the owner name.)

PUBLIC was implied by not having an owner or added via the GRANT system.
NONE just seems to have appeared but when I don't know. It can/should be used 
to remove a password according to help. Maybe R:Base is suddenly taking it 
literally and storing NONE as the password but that wouldn't explain why it 
suddenly decides to need it.

I presume AUTHOR is the SQL way of saying OWNER?

Regards,
Alastair.


On 15/06/2017 14:13, karentellef via RBASE-L wrote:
I've never had a database with an owner PW so I don't know much
about them.  But when I unload schema for my personal consulting
database it says:
 CREATE SCHEMA AUTHOR CONSULT PUBLIC

I'm not sure why mine says 'PUBLIC" rather than "NONE".  I do not
have any privileges granted.  Can you try changing it to Public and
see if that sticks?

And I'm curious myself:  what does the word "AUTHOR" mean?  Is
that always there, or does it mean something?

Karen




-Original Message-
From: Alastair Burr <mailto:adbb...@outlook.com>
To: R:Base Listserver 2016 
<mailto:rbase-l@googlegroups.com>
Sent: Thu, Jun 15, 2017 5:42 am
Subject: Fwd: Re: [RBASE-L] - Password error

For some reason this went direct to Mike rather than the list.


 Forwarded Message 
Subject:Re: [RBASE-L] - Password error
Date:   Wed, 14 Jun 2017 17:02:25 +0100
From:   Alastair Burr <mailto:adbb...@outlook.com>
Reply-To:   adbb...@outlook.com<mailto:adbb...@outlook.com>
To: mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com>


I have the exact same problem - mentioned here a good few months back.

I can give you the solution but I cannot get rid of the problem - it keeps 
coming back.

The solution is that the "null" or non-existent password gets sets to "none" 
for no obvious reason.

If you type in the password as "none" you will get in as normal.

If you unload to a file and edit it you will see it in the Create Schema 
command. I've edited it endlessly but it still comes back. I gave up and cut my 
loses and now just enter "none" - I can't waste more time on it. It's just one 
database; my other four are fine.

For what it's worth, I loop through and autochk, copy (reload) to a new folder 
as well in my back-ups in case that's relevant somehow.

Good luck,
Regards,
Alastair.


On 14/06/2017 15:47, mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com> 
wrote:
Good day:

I have a daily backup routine that loops through about 20 databases.  The 
program connects to a database, AUTOCHKs it and then copies it to a backup 
folder.

There is one database that generates the following error when the program 
attempts to connect to it:  -ERROR- The current password is not correct for 
this user identifier. (2867)

The owner of the database is set to public and there has never been a password 
associated with the database.

Entering a bogus password or clicking through it generates this message:  
-ERROR- Incorrect password.  User identifier has been changed to PUBLIC. (2870)

After which the database gets backed up.

I cannot find anything that would indicate why this is happening to this one 
particular database.  I've checked it, I've rebuilt it and still I get the 
message.

Using eXtreme 9.5, I would appreciate some suggestions or insight into why this 
happens or what I can look for.

Thanks for any help.



Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it 
is addressed and may contain privileged, proprietary, or otherwise private 
information.
If you are not the named addressee, you are not authorized to read, print, 
retain, copy or disseminate this message or any part of it. If you have 
received this message in error, please notify the sender immediately by e-mail 
and delete all copies of the message.
--
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.

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

Fwd: Re: [RBASE-L] - Password error

[Alastair Burr]

For some reason this went direct to Mike rather than the list.


 Forwarded Message 
Subject:Re: [RBASE-L] - Password error
Date:   Wed, 14 Jun 2017 17:02:25 +0100
From:   Alastair Burr <mailto:adbb...@outlook.com>
Reply-To:   adbb...@outlook.com<mailto:adbb...@outlook.com>
To: mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com>


I have the exact same problem - mentioned here a good few months back.

I can give you the solution but I cannot get rid of the problem - it keeps 
coming back.

The solution is that the "null" or non-existent password gets sets to "none" 
for no obvious reason.

If you type in the password as "none" you will get in as normal.

If you unload to a file and edit it you will see it in the Create Schema 
command. I've edited it endlessly but it still comes back. I gave up and cut my 
loses and now just enter "none" - I can't waste more time on it. It's just one 
database; my other four are fine.

For what it's worth, I loop through and autochk, copy (reload) to a new folder 
as well in my back-ups in case that's relevant somehow.

Good luck,
Regards,
Alastair.


On 14/06/2017 15:47, mike.rams...@aksteel.com<mailto:mike.rams...@aksteel.com> 
wrote:
Good day:

I have a daily backup routine that loops through about 20 databases.  The 
program connects to a database, AUTOCHKs it and then copies it to a backup 
folder.

There is one database that generates the following error when the program 
attempts to connect to it:  -ERROR- The current password is not correct for 
this user identifier. (2867)

The owner of the database is set to public and there has never been a password 
associated with the database.

Entering a bogus password or clicking through it generates this message:  
-ERROR- Incorrect password.  User identifier has been changed to PUBLIC. (2870)

After which the database gets backed up.

I cannot find anything that would indicate why this is happening to this one 
particular database.  I've checked it, I've rebuilt it and still I get the 
message.

Using eXtreme 9.5, I would appreciate some suggestions or insight into why this 
happens or what I can look for.

Thanks for any help.



Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it 
is addressed and may contain privileged, proprietary, or otherwise private 
information.
If you are not the named addressee, you are not authorized to read, print, 
retain, copy or disseminate this message or any part of it. If you have 
received this message in error, please notify the sender immediately by e-mail 
and delete all copies of the message.
--
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.

-- 
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] - Thoughts on speeding up a cursor?

[Alastair Burr]

Karen,

I may be well wide of the mark if I haven't twigged what you're after properly 
but I think I would start along these lines:

Project a temp table that contains all the matches for policy/company.
Add a flag column defaulted to 1 (only one criteria matched);
Then use your code to reset the flag for those that match, say, all 9 
requirements,
repeat for 8 requirements then 7 etc.

If your data is similar in the other tables you might be able to add a table 
column to your temp table and add the data and flag it for all the tables you 
need to look up. If not then, presumably, you'd need a number of temp tables.

Hopefully, you would then have a single temp table that holds all your look ups 
and only the look ups that you need which you can refer to throughout instead 
of the main permanent table.

Temp views can be pretty quick, too, if you can create the view(s) on the fly. 
(I have a series of temp views created inside a loop that increases the year 
for the where clause that works well.)

Good luck,
Regards,
Alastair.


On 24/04/2017 21:49, karentellef via RBASE-L wrote:
Thanks, Javier, all good thoughts.

Quick question:  If I am dialing into the system using Remote Desktop (no VPN, 
not dialed into the database server itself), am I seeing the same performance 
as a person on a network workstation?  If not, then that screws up my ability 
to test speed advances.


Multi-line commands:  I wasn't sure if the whole code was read into memory or 
not, didn't know if that was only in while loops.  If a multi-line command is 
read internally as one line that would be awesome.  Although it would be a 
quick "fix" if consolidating those lines would speed it up.

We changed from a WHILE loop to a GOTO in Nov 2014, so a little over 2 years 
ago.  The client was on 9.5 at that time. The routine was taking only 45 
minutes to run in 9.5 with the goto/label and was acceptable, but we upgraded 
to Version 10 and changed to 64-bit and with no changes to the program or table 
structure now it takes 3 hrs.  RBTI gave me some suggestions for checking code 
and table structure, I made one change to indexes (removed duplicate indexes, 
even though I'm not updating the table and it's only used for the primary 
cursor), did another unload of the database, but it didn't help.  Who knows, 
maybe the while loop will not only work, but also would be faster than 
goto/label in version 10?  I'm wondering if, on my own time, I should try to 
put the program "back" to a while loop and test it in version 10 to see if it 
completes and if it's any faster... Hmmm.

Temp tables:  yeah I guess I should think of creating temp tables for all of 
the lookups.  I counted -- there's 10 different tables of lookups (so 10 temp 
tables??), but there's many different criterias.  All the criteria is at least 
3 items, some search for up to 8 items to match.  Some criteria is 
non-indexable such as "not null" or ">".  If I search one time by 8 items, once 
by 3 items, once by 5 items, how would I go about setting up indexes for all 
that?  And do I only include columns where I search using "=" in multi-column 
indexes?

For one example, it first looks at a table for the most restrictive match:  can 
I match the policy, the company, the agent, the year the policy started (which 
is a >), the coverage plan, whether the policy offers advances.  If it doesn't 
match that, then it'll drop 1 or 2 of the criteria and do another search, and 
so on.  The only unique is policy / company.   I don't know how I could set up 
indexes to match the many searches just to this one table, and I literally have 
9 other tables with similar lookups.
 My usual routine is to set individual indexes for the most unique columns 
(which are policy# & company code, both text), but not do indexes for those 
columns that have alot of repetitive data.  For example, for "agent", of the 
40K rows, there may be only 20 different agents.  I don't think that would be a 
good index, do you?

If anyone wants a clue as to why health insurance is so confusing, you should 
see this routine!

Thanks to anyone who had the fortitude to read my verbose email


Karen




-Original Message-
From: Javier Valencia 

To: rbase-l 
Sent: Mon, Apr 24, 2017 3:05 pm
Subject: RE: [RBASE-L] - Thoughts on speeding up a cursor?

I think you have gotten several good answers already but this is what I know 
based on my experience.

Indexes – I had an application that generated random inspection location for a 
large number of records and ran relatively quick. Then it started to run very 
slowly and I could not figure out why at first until I notice one of the techs 
working for me with had removed the indexes and it made a huge difference. Now, 
when looking to speed up code, the first thing I do is make sure I have the 
indices properly configured.

WHILE versus GOTO – I remember that at one time there was an i

Re: [RBASE-L] - Thoughts on speeding up a cursor?

[Alastair Burr]

Karen,

This is the sort of time when it could be useful to be able to see TRACE 
scrolling through on screen when running to next error or, in your case just 
running to the end. You might then be able to see where it slows down or takes 
time over a particular line.

Regards,
Alastair.



On 24/04/2017 17:37, karentellef via RBASE-L wrote:
Here's the thing -- believe it or not, there is NOT A SINGLE PLACE in that 600 
lines of cursor where I am updating a record.  Never, not once.  It does a 
whole bunch of selects, from a whole bunch of different tables, and there's a 
whole bunch of variable calculations.  Depending on conditions, it skips around 
all over the place to retrieve those variables from tables, whether or not to 
make certain calcs, etc.

The only table operation it does is at the very end, when it's done with its 
calculations, it finally inserts one row into a temporary table

I know, hard to believe, isn't it?   I don't think NASA has calculations as 
complicated as this routine just to get a single answer.

Karen



-Original Message-
From: Doug Hamilton 
To: rbase-l 
Sent: Mon, Apr 24, 2017 11:32 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?

Karen - I had a similar speed question when using the UPDATE command on 2/3/15, 
although my questions was more about optimal use of the WHERE clause than GOTO 
and labels.  You, Dennis and others offered many helpful answers.
If you think optimizing the DECLARE CURSOR would help, here is the response 
from Dennis that might help you as far as order of the columns, using parens, 
etc.:


Doug,

First of all, is the column you are updating indexed?  That would slow updating 
it tremendously on a table this long.

If that is not the case I would do this:
1. Make a multi column index on your temp table for the 3 columns in the order 
that is used in your joining where clause.
2. Make the temp table the second table, not the first.
3. Set manopt on to make sure R:BASE follows your optimization.
4. Use this syntax (no parenthesis around the where clause):

UPDATE TxnHist +
SET ChryInvNbr = INV.ChryInvNbr +
FROM TxnHist TXN, ChryInvDtlTmp INV  +
  WHERE  +
TXN.VPlNmbr = INV.VPlNmbr  AND +
TXN.CusPnbr = INV.CusPnbr AND +
TXN.TxDate = INV.InvoiceDate


This will avoid trying to use any of the single indexes in TxnHist, and use a 
very efficient multi-column index to get the update value from the temp table.

Further optimization can be done by changing the where clause (and temp index) 
clause so the most unique column is first.
I suspect InvoiceDate would be the most unique, but only you can answer that 
question.



BTW, I don't think labels and GOTOs are the problem.  Suppose you rewrote the 
code and saved a few milliseconds per loop by "optimizing" the GOTO/labels.  At 
40,000 records that's only a difference of, say, 40 to 120 seconds total (a few 
minutes), hardly a dent in the several hours the program now runs.  I think 
Dennis's first point might be a clue: Updating an indexed column.

Doug

On 4/24/2017 9:50 AM, karentellef via RBASE-L wrote:
That select statement is not my cursor, that's just one of the many 600 lines 
of code that the cursor is evaluating.  The cursor itself would not be 
index-able as it contains >=, not null, etc

I mean, yes, I could look at the many, many select statements within the loop 
(my wild guess is that there's around 50 of them) and maybe there would be 10 
or 15 different potential compound indexes.  I'm not sure if there's a 
practical limit to the number of compound indexes you could create on a single 
table (there would be probably 10 different "lookup" tables).

So yeah, good idea, I'll look at all the lookups and check indexing.  But I'm 
assuming that compounds would only work in instances where all of the 
components are using "=", right?


Karen



-Original Message-
From: Albert Berry 
To: rbase-l 
Sent: Mon, Apr 24, 2017 9:40 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?

Karen - wild thought. Would a compound index work here?
CREATE INDEX LoopTroubles (PolicyID,AgentNo,Policy,CovCode)

This would enable an index only retrieval.

Albert
On Apr 24, 2017, at 8:26 AM, karentellef via RBASE-L 
mailto:rbase-l@googlegroups.com>> wrote:

Dan:

I had actually posted here on the list a few years ago when, as the business 
grew, our cursor (which used to process about 25K rows) started randomly 
crashing in the 30K or 40K range.  Several people here recommended to replace 
the while loop with goto/label, so that's what I did.  The goto works fine, so 
I'm not interested in revisiting a while loop.

I'm not understanding what you're suggesting on a temp table.  I would have to 
create a temp table that would hold probably 30K rows, and my "select into" 
would simply operate against a temp table rather than the perma

Re: [RBASE-L] - "In the Cloud" sound effects

[Alastair Burr]

SET ETHEREAL_SOUNDS ON, maybe?

Regards,
Alastair.

On 21/04/2017 18:52, Bill Downall wrote:
I have an app that was converted to a cloud app recently.

We just noticed that sounds that have always alerted people to data entry 
issues no longer sound on the local computer. I presume if anyone were standing 
(floating?) next to the server-in-the-cloud they would hear the sound.

Is that accurate? Who else has done this? Is there a workaround?

Here's a typical command:

  SET VAR vPlay = (GETVAL('PlayAndExit','sounds\error.wav'))

Bill


--
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] - GetProperty "resistance" to being got!

[Alastair Burr]

Can anybody see anything wrong with this:

SET VAR vFilePathName TEXT = NULL
GETPROPERTY ID_FileName SHORTFILENAME vFilePathName

File List Box On Click custom EEP
Ver: 10.0.2.20307

Both that and LongFileName both resolutely stay null through tracing.

Equivalent code for Directory in Directory Tree control works fine:

GETPROPERTY ID_DirName DIRECTORY vDirectory
PROPERTY ID_FileName DEFAULTDIRECTORY vDirectory

and files displayed correctly in File List Box - I just cannot seem to obtain 
the filename for some reason.

Thanks in advance for any 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.

Re: [RBASE-L] - DECLARE CURSOR Source Data Array

[Alastair Burr]

Create a (temp) table?

Regards,
Alastair.

On 16/02/2017 16:26, Bruce Chitiea wrote:
Thanks, Karen.

That's pretty much what I've been doing. I've been stepping through 
incrementing values within nested loops, or using a loop inside a cursor.

Just wondering how one might replace that "inside" loop with a cursor.

Thinking of a syntax along the lines of:

DECLARE CursorName CURSOR (1,2,3,4,5)
or:
DECLARE CursorName CURSOR ARRAY(arg1,arg2,arg3)

where at their simplest:

arg1 = starting value
arg2 = ending value
arg3 = increment

Thinking major speed improvement and code simplification with a cursor.

Bruce

-- Original Message --
Sent: 2/16/2017 8:17:46 AM
Subject: Re: [RBASE-L] - DECLARE CURSOR Source Data Array
From: "karentellef via RBASE-L" 
mailto:rbase-l@googlegroups.com>>
To: rbase-l@googlegroups.com
Cc:

Can you do a while loop with a ssub?

SET VAR vLoop INT = 1
SET VAR vList = (1,2,3,4,5)
WHILE 1 = 1 THEN
  SET VAR vText = (SSUB(.vList,.vLoop))
  IF vText IS NULL
BREAK
  ENDIF

  -- Do something

  SET VAR vLoop = (.vLoop + 1)
ENDWHILE

Karen




-Original Message-
From: Bruce Chitiea mailto:rby...@safesectors.com>>
To: rbase-l mailto:rbase-l@googlegroups.com>>
Sent: Thu, Feb 16, 2017 10:09 am
Subject: [RBASE-L] - DECLARE CURSOR Source Data Array

All:

Is there an "elegant" way to do this with a simple array of values:

DECLARE CursorName CURSOR FOR (1,2,3,4,5)

... where we're stepping through the array WITHOUT drawing upon a source table?

A long shot:

SELECT 1,2,3,4,5 FROM TableName LIMIT 1

... (where TableName is any table chosen arbitrarily to provide syntax) 
produces:

1 2 3 4 5

... instead of the needed:

1
2
3
4
5

Thoughts?

Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile


--
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'll have to come back to this one later.

Regards,
Alastair.

On 08/02/2017 17:13, Stephen Markson wrote:
My comments are based on the current version, 10.0.2.20126.

Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

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

Thanks,

Unfortunately and despite the help confirming the validity of the syntax I get 
an error:

R>OUTPUT temp.txt ANSI
-ERROR- Syntax is incorrect for the command OUTPUT (2045)


Example 08:

The commands unload the data from the Customer table with ANSI file encoding

 OUTPUT Customer.dat ANSI

UNLOAD DATA FOR Customer

OUTPUT SCREEN

R>show version
R:BASE X, U.S. Version, Build: 10.0.2.11227
(The newer release gives me a problem which I haven't attempted to correct yet, 
preferring to get known problems sorted first.)

Even more puzzled!
Regards,
Alastair.


On 03/02/2017 21:11, Stephen Markson wrote:
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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 1:31 PM
To: rbase-l@googlegroups.com<mailto: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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto:

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Good idea, thanks, I'll give it a go.

Regards,
Alastair.

On 08/02/2017 17:08, Stephen Markson wrote:
It’s only my 1.52 cents worth (I’m in Canada), but here it is:

Running with COLCHECK OFF is quite alright, but the column mismatch error may 
be a bit of a red herring. I think the problem might be in the processing of 
the GROUP BY (in the second SELECT of the UNION). If that’s the case and you 
want to run with COLCHECK ON you could (try to) create two separate views based 
on the two SELECTs in the UNION and then create your final view by doing a 
UNION between the two views.



Regards,

Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 1:17 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

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 

[RBASE-L] - R:BASE X, U.S. Version, Build: 10.0.2.20126: RunTime Error in form

[Alastair Burr]

This is the scenario:

I set trace on at R:>
EDIT USING [Form] WHERE ...
On row entry EEP: no errors
Last line: RETURN
Press [F10]
-ERROR- Expression does not return a valid TIME. 2158
Click [OK]
Error message reappears 3 times then:
Runtime Error!
Program C:\...\RBGX.EXE
R6030
- CRT not initialized

[OK] button unavailable as Windows error:

R:Base X has stopped working... appears

Unable to debug any further.

There are a number of TIME variables which all show as valid in Watch Variables 
at all times until the crash.
This form works in the previous version(s).

Has anybody got any ideas what the cause of this might be?
Thanks & 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.

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

[Alastair Burr]

Thanks,

Unfortunately and despite the help confirming the validity of the syntax I get 
an error:

R>OUTPUT temp.txt ANSI
-ERROR- Syntax is incorrect for the command OUTPUT (2045)



Example 08:

The commands unload the data from the Customer table with ANSI file encoding

 OUTPUT Customer.dat ANSI

UNLOAD DATA FOR Customer

OUTPUT SCREEN

R>show version
R:BASE X, U.S. Version, Build: 10.0.2.11227
(The newer release gives me a problem which I haven't attempted to correct yet, 
preferring to get known problems sorted first.)

Even more puzzled!
Regards,
Alastair.



On 03/02/2017 21:11, Stephen Markson wrote:
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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 1:31 PM
To: rbase-l@googlegroups.com<mailto: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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: February-03-17 8:18 AM
To: rbase-l@googlegroups.com<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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]

e 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@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: January-27-17 12:52 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
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.

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<mailto: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<mailto: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.

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.

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Thank you, Albert.

My owner identifier got a password by mistake. I don't know how.
The owner name is not "owner" and it is not a reserved word; I checked that 
today having thought I may have had a brainwave.
Nor is the name "user" or "none" or "public". Let's call it XYZ.

The name that I use for "owner" has got a password accidentally which I seem to 
be unable to get rid of it. The password that it currently has is "NONE" - on 
all five databases - 3 of which I _know_ with certainty that I did not 
accidentally - in the sense of typing one into a command or RMD file, etc. - 
put a password on. The fourth it is possible that it was connected when I 
thought another one was.

What I cannot get my head around is creating the database anew from unloaded 
files using
CREATE SCHEMA AUTHORIZATION Books XYZ
then as soon as it is finished typing UNLOAD STRUCTURE at the R:> and seeing
CREATE SCHEMA AUTHORIZATION Books XYZ
SET USER XYZ none
at the top.
I nave done nothing to put that additional line there. The structure for that 
particular database fits into the R:> window so I don't even have to redirect 
it. Literally the files load the database, I type those two words and the extra 
line is there after the SETs and before the first create table.
I have to be logged in as the owner which has the password NONE because I can't 
get rid of it. It's catch 22 or a vicious circle or chicken and egg.

Copied & pasted:
CREATE SCHEMA AUTHORIZATION Books XYZ
CONNECT Books

run LOAD files for tables, views, forms & reports
type UNLOAD STRUCTURE and see

SET STATICDB OFF
SET ROWLOCKS ON
SET FASTLOCK OFF
CREATE SCHEMA AUTHOR Books XYZ
SET USER XYZ NONE
CREATE TABLE `Various_Menus` +

Perhaps R:Base "knows" that owner XYZ currently has a password and adds it to 
the new database because it makes sense to. If so, good, but I'm still stuck 
trying to get rid of NONE as a password and have literally nothing.
I've not had time today as I wanted to recreate all the databases today. I'll 
sleep on the problem again tonight and see what tomorrow brings.

Thanks to everyone who has chipped in with suggestions, they're all appreciated.
Regards,
Alastair.


On 31/01/2017 17:06, Albert Berry wrote:
Alistair:

  1.  The owner identifier does not need or use a password.
  2.  Owner is a reserved word
  3.  User is a reserved word
  4.  None is a reserved word
  5.  Public is a reserved word
  6.  Setting the owner to NONE or PUBLIC will remove all the users

Try this:
CONNECT database
RENAME OWNER NONE TO Alistair
DISCONNECT
CONNECT database

At this point you should get a pop up asking for the identifier
If you enter Alistair it should go straight in

If that works, go to Razzak's fte site and read the whole way of running SQL 
Access control

Albert

On Jan 31, 2017, at 7:41 AM, Alastair Burr 
mailto:adbb...@outlook.com>> wrote:

Just to add to this:

I have noticed that a user with the name of my owner user now appears in the 
applet for table privileges but only for the database that I believe to be the 
"cause" of my problem.

This user has no privileges granted and so the tick-boxes are all blank yet it 
has full access.

Regards,
Alastair.



On 31/01/2017 10:07, Alastair Burr wrote:
Thanks Javier,

Yes, I've tried those but my problem is trying to get NO password:

If I recreate all 5 of my databases which all use the same owner and logins and 
start with:

CREATE SCHEMA AUTHORIZATION Books XYZ

and then unload  the structure I get:

CREATE SCHEMA AUTHORIZATION Books XYZ

SET USER XYZ none


I then cannot connect as the owner unless I enter the password as "none" whilst 
other user names are okay (it seems).

If I create a new database with a different owner, say ABC and no password, I 
get the single create line as expected when I unload.

I've not finished playing yet but it _looks_ as if R:Base knows there are other 
similar user logins and cannot accept different passwords for them - which is 
not unreasonable if that were the case but it's not in Razzk's FTE article on 
the subject.

Another weird thing is that sometimes I can use my owner name without having to 
enter the password - maybe when no database is connected when I set the user 
and then connect to the database - I need to investigate this further...

I need also to try recreating the 5 databases all with different owner names 
and see if that stops the additional set user line and then, if it does, try 
changing the owner names back to the one I want.

Regards,
Alastair.



On 30/01/2017 22:30, Javier Valencia wrote:
Alastair,

This are the command I use:

If your database does not have an owner then:

RENAME OWNER PUBLIC TO NewOwner

To add a password use:

SET USER PASSWORD FOR NewOwner TO NewOwnerPassword

It seems to work for me.

Javier,

Javier Valencia, PE
14315 S. Twilight Ln

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Just to add to this:

I have noticed that a user with the name of my owner user now appears in the 
applet for table privileges but only for the database that I believe to be the 
"cause" of my problem.

This user has no privileges granted and so the tick-boxes are all blank yet it 
has full access.

Regards,
Alastair.



On 31/01/2017 10:07, Alastair Burr wrote:
Thanks Javier,

Yes, I've tried those but my problem is trying to get NO password:

If I recreate all 5 of my databases which all use the same owner and logins and 
start with:

CREATE SCHEMA AUTHORIZATION Books XYZ

and then unload  the structure I get:

CREATE SCHEMA AUTHORIZATION Books XYZ

SET USER XYZ none


I then cannot connect as the owner unless I enter the password as "none" whilst 
other user names are okay (it seems).

If I create a new database with a different owner, say ABC and no password, I 
get the single create line as expected when I unload.

I've not finished playing yet but it _looks_ as if R:Base knows there are other 
similar user logins and cannot accept different passwords for them - which is 
not unreasonable if that were the case but it's not in Razzk's FTE article on 
the subject.

Another weird thing is that sometimes I can use my owner name without having to 
enter the password - maybe when no database is connected when I set the user 
and then connect to the database - I need to investigate this further...

I need also to try recreating the 5 databases all with different owner names 
and see if that stops the additional set user line and then, if it does, try 
changing the owner names back to the one I want.

Regards,
Alastair.



On 30/01/2017 22:30, Javier Valencia wrote:
Alastair,

This are the command I use:

If your database does not have an owner then:

RENAME OWNER PUBLIC TO NewOwner

To add a password use:

SET USER PASSWORD FOR NewOwner TO NewOwnerPassword

It seems to work for me.

Javier,

Javier Valencia, PE
14315 S. Twilight Ln.
Olathe, KS 66062
Home: 913-397-9605
Office: 913-829-0888
Cell: 913-915-3137

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Sunday, January 29, 2017 6:57 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thanks, Javier,

Yes, that makes sense even though I checked "everything" "thoroughly" - it's 
easy to see what you want to see and not what is there these days.

I will check it and can do so quite easily simple by removing the aliases in 
one fell swoop. If the view then works I know where the problem is - I just 
have to find it.

However, having got it working I have another problem which I want to resolve 
first:

As intimated in my reply to Razzak, I suspected that the view problem was 
linked to a grant permissions problem.
With the view working that problem has all but gone away - obviously good - yet 
I still have a problem with users and passwords.

As a single user I use four logins simply to create different menus: Public 
(view only); ADBB & Alastair (edit, 2 for the rare occasions I need multi-user) 
and Owner (everything including delete just to make me more careful!)

None of these users has ever had a password. I select the user from a choose 
and just type the name to gain access. I cheat with the Owner selection by 
knowing it is a different name to type so that typing ADBB will get me in but 
typing Owner won't. It's secure enough for me as nobody else in the house uses 
the computer.

The problem that I have now is that, somehow, R:Base seems to think that there 
are passwords and nothing I do seems to clear them. Even an unload/load where 
the database is recreated with
CREATE SCHEMA AUTHOR Records XYZ
does not clear the problem for me. I have tried SET USER XYZ PASSWORD 1234 but 
the command "appears" to be ignored. What I want to do is set the password to 
nothing - I've tried NULL, -0-, '', ``, `  ` (18 spaces) but no 
luck so far.

I now presume that R:Base stores usernames and password combinations somewhere 
other than in the database - not unreasonable if so.

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> 
[mailto:rbase-l@go

Re: [RBASE-L] - Time question

[Alastair Burr]

Use the ADDMIN function - along with it's SEC & HR counterparts and equivalents 
for dates one of my most used functions but which seem to be the least known 
about.

You can also use a negative "addition" to subtract as well - if you see what I 
mean.

Regards,
Alastair.

On 31/01/2017 00:37, Tom Hart wrote:
Is there a way to convert and integer/real to time.  Here is what I want to do
I want to calculate waiting time for customers, so if I know the waiting time 
for each customer is 20 min and the 5th customer wants to know how long the 
wait I can get to the wait is 100 min but how can I convert to a time so it 
would show
1 hr 40 min

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

Thanks Javier,

Yes, I've tried those but my problem is trying to get NO password:

If I recreate all 5 of my databases which all use the same owner and logins and 
start with:

CREATE SCHEMA AUTHORIZATION Books XYZ

and then unload  the structure I get:

CREATE SCHEMA AUTHORIZATION Books XYZ

SET USER XYZ none


I then cannot connect as the owner unless I enter the password as "none" whilst 
other user names are okay (it seems).

If I create a new database with a different owner, say ABC and no password, I 
get the single create line as expected when I unload.

I've not finished playing yet but it _looks_ as if R:Base knows there are other 
similar user logins and cannot accept different passwords for them - which is 
not unreasonable if that were the case but it's not in Razzk's FTE article on 
the subject.

Another weird thing is that sometimes I can use my owner name without having to 
enter the password - maybe when no database is connected when I set the user 
and then connect to the database - I need to investigate this further...

I need also to try recreating the 5 databases all with different owner names 
and see if that stops the additional set user line and then, if it does, try 
changing the owner names back to the one I want.

Regards,
Alastair.



On 30/01/2017 22:30, Javier Valencia wrote:
Alastair,

This are the command I use:

If your database does not have an owner then:

RENAME OWNER PUBLIC TO NewOwner

To add a password use:

SET USER PASSWORD FOR NewOwner TO NewOwnerPassword

It seems to work for me.

Javier,

Javier Valencia, PE
14315 S. Twilight Ln.
Olathe, KS 66062
Home: 913-397-9605
Office: 913-829-0888
Cell: 913-915-3137

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Sunday, January 29, 2017 6:57 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thanks, Javier,

Yes, that makes sense even though I checked "everything" "thoroughly" - it's 
easy to see what you want to see and not what is there these days.

I will check it and can do so quite easily simple by removing the aliases in 
one fell swoop. If the view then works I know where the problem is - I just 
have to find it.

However, having got it working I have another problem which I want to resolve 
first:

As intimated in my reply to Razzak, I suspected that the view problem was 
linked to a grant permissions problem.
With the view working that problem has all but gone away - obviously good - yet 
I still have a problem with users and passwords.

As a single user I use four logins simply to create different menus: Public 
(view only); ADBB & Alastair (edit, 2 for the rare occasions I need multi-user) 
and Owner (everything including delete just to make me more careful!)

None of these users has ever had a password. I select the user from a choose 
and just type the name to gain access. I cheat with the Owner selection by 
knowing it is a different name to type so that typing ADBB will get me in but 
typing Owner won't. It's secure enough for me as nobody else in the house uses 
the computer.

The problem that I have now is that, somehow, R:Base seems to think that there 
are passwords and nothing I do seems to clear them. Even an unload/load where 
the database is recreated with
CREATE SCHEMA AUTHOR Records XYZ
does not clear the problem for me. I have tried SET USER XYZ PASSWORD 1234 but 
the command "appears" to be ignored. What I want to do is set the password to 
nothing - I've tried NULL, -0-, '', ``, `  ` (18 spaces) but no 
luck so far.

I now presume that R:Base stores usernames and password combinations somewhere 
other than in the database - not unreasonable if so.

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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson
Sent: Friday, January 27, 2017 1:13 PM
To: rbase-l@googlegroups.com<mailto: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 
tabl

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Thanks, Jim,

I'll bear that in mind when I check again (see my reply to Javier). Other 
view(s) may well be the cause and that I didn't check.

Regards,
Alastair.

On 29/01/2017 00:07, 'James Bentley' via RBASE-L wrote:
Alistair,
To the best of my knowledge, if you are relying on the LIST COLUMN command
you see only the table columns you DO NOT see the columns defined in views
you need to access the SYS_COLUMNS table to determine if there is a conflict
between previously defined view columns and the View columns you are trying
to create.

The SYS_COLUMNS table contains column names for both TABLE Columns and View
Columns. The LIST COLUMNS command only shows info on Table columns not view
columns.

Jim Bentley, American Celiac Society 1-504-305-2968


____
From: Alastair Burr <mailto:adbb...@outlook.com>
To: "rbase-l@googlegroups.com"<mailto:rbase-l@googlegroups.com> 
<mailto:rbase-l@googlegroups.com>
Sent: Friday, January 27, 2017 1:39 PM
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thanks,

I don't _think_ that's the case as part of the reason I laid the view out so 
precisely was to try and double/triple check the types and see what each 
referred to in both selects.

Nevertheless, I will go back and look again just in case.

And Albert, thanks, I will try quoting the dates as well.

Regards,
Alastair.

On 27/01/2017 19:12, Stephen Markson wrote:
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@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: January-27-17 12:52 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
Regards,
Alastair.



On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,

A few questions ...

01. What is the COLCHECK setting?

SHOW COLCHECK

02. What results do you get when turning OFF the COLCHECK setting.

SET COLCHECK OFF

FYI, COLCHECK ON setting checks the consistency for column names and data types 
when making views.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


At 11:24 AM 1/27/2017, Alastair Burr wrote:


I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layout):

If it hasn't, there should be 6 columns so that I could see the columns and 
data types (first 5 rows remmed out) more easily.

I am not sure that I am defining the time entries correctly - I've tried with 
as well as without quotes.
I am pretty sure I have the data types right - despite the error message.
I am not sure that I have the group by right. I only really need to group by: 
T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist name).

[]


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

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop r

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Thanks, Javier,

Yes, that makes sense even though I checked "everything" "thoroughly" - it's 
easy to see what you want to see and not what is there these days.

I will check it and can do so quite easily simple by removing the aliases in 
one fell swoop. If the view then works I know where the problem is - I just 
have to find it.

However, having got it working I have another problem which I want to resolve 
first:

As intimated in my reply to Razzak, I suspected that the view problem was 
linked to a grant permissions problem.
With the view working that problem has all but gone away - obviously good - yet 
I still have a problem with users and passwords.

As a single user I use four logins simply to create different menus: Public 
(view only); ADBB & Alastair (edit, 2 for the rare occasions I need multi-user) 
and Owner (everything including delete just to make me more careful!)

None of these users has ever had a password. I select the user from a choose 
and just type the name to gain access. I cheat with the Owner selection by 
knowing it is a different name to type so that typing ADBB will get me in but 
typing Owner won't. It's secure enough for me as nobody else in the house uses 
the computer.

The problem that I have now is that, somehow, R:Base seems to think that there 
are passwords and nothing I do seems to clear them. Even an unload/load where 
the database is recreated with
CREATE SCHEMA AUTHOR Records XYZ
does not clear the problem for me. I have tried SET USER XYZ PASSWORD 1234 but 
the command "appears" to be ignored. What I want to do is set the password to 
nothing - I've tried NULL, -0-, '', ``, `  ` (18 spaces) but no 
luck so far.

I now presume that R:Base stores usernames and password combinations somewhere 
other than in the database - not unreasonable if so.

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> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson
Sent: Friday, January 27, 2017 1:13 PM
To: rbase-l@googlegroups.com<mailto: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@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: January-27-17 12:52 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
Regards,
Alastair.


On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,

A few questions ...

01. What is the COLCHECK setting?

SHOW COLCHECK

02. What results do you get when turning OFF the COLCHECK setting.

SET COLCHECK OFF

FYI, COLCHECK ON setting checks the consistency for column names and data types 
when making views.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


At 11:24 AM 1/27/2017, Alastair Burr wrote:

I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layo

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Thanks,

I don't _think_ that's the case as part of the reason I laid the view out so 
precisely was to try and double/triple check the types and see what each 
referred to in both selects.

Nevertheless, I will go back and look again just in case.

And Albert, thanks, I will try quoting the dates as well.

Regards,
Alastair.

On 27/01/2017 19:12, Stephen Markson wrote:
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@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: January-27-17 12:52 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
Regards,
Alastair.



On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,

A few questions ...

01. What is the COLCHECK setting?

SHOW COLCHECK

02. What results do you get when turning OFF the COLCHECK setting.

SET COLCHECK OFF

FYI, COLCHECK ON setting checks the consistency for column names and data types 
when making views.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


At 11:24 AM 1/27/2017, Alastair Burr wrote:


I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layout):

If it hasn't, there should be 6 columns so that I could see the columns and 
data types (first 5 rows remmed out) more easily.

I am not sure that I am defining the time entries correctly - I've tried with 
as well as without quotes.
I am pretty sure I have the data types right - despite the error message.
I am not sure that I have the group by right. I only really need to group by: 
T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist name).

[]


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

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

Again, thank you, Razzak.

I did miss the change and your tip of the day or I missed its significance but 
the timing explains to me why I missed it and why I am now experiencing it.

I can now take the appropriate actions to avoid the problem for that view.

I will also see if I can rework the view to avoid the problem in the first 
place.

Regards,
Alastair.



On 27/01/2017 18:36, A. Razzak Memon wrote:
You are very welcome, Alastair!

As always, the pleasure is all mine.

There is so much being implemented that for some reason, if you missed the Tip 
of the Day, or forgot to refer to What's New PDF, it can create some confusion 
or sudden surprises. Thus, my reason to step-in immediately, before someone 
makes their own assumptions, etc., and creates confusion for the rest of the 
users on this list.

Yes, personally, I do monitor this list with interest, and always do my best to 
reply, help, and/or clarify as much as I can while keeping up with my 16-18 
hours a day, every day, of R:BASE development jobs and responsibilities.

For your information, the COLCHECK setting was first introduced on August 28, 
2015 and then officially released on September 24, 2015 (Versions 9.5 and 10.0).

Here is a snippet from the original Tip of the Day, posted on August 28, 2015.

Please feel free to reach out to me if you have further questions.

Hope that helps!

Very Best R:egards,

Razzak

---

Friday, August 28, 2015

Tip of the Day: About the New COLCHECK Setting
Product.: R:BASE eXtreme 9.5 (32/64) and R:BASE X (Version 10)
Build...: 9.5.5.20924, 10.0.1.10924 or higher
Section.: Settings
Keywords: COLCHECK, CREATE VIEW, CREATE TEMPORARY VIEW, AS alias

Did you know that the upcoming update of R:BASE eXtreme 9.5 (32/64) and the 
official release of R:BASE X (Version 10), to be released on September 24, 
2015, include a new COLCHECK setting?

The additional COLCHECK setting has been introduced to manage common column 
names and corresponding data types when used as ALIAS names while defining a 
new VIEW or modifying an existing VIEW.

COLCHECK specifies if columns will be checked for consistency when making 
views. When COLCHECK is ON (the default), view alias/column names will be 
checked for consistency to other occurrences of those names in the database, 
when the view is created.

Syntax:

SET COLCHECK ON/OFF

Similar checking is already in place when creating or modifying tables, and 
when attaching tables to a database, where R:BASE requires an alias that does 
not cause name/data type conflicts.

If an application requires COLCHECK be off to define a view, the proper results 
should not be expected once COLCHECK is switched back to ON when using the 
view. If a view needs to be created with COLCHECK OFF, it also needs to be used 
with COLCHECK OFF.

An impact may occur for a view that has already been defined, because when 
COLCHECK is ON, the values generated for the view will follow the data type of 
the alias. If an error occurs, the view definition should be reviewed.

---


At 12:51 PM 1/27/2017, Alastair Burr wrote:

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
Regards,
Alastair.


On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,

A few questions ...

01. What is the COLCHECK setting?

SHOW COLCHECK

02. What results do you get when turning OFF the COLCHECK setting.

SET COLCHECK OFF

FYI, COLCHECK ON setting checks the consistency for column names and data types 
when making views.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


At 11:24 AM 1/27/2017, Alastair Burr wrote:

I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layout):

If it hasn't, there should be 6 columns so that I could see the columns and 
data types (first 5 rows remmed out) more easily.

I am not sure that I am defining the

Re: [RBASE-L] - View: Union / Group By - cannot see what's wrong

[Alastair Burr]

Thank you very much, Razzak, setting ColCheck off did the trick.

I notice that if I turn ColCheck back on I immediately get the error message 
again as soon as I try to use the view.

I have looked at the names in the view almost endlessly today to try and see 
where the error was so I am puzzled as to where R:Base finds a difference.

I think I would rather correct that than run with ColCheck set off all the 
time. Obviously I can change the setting in a command file before and after use 
but what has raised this problem is the error message is received whenever I 
reconstruct the database from unloads. (But not with Reload.)

This may be a complete misinterpretation but I also have a suspicion that this 
particular error has been causing problems with my user privileges. Is that 
possible? If so, I may have to run with ColCheck set to off all the time. With 
that in mind when was ColCheck introduced and/or was it changed with the 
upgrade to v10?

Again thanks,
Regards,
Alastair.




On 27/01/2017 16:38, A. Razzak Memon wrote:
Alastair,

A few questions ...

01. What is the COLCHECK setting?

SHOW COLCHECK

02. What results do you get when turning OFF the COLCHECK setting.

SET COLCHECK OFF

FYI, COLCHECK ON setting checks the consistency for column names and data types 
when making views.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


At 11:24 AM 1/27/2017, Alastair Burr wrote:

I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layout):

If it hasn't, there should be 6 columns so that I could see the columns and 
data types (first 5 rows remmed out) more easily.

I am not sure that I am defining the time entries correctly - I've tried with 
as well as without quotes.
I am pretty sure I have the data types right - despite the error message.
I am not sure that I have the group by right. I only really need to group by: 
T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist name).

[]



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

[Alastair Burr]

I know it's Friday but can anybody see what's wrong with this view (an image so 
that hopefully the email system doesn't mangle my layout):

If it hasn't, there should be 6 columns so that I could see the columns and 
data types (first 5 rows remmed out) more easily.

I am not sure that I am defining the time entries correctly - I've tried with 
as well as without quotes.
I am pretty sure I have the data types right - despite the error message.
I am not sure that I have the group by right. I only really need to group by: 
T21.Concert_Date, T22.Full_Name, T23.Full_Name (date, venue name & artist name).

[cid:part1.A35D0010.EE907714@outlook.com]

Any much much appreciated,
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.

Re: [RBASE-L] - RE: Scrolling Region problem

[Alastair Burr]

Now there's a thought, thanks, Karen.

As I indicated, the form has been around for some time. I don't remember but 
I'd guess that must have been around the period of change from 7.5 to 9 when I 
have a note of my last edit of the form. (It's not bad to go for that length of 
time without a need for any adjustment and through one or two upgrades!)

I don't know why I thought earlier today to try a label - exasperation perhaps. 
However, it did cross my mind to wonder why I had a memo. I had no easy was to 
see any wrapped around data and it is unlikely that there would be any need for 
it anyhow - not impossible but unlikely. I may well have chosen the memo just 
in case in the distant past.

It's good to have a possible/probable reason and to have an idea what to look 
for in the future if something similar crops up.

Regards,
Alastair.





On 24/01/2017 19:41, karentellef via RBASE-L wrote:
Alastair:  What version was the database when you converted to version 10?   
One conversion note that I have, and that I've run into, is when I converted 
databases from windows 6.5 to either 9.5 or 10.  If any field on a 6.5 form had 
"wrap" selected rather than "keep on one line" (which you could do with either 
a text or note datatype in 6.5), it converts as a Db/Variable Memo control and 
that creates some issues if you are expecting it to be a DB/Var Edit field 
instead.  So if I converted a form and saw a bunch of DB or Variable Memos and 
didn't want to erase and recreate, I would go back into 6.5, uncheck the 
"wrap", and then re-convert the form and they all came in as Edits.


Karen


-Original Message-
From: Alastair Burr <mailto:adbb...@outlook.com>
To: rbase-l <mailto:rbase-l@googlegroups.com>
Sent: Tue, Jan 24, 2017 12:01 pm
Subject: Re: [RBASE-L] - RE: Scrolling Region problem

Thanks, Razzak.

As expected both work fine.
DBChkBoxInSR is most like mine but I could see nothing significantly different 
between that and mine in terms of the various settings.

However, I have solved the problem:

[cid:part1.C4985E85.4FE1D647@outlook.com]

by changing the VariableMemo to a VariableLabel on the S/R.

Presumably the memo is not supported in v10?


Regards,
Alastair.



On 24/01/2017 15:24, A. Razzak Memon wrote:
Alastair,

What do you observe when using the R:BASE Scrolling Region sample forms 
included with RRBYW19?

Forms:
. DualScrollRegion
. DBChkBoxInSR

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak


At 09:41 AM 1/24/2017, Alastair Burr wrote:


Thanks, but does not seem to be the answer.
However, you did remind me that images can be included.
The first below is as the form opens and the second the result of clicking in 
the 3rd row

[]


Regards,
Alastair

On 24/01/2017 14:13, Dan Goldberg wrote:
Could be the row focus colors?
[]


Dan Goldberg

From: 
<mailto:rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
 [mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Tuesday, January 24, 2017 4:35 AM
To: R:Base Listserver 2016 
<<mailto:rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Subject: [RBASE-L] - Scrolling Region problem

Since upgrading to v10 last April I have had a problem with a Scrolling Region 
not displaying all the tiers at once.

If I click into any row individually the data appears.

Today I have had a thorough look at that part of the form and can see nothing 
wrong.

According to my records it was last changed on 12/09/2010 and had been working 
since then to April last year.

Presumably I am not seeing something obvious but what?

Thanks in advance for any 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 
<mailto:rbase-l+unsubscr...@googlegroups.com><mailto:rbase-l+unsubscr...@googlegroups.com>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>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 
<mailto:rbase-l+unsubscr...@googlegroups.com><mailto:rbase-l+unsubscr...@googlegroups.com>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>https://groups.google.com/d/optout.

--
You received this message because you

Re: [RBASE-L] - RE: Scrolling Region problem

[Alastair Burr]

Thanks, Razzak.

As expected both work fine.
DBChkBoxInSR is most like mine but I could see nothing significantly different 
between that and mine in terms of the various settings.

However, I have solved the problem:

[cid:part1.38A0F521.89F1064B@outlook.com]

by changing the VariableMemo to a VariableLabel on the S/R.

Presumably the memo is not supported in v10?


Regards,
Alastair.



On 24/01/2017 15:24, A. Razzak Memon wrote:
Alastair,

What do you observe when using the R:BASE Scrolling Region sample forms 
included with RRBYW19?

Forms:
. DualScrollRegion
. DBChkBoxInSR

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak


At 09:41 AM 1/24/2017, Alastair Burr wrote:


Thanks, but does not seem to be the answer.
However, you did remind me that images can be included.
The first below is as the form opens and the second the result of clicking in 
the 3rd row

[]


Regards,
Alastair

On 24/01/2017 14:13, Dan Goldberg wrote:
Could be the row focus colors?
[]


Dan Goldberg

From: 
<mailto:rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
 [mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Tuesday, January 24, 2017 4:35 AM
To: R:Base Listserver 2016 
<<mailto:rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Subject: [RBASE-L] - Scrolling Region problem

Since upgrading to v10 last April I have had a problem with a Scrolling Region 
not displaying all the tiers at once.

If I click into any row individually the data appears.

Today I have had a thorough look at that part of the form and can see nothing 
wrong.

According to my records it was last changed on 12/09/2010 and had been working 
since then to April last year.

Presumably I am not seeing something obvious but what?

Thanks in advance for any 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 
<mailto:rbase-l+unsubscr...@googlegroups.com><mailto:rbase-l+unsubscr...@googlegroups.com>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>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 
<mailto:rbase-l+unsubscr...@googlegroups.com><mailto:rbase-l+unsubscr...@googlegroups.com>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>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 
<mailto:rbase-l+unsubscr...@googlegroups.com><mailto:rbase-l+unsubscr...@googlegroups.com>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>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] - RE: Scrolling Region problem

[Alastair Burr]

Thanks, Adrian.

If I remember correctly I had that problem before when a version changed so I 
had already tried reducing the number of tiers and widening them and increasing 
the size of the variable box.

Regards,
Alastair.

On 24/01/2017 15:30, Adrian Hüssy wrote:
I suppose a problem with font size. Test to make the rows one or two pixel 
higher or to reduce the font size by one pixel.
Does it make a difference?

Regards
Adrian

Von: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] Im Auftrag von Alastair Burr
Gesendet: Dienstag, 24. Januar 2017 15:41
An: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Betreff: Re: [RBASE-L] - RE: Scrolling Region problem

Thanks, but does not seem to be the answer.
However, you did remind me that images can be included.
The first below is as the form opens and the second the result of clicking in 
the 3rd row

[cid:part1.4DE22ABD.67EF1AA8@outlook.com]

Regards,
Alastair
On 24/01/2017 14:13, Dan Goldberg wrote:
Could be the row focus colors?
[cid:part2.DDE383BD.64C614DA@outlook.com]

Dan Goldberg

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Tuesday, January 24, 2017 4:35 AM
To: R:Base Listserver 2016 
mailto:rbase-l@googlegroups.com>>
Subject: [RBASE-L] - Scrolling Region problem

Since upgrading to v10 last April I have had a problem with a Scrolling Region 
not displaying all the tiers at once.

If I click into any row individually the data appears.

Today I have had a thorough look at that part of the form and can see nothing 
wrong.

According to my records it was last changed on 12/09/2010 and had been working 
since then to April last year.

Presumably I am not seeing something obvious but what?

Thanks in advance for any 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<mailto: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<mailto: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<mailto: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<mailto: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] - RE: Scrolling Region problem

[Alastair Burr]

Thanks, but does not seem to be the answer.
However, you did remind me that images can be included.
The first below is as the form opens and the second the result of clicking in 
the 3rd row

[cid:part1.B0984734.400AAB3D@outlook.com]

Regards,
Alastair

On 24/01/2017 14:13, Dan Goldberg wrote:
Could be the row focus colors?
[cid:part2.3EA75CAD.37F52AEB@outlook.com]

Dan Goldberg

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Tuesday, January 24, 2017 4:35 AM
To: R:Base Listserver 2016 
mailto:rbase-l@googlegroups.com>>
Subject: [RBASE-L] - Scrolling Region problem

Since upgrading to v10 last April I have had a problem with a Scrolling Region 
not displaying all the tiers at once.

If I click into any row individually the data appears.

Today I have had a thorough look at that part of the form and can see nothing 
wrong.

According to my records it was last changed on 12/09/2010 and had been working 
since then to April last year.

Presumably I am not seeing something obvious but what?

Thanks in advance for any 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<mailto: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<mailto: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] - Scrolling Region problem

[Alastair Burr]

Since upgrading to v10 last April I have had a problem with a Scrolling Region 
not displaying all the tiers at once.

If I click into any row individually the data appears.

Today I have had a thorough look at that part of the form and can see nothing 
wrong.

According to my records it was last changed on 12/09/2010 and had been working 
since then to April last year.

Presumably I am not seeing something obvious but what?

Thanks in advance for any 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.

Re: [RBASE-L] - -ERROR- Insufficient space to process INSERT command ( 235)

[Alastair Burr]

Is it just a typo or my misunderstanding in the last line of your code:

missing the "401" from the temp table name compared to what you say the table 
name is?

Regards,
Alastair.

On 20/01/2017 08:18, MD wrote:

Hello
I have an issue that I am simply stumped.  I am transferring an application 
from 9.5 (32) to Version X Enterprises.  I create the invoice with temporary 
tables and then when everything is right, the user saves the new invoice by 
transferring the information from temporary tables to the permanent tables.
The header tables transfers without a problem but the details table fails and I 
get the following error.

-ERROR- Insufficient space to process INSERT command ( 235)

Nothing special in the code (see below).  Permanent table is InvD401 and the 
temporary table is tInvD401.

-- NOW THE DETAILS
INSERT INTO InvD401 (InvNo400,LineOrder401,Quant401,SKUType900, +
   SKU401,Description401,Taxable401,Price401,Tax401 ) +
   SELECT .ivInvNo400,LineOrder401,Quant401,SKUType900,SKU401, +
   Description401,Taxable401,Price401,Tax401 +
   FROM tInvD ORDER BY LineOrder401

The same identical code works without problems in the 9.5(32) version currently 
in production.  I typed "SHOW" at the R> and all the setting are identical. I 
tried increasing the files from25 to 35 and other setting to no avail.

Cannot understand what is causing it to failed under version 10 (64).  Any 
Blues Clues will be greatly appreciated.
Manuel de Aguiar
M|D Enterprises  Los Angeles, CA



-- 
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] - Wild Card troubles

[Alastair Burr]

Albert,

Just a thought:

When I worked in different countries in Europe, national keyboards were often 
the problem when some characters went "astray". Often the answer was to use the 
key in the position of the UK or perhaps more often the US keyboard position.

I know nothing about Macs but if the keyboard layout is different is the right 
letter being transmitted through the Parallels interface? If the asterisk is in 
a different place you could try using the key that it "should" be.

Regards,
Alastair.



On 04/12/2016 19:14, Albert Berry wrote:

All the character settings are correct. The wild card just doesn’t work.

R>show char
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  "
PLUS+
SINGLE  _
MANY%
IDQUOTES`

Albert



On Dec 4, 2016, at 11:45 AM, A. Razzak Memon 
 wrote:

Albert,

On your CONNected database, check the database CHARacter settings.

SHOW CHAR

R>SHOW CHAR
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  '
PLUS+
SINGLE  _
MANY%
IDQUOTES`

In your case, what is the character setting (symbol) for MANY?

That should provide you with some blue's clues ...

BTW, aging (getting old) makes person wiser and experienced, and
not the other way around, and shall not constitute a complicated
life for R:BASE users.

Very Best R:egards,

Razzak


At 01:09 PM 12/4/2016, Albert Berry wrote:



I'm working on my new MacBook Air, running Windows 7 Pro under Parallels 12. 
Commands fail, although the information is there.

LIST Contact% — shows nothing. There are 7 tables starting with Conntact in the 
name in the database
LIST TABLE Contact% — still nothing
LIST COLUMNS Contact% — still nothing
This is not a fatal error by any means, but it makes life a bit more 
complicated.

Albert

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

[Alastair Burr]

Albert,

I have a RMD program that gives me various levels of access and this what I 
have used up v10:

  GRANT SELECT ON `SYS_Defaults`   TO PUBLIC, 
&vUserList
  GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts3`   TO PUBLIC, 
&vUserList
  GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts`TO PUBLIC, 
&vUserList
  GRANT CREATE TO PUBLIC, 
&vUserList

Since upgrading to v10 it seems to not be enough so I have resorted to using 
the database password all the time.

Regards,
Alastair.

On 28/10/2016 16:45, Albert Berry wrote:
I need to give users rights using GRANT/REVOKE. I have no problem with the user 
tables, but I know that certain system tables will require some rights.

This is a one computer two user system at the moment. I can use the Utility > 
Access rights screen once I know which rights to which of the system tables is 
necessary.

Any and all tips greatly appreciated, on or off list.

Albert


-- 
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] - Number formatting on variable listview?

[Alastair Burr]

Create a temp table/view or a permanent column with the conversion you need?

Regards,
Alastair.

On 19/08/2016 20:29, karentellef via RBASE-L wrote:
Yeah, but how would I display a variable in a list view? And I can't 
really define a form variable because the table that the variable 
lookup list view is defined on is not a table in the form.


Hope you understood that...

Karen



-Original Message-
From: Buddy Walker 
To: rbase-l 
Sent: Fri, Aug 19, 2016 1:12 pm
Subject: RE: [RBASE-L] - Number formatting on variable listview?

Karen
You could try create a text var for double
  SET VAR v9 DOUBLE = 4.9
SET VAR v8 TEXT
SET VAR V8 = (CTXT(FORMAT(.V9,'999.00')))
In the form designer mode (add variables)
V8 = (CTXT(FORMAT(YourColNameHere,'999.00')))
V8 would be datatype text
Buddy
*From:*karentellef via RBASE-L [mailto:rbase-l@googlegroups.com 
]

*Sent:* Friday, August 19, 2016 1:30 PM
*To:* rbase-l@googlegroups.com 
*Subject:* [RBASE-L] - Number formatting on variable listview?
I have a variable lookup view on my form.  I'm displaying columns from 
a permanent table in my database.  Several of the fields are Double 
datatype and I'd like them to all display in the list view with 2 
decimals.  I've looked, and I don't think I can do that, right?  The 
only thing I can think of is to perhaps define a 1-table view that 
sticks the data into a Currency column instead, since I don't normally 
show the $ in my currencies.


Any other tricks?

Thanks!

Karen
--
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] - Switch error message in latest version X

[Alastair Burr]

Thanks Albert,

I'll wait for the next update.

Regards,

Alastair.



On 15/06/2016 18:26, Albert wrote:
Running a test version from a non related bug fix , after running a 
form in edit mode, I have the following variables listed. The test 
version had a minor problem using RSTYLE which has been fixed in the 
next version.


Variable = 
ValueType
 
--   ---
RBTI_FORM_FORMNAME   = 
KCMenu   TEXT
RBTI_DIRTY_FLAG  = 
0INTEGER
RBTI_FORM_ALIAS  = 
-0-  TEXT
RBTI_FORM_MODE   = 
EDIT TEXT
RBTI_FORM_TBLNAME= 
Council  TEXT
RBTI_FORM_DIRTYVAR   = 
0INTEGER
RBTI_FORM_VARNAME= 
xRaceID  TEXT
RBTI_FORM_VARVALUE   = 
3INTEGER
RBTI_FORM_COMPID = 
cRaceID  TEXT


Albert


On 2016-06-15 11:10 AM, Alastair Burr wrote:


This command:

  SWITCH (.RBTI_FORM_MODE)

now produces these error messages:


Column or variable RBTI_Form_Mode not found 2515

Switch Expression must be integer or text


As far as I know it was working in v9.5 and I think before the latest 
update.


The variable is NOT included in the help as one that works.

So my question is should it work?


Regards,

Alastair.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus






---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
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] - Switch error message in latest version X

[Alastair Burr]

This command:

  SWITCH (.RBTI_FORM_MODE)

now produces these error messages:


Column or variable RBTI_Form_Mode not found 2515

Switch Expression must be integer or text


As far as I know it was working in v9.5 and I think before the latest 
update.


The variable is NOT included in the help as one that works.

So my question is should it work?


Regards,

Alastair.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
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] - Can anybody explain this:

[Alastair Burr]

Razzak, thank you, I have read the From the Edge article.

I understand the renaming at various levels although I am only using the 
first level.


What has caught me out is the clearing of the % variables as shown in the 
RUN command help. Please let me try to explain:


I'll paste the relevant part to save anybody else looking it up:

The CLEAR VAR command below will clear all existing % variables (assuming 
your SINGLE character setting is an underscore). The CLEAR VAR uses 2 
underscores, a dash, and an underscore. The passed parameter variables will 
display in TRACE mode as %1-1 in a single nesting level. If a called command 
file calls another, the variable would then be %1-2. The x in "%1-x" is the 
variable nesting level.


RUN cmdfile.rmd USING 'Display This Message' 10

--cmdfile.rmd
SET VARIABLE vstart TIME = .#TIME
SET VARIABLE vwait INTEGER = 0
SET VARIABLE vmessage TEXT = .%1
SET VARIABLE vmax INTEGER = .%2
CLEAR VAR __-_
SET VARIABLE
WHILE vwait < .vmax THEN
SHOW VARIABLE .vmessage
SET VARIABLE vwait = (.#TIME - .vstart)
ENDWHILE
CLS
CLEAR VARIABLES vstart, vwait, %1, %2
RETURN


The first CLEAR VAR command is clearly explained as clearing all specific 
levels of % variables.


To me, the second CLEAR VAR command clears two defined variables (vstart & 
vwait) and the two % variables passed from the RUN command - there are two 
of them, hence %1 & %2.


I was having a problem when I passed 5 variables on one run and then only 4 
of a subsequent run - the fifth one still seemed to be available when I 
didn't want it used.


I thought/assumed that this second CLEAR VAR command which was missing from 
my RMD file was the problem - so I added it with the five variables.
I also thought/assumed that % variables were "special" and it never crossed 
my mind that the % was also a wildcard. I rarely use R:Base wildcards but I 
do (still) in DOS use the * and ? which is more confusion.


So my question now is why does this second CLEAR VAR command have the two % 
variables in it?
If I am reading it correctly the article seems to imply they are not needed 
as they have already been cleared by the first CLEAR VAR command and without 
clearing any other variables ending in whatever specific number.


Just one other point in passing: the USING parmlist help says that 18 values 
can be passed and then says ...and so on through %9 - is there a 
contradiction there or am I missing something else?


Thanks & regards,
Alastair.


-Original Message- 
From: Alastair Burr

Sent: Sunday, May 8, 2016 8:55 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Can anybody explain this:

Thanks Razzak, I'll read properly tomorrow.

Regards,
Alastair.

-Original Message- 
From: A. Razzak Memon

Sent: Sunday, May 8, 2016 6:46 PM
To: rbase-l@googlegroups.com ; rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Can anybody explain this:

Alastair,

In reference to Percent Variables, the following article might help
you understand better ...


From The Edge: Understanding Percent Variables in R:BASE (Date

Posted: June 9, 2006).

http://www.razak.com/fte/

Although the article written in 2006 refers to R:BASE versions 7.5,
7.6, and Turbo V-8,
the principles apply to all versions of R:BASE, including 9.5 and
R:BASE X (Version 10).

Very Best R:egards,

Razzak


At 01:22 PM 5/8/2016, Alastair Burr wrote:

Thank you Razzak & Karen - that explains many things - I'm afraid the pun 
has to be intended there.


However, I'm doing the "CLEAR VAR %1, %2, %3, %4, %5" command as indicated 
in the help for the RUN
command USING parmlist so other that not having any other variables ending 
in those digits how do I

clear the RUN variables?

I have to admit to blindly following the example without thinking but the 
variables have the % in

the name.

Thanks & regards,
Alastair


-Original Message- From: A. Razzak Memon
Sent: Sunday, May 8, 2016 5:44 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Can anybody explain this:

As the variable "vCycle1" ends with "1", using a command like CLEAR
VAR %1 will
clear every variable that ends with "1", based on your setting for MANY 
"%".


This should be consistent with all versions of R:BASE!

Hope that explains.

Very Best R:egards,

Razzak


At 12:21 PM 5/8/2016, Alastair Burr wrote:


No database connected.

R>clear all var

R>show var
Variable   = ValueType
--   --   ---
#DATE  = 08/05/2016   DATE
#TIME  = 17:15:25 TIME
#PI= 3.14159265358979 DOUBLE
SQLCODE= 0INTEGER
SQLSTATE   = 0TEXT
#NOW 

Re: [RBASE-L] - Special characters in R:BASE X, U.S. Version, Build: 10.0.1.20414

[Alastair Burr]

Thanks for the confirmation, Jim.

When you say that you see it in browse/edit do you see every row containing a 
higher character as changed?

I have one table (at least) where all rows containing what should be a ½ have 
the ½ changed to a ? – what I don’t yet know is whether other fractions are 
also a question mark. If so it’s back to a backup but only in due course.

Regards,
Alastair.
From: 'James Bentley' via RBASE-L 
Sent: Friday, April 29, 2016 9:47 PM
To: rbase-l@googlegroups.com 
Subject: Re: [RBASE-L] - Special characters in R:BASE X, U.S. Version, Build: 
10.0.1.20414

Alastair,
Noticed a similar problem using Characters above 128. In my case
I use char above 128 but use the Greek script option and it does
not show the equivalent Greek characters. They showed correctly

in ver 9.5. Problem appears in forms and BROWse/EDIT table options.
Seems to work properly in reports.


Will be addressing this problem with RDCC when semester ends early
in may.


Jim Bentley, American Celiac Society 1-504-305-2968




----
From: Alastair Burr 
To: RBase Listserver  
Sent: Thursday, April 28, 2016 11:11 AM
Subject: [RBASE-L] - Special characters in R:BASE X, U.S. Version, Build: 
10.0.1.20414


In previous versions of R:Base I used an EEP to copy special characters to the 
clipboard for pasting into R:Base.

In the new version this no longer produces the expected characters:

Part of the table I use:

LOAD `ExSpecialCharCodes`
NONUM
'½','0189',1
'¼','0188',2
'¾','0190',3
'à','0224',10
'À','0192',11
'á','0225',12
...
'º','0186',230
'¿','0191',231
'þ','0254',232
'Þ','0222',233

the second column is only for info and the third column is simply a sort 
sequence.

followed by:

CHOOSE vChoose FROM #VALUES FOR SpecialCharacter +
  FROM ExSpecialCharCodes ORDER BY Menu_Sort +
  TITLE .vTitle CAPTION .vCaption LINES .vCount &vChoose_Options
SET CLIPBOARD .vChoose



The characters in the first column that is selected when pasted now either are 
solely a question mark or the character with a question mark in front.

The only thing I could find that might be relevant in changes was the new UTF8 
setting but neither on nor off made any difference.

Windows 10 character map shows the numbers as I have them – at least on the 
ones I have checked.

Does anybody have an ideas what’s different?

Thanks & 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.

[RBASE-L] - Special characters in R:BASE X, U.S. Version, Build: 10.0.1.20414

[Alastair Burr]

In previous versions of R:Base I used an EEP to copy special characters to the 
clipboard for pasting into R:Base.

In the new version this no longer produces the expected characters:

Part of the table I use:

LOAD `ExSpecialCharCodes`
NONUM
'½','0189',1
'¼','0188',2
'¾','0190',3
'à','0224',10
'À','0192',11
'á','0225',12
...
'º','0186',230
'¿','0191',231
'þ','0254',232
'Þ','0222',233

the second column is only for info and the third column is simply a sort 
sequence.

followed by:

CHOOSE vChoose FROM #VALUES FOR SpecialCharacter +
  FROM ExSpecialCharCodes ORDER BY Menu_Sort +
  TITLE .vTitle CAPTION .vCaption LINES .vCount &vChoose_Options
SET CLIPBOARD .vChoose



The characters in the first column that is selected when pasted now either are 
solely a question mark or the character with a question mark in front.

The only thing I could find that might be relevant in changes was the new UTF8 
setting but neither on nor off made any difference.

Windows 10 character map shows the numbers as I have them – at least on the 
ones I have checked.

Does anybody have an ideas what’s different?

Thanks & 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.

Re: [RBASE-L] - Error message: No columns found

[Alastair Burr]

I will when I get a mo’ but as the database unloaded/loaded with no errors 
there should be no problem and, in any case, autochk gives it a clean bill of 
health bar the unused entries.

Regards,
Alastair.

From: Dan Goldberg 
Sent: Wednesday, April 13, 2016 8:18 PM
To: rbase-l@googlegroups.com 
Subject: RE: [RBASE-L] - Error message: No columns found

Did you run it through rscope?

 

Did you see if there were anything funny in the system tables or columns?

 

Dan Goldberg

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Wednesday, April 13, 2016 8:46 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Error message: No columns found

 

Having just reloaded the database I got the same result with autochk.

 

It so happens that I was using AUTOCHK FULL with the database connected.

 

Disconnect and use AUTOCHK Records FULL  gives me:

 

Database statistics:

 

   Table entries allocated:  131  Table entries in use:  131
   Table entry utilization 100.%

 

   Column entries allocated:  396  Column entries in use:  396
   Column entry utilization 100.%

 

   Index entries allocated:  135  Index entries in use:  135
   Index entry utilization 100.%

 

   File #2 active space:  100.  File #2 unusable space:  135
   File #2 utilization 99.9710312862109%

 

No errors found.

More investigation needed!

 

Regards

Alastair.

 

 

From: Alastair Burr 

Sent: Tuesday, April 12, 2016 9:41 PM

To: rbase-l@googlegroups.com 

Subject: Re: [RBASE-L] - Error message: No columns found

 

Loaded Monday last week from an unload file – only been doing conversion checks 
so the utilisation caught my eye as it seems to have gone from 100% in a few 
hours.

 

Regards,

Alastair,

 

From: Dan Goldberg 

Sent: Tuesday, April 12, 2016 6:54 PM

To: rbase-l@googlegroups.com 

Subject: RE: [RBASE-L] - Error message: No columns found

 

When is the last time you reloaded or packed? The utilizations are low. I pack 
mine every night.

 

   Table entries allocated:  295  Table entries in use:  294

   Table entry utilization 99.6610169491525%

 

   Column entries allocated:  1788  Column entries in use:  1788

   Column entry utilization 100.%

 

   Index entries allocated:  158  Index entries in use:  158

   Index entry utilization 100.%

 

   File #2 active space:  1037027750.  File #2 unusable space:  1259098.

   File #2 utilization 99.8787331263585%

 

Dan Goldberg

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Tuesday, April 12, 2016 10:30 AM
To: RBase Listserver
Subject: [RBASE-L] - Error message: No columns found

 

Does anyone know what might cause the above error from the connect command?

 

The database seems to connect despite the message and, clearly there are 
columns:

 

Database statistics:

 

   Table entries allocated:  454  Table entries in use:  131
   Table entry utilization 28.8546255506608%

 

   Column entries allocated:  1310  Column entries in use:  396
   Column entry utilization 30.2290076335878%

 

   Index entries allocated:  444  Index entries in use:  135
   Index entry utilization 30.4054054054054%

 

   File #2 active space:  30.4054054054054  File #2 unusable space:  135
   File #2 utilization 99.8723032851404%

 

No errors found.

Thanks & 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, 

Re: [RBASE-L] - Error message: No columns found

[Alastair Burr]

Having just reloaded the database I got the same result with autochk.

It so happens that I was using AUTOCHK FULL with the database connected.

Disconnect and use AUTOCHK Records FULL  gives me:

Database statistics:

   Table entries allocated:  131  Table entries in use:  131
   Table entry utilization 100.%

   Column entries allocated:  396  Column entries in use:  396
   Column entry utilization 100.%

   Index entries allocated:  135  Index entries in use:  135
   Index entry utilization 100.%

   File #2 active space:  100.  File #2 unusable space:  135
   File #2 utilization 99.9710312862109%

No errors found.

More investigation needed!

Regards
Alastair.


From: Alastair Burr 
Sent: Tuesday, April 12, 2016 9:41 PM
To: rbase-l@googlegroups.com 
Subject: Re: [RBASE-L] - Error message: No columns found

Loaded Monday last week from an unload file – only been doing conversion checks 
so the utilisation caught my eye as it seems to have gone from 100% in a few 
hours.

Regards,
Alastair,

From: Dan Goldberg 
Sent: Tuesday, April 12, 2016 6:54 PM
To: rbase-l@googlegroups.com 
Subject: RE: [RBASE-L] - Error message: No columns found

When is the last time you reloaded or packed? The utilizations are low. I pack 
mine every night.

 

   Table entries allocated:  295  Table entries in use:  294

   Table entry utilization 99.6610169491525%

 

   Column entries allocated:  1788  Column entries in use:  1788

   Column entry utilization 100.%

 

   Index entries allocated:  158  Index entries in use:  158

   Index entry utilization 100.%

 

   File #2 active space:  1037027750.  File #2 unusable space:  1259098.

   File #2 utilization 99.8787331263585%

 

Dan Goldberg

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Tuesday, April 12, 2016 10:30 AM
To: RBase Listserver
Subject: [RBASE-L] - Error message: No columns found

 

Does anyone know what might cause the above error from the connect command?

 

The database seems to connect despite the message and, clearly there are 
columns:

 

Database statistics:

 

   Table entries allocated:  454  Table entries in use:  131
   Table entry utilization 28.8546255506608%

 

   Column entries allocated:  1310  Column entries in use:  396
   Column entry utilization 30.2290076335878%

 

   Index entries allocated:  444  Index entries in use:  135
   Index entry utilization 30.4054054054054%

 

   File #2 active space:  30.4054054054054  File #2 unusable space:  135
   File #2 utilization 99.8723032851404%

 

No errors found.

Thanks & 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] - Error message: No columns found

[Alastair Burr]

Loaded Monday last week from an unload file – only been doing conversion checks 
so the utilisation caught my eye as it seems to have gone from 100% in a few 
hours.

Regards,
Alastair,

From: Dan Goldberg 
Sent: Tuesday, April 12, 2016 6:54 PM
To: rbase-l@googlegroups.com 
Subject: RE: [RBASE-L] - Error message: No columns found

When is the last time you reloaded or packed? The utilizations are low. I pack 
mine every night.

 

   Table entries allocated:  295  Table entries in use:  294

   Table entry utilization 99.6610169491525%

 

   Column entries allocated:  1788  Column entries in use:  1788

   Column entry utilization 100.%

 

   Index entries allocated:  158  Index entries in use:  158

   Index entry utilization 100.%

 

   File #2 active space:  1037027750.  File #2 unusable space:  1259098.

   File #2 utilization 99.8787331263585%

 

Dan Goldberg

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Tuesday, April 12, 2016 10:30 AM
To: RBase Listserver
Subject: [RBASE-L] - Error message: No columns found

 

Does anyone know what might cause the above error from the connect command?

 

The database seems to connect despite the message and, clearly there are 
columns:

 

Database statistics:

 

   Table entries allocated:  454  Table entries in use:  131
   Table entry utilization 28.8546255506608%

 

   Column entries allocated:  1310  Column entries in use:  396
   Column entry utilization 30.2290076335878%

 

   Index entries allocated:  444  Index entries in use:  135
   Index entry utilization 30.4054054054054%

 

   File #2 active space:  30.4054054054054  File #2 unusable space:  135
   File #2 utilization 99.8723032851404%

 

No errors found.

Thanks & 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.

[RBASE-L] - Error message: No columns found

[Alastair Burr]

Does anyone know what might cause the above error from the connect command?

The database seems to connect despite the message and, clearly there are 
columns:

Database statistics:

   Table entries allocated:  454  Table entries in use:  131
   Table entry utilization 28.8546255506608%

   Column entries allocated:  1310  Column entries in use:  396
   Column entry utilization 30.2290076335878%

   Index entries allocated:  444  Index entries in use:  135
   Index entry utilization 30.4054054054054%

   File #2 active space:  30.4054054054054  File #2 unusable space:  135
   File #2 utilization 99.8723032851404%

No errors found.

Thanks & 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.

Re: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a Multi-User Network Environment

[Alastair Burr]

I remember you, I think, mentioned the compatibility mode a while ago which 
I tried at the time but it made no difference to me.


I'll give it a try with the new version when I get a moment.

Regards,
Alastair.

-Original Message- 
From: Albert

Sent: Friday, April 8, 2016 3:38 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


I found that I was freezing up with RBG95_64 to the point that it was
impossible to work. The solution for me was to run RBG95_64.exe in
Compatibility mode. Running solid since. A client is having similar
problems, so we will try the same thing. This happened with a Windows 10
Pro update two or three weeks ago.

Albert

On 2016-04-08 5:51 AM, Alastair Burr wrote:

For what it's worth:

Over the last 6-8 weeks or so I have been having problems with my 
(uncompiled & single user)  backup routine which inserts data to one 
database as it backs up other databases.


With RBase v9.5 and Windows 10 this suddenly started being a problem with 
an RMD file that dates back to Vista days and before.


My solution after a lot of investigating was to add 5 second pauses before 
each reconnect to a (very) recently disconnected database. For whatever 
reason this has mostly solved the problem.


I have, therefore, assumed that Windows 10 is the culprit and some recent 
update 6 or 8 weeks ago caused a change in the way Windows releases files. 
The time taken may vary depending on what else the system is doing thus 
causing the occasional failure even with that pause.


I have only just upgraded to RBase X but my first impression is that the 
same pause is needed but that's not really a surprise for what seems to be 
a Windows problem.


Regards,
Alastair.




-Original Message- From: Brad Davidson
Sent: Friday, April 8, 2016 10:49 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


Just a summary report for those interested in the reviving of compiled 
applications in our multiuser environ.


I closely reviewed my DB backup after noon maintenance, something I did 
not see during remote connection today. Sitting at the server this morning 
found some indexes and constraints dropped, as well, most of our rules. 
Also, operation of the program in multi user mode was uncharacteristically 
pokey and discovered one of our bridged Ethernet ports inop - bad cable - 
see, you can only do so much remotely - one gets spoiled!


Anyway, re-installed RBGXE, rebuilt database from copy before 
optimization, and of course, made a replacement Ethernet patch cable and 
all is good.


Dan, decided - for now - to leave my years-old logic for 
connect/disconnect throughout all programs in my compiled app as is. Will 
beta a version per Razzak's suggestion, and your method - one connection 
in external form file - to review performance pros-cons, in near future...


Brad Davidson

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf 
Of Brad Davidson

Sent: Friday, April 08, 2016 12:25 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


Thanks for this, Razzak, a welcome checklist for my work today!

Brad Davidson

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf 
Of A. Razzak Memon

Sent: Thursday, April 07, 2016 7:12 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


Thursday, April 7, 2016

Tips: Running R:BASE X/XE Compiled Apps in a Multi-User Network 
Environment


So, you have upgraded/migrated your R:BASE 9.5 (32/64) 
database(s)/compiled

application(s) to R:BASE X and R:BASE X Enterprise. Congratulations!

Remember, it took you a while to perfect the network environment and the 
current setup to run your existing R:Compiled R:BASE 9.5 (32/64) databases 
and applications.


Now, consider the checklist and tips to run your migrated R:BASE X and XE 
databases and applications in a multi-user environment as follows:


-- Network Related

01.
If you have created a new folder to run your compiled application on your 
network, make sure to assign the exact same network access (privileges).


02.
If you are running an anti-virus utility/program, make sure to define the 
same exceptions/exclusions, including the new engine DLLs and compiled 
executables.


03.
Every user MUST have "full access rights" to the application folder as 
well as the folder defined for TEMP (SCRATCH) folders.


04.
If everything is under one folder with full access privileges, make sure 
to include "-A" option for user's desktop shortcut to run your compiled 
application.


-- R:Compiler X/XE Related

05.
Using the new R:Compiler X/XE, open the co

[RBASE-L] - Granting permissions to system tables

[Alastair Burr]

Going from v9.5 to X (32 bit):

Is there a document that details what system tables should or should not need 
permissions granted?

It appears that I need to give access to Sys_Indexes before a form can be used 
even though the table can be updated in the data browser.

Thanks in advance,
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.
To post to this group, send email to rbase-l@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BAY177-DS20A421F14738E236242A00AC910%40phx.gbl.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a Multi-User Network Environment

[Alastair Burr]

For what it's worth:

Over the last 6-8 weeks or so I have been having problems with my 
(uncompiled & single user)  backup routine which inserts data to one 
database as it backs up other databases.


With RBase v9.5 and Windows 10 this suddenly started being a problem with an 
RMD file that dates back to Vista days and before.


My solution after a lot of investigating was to add 5 second pauses before 
each reconnect to a (very) recently disconnected database. For whatever 
reason this has mostly solved the problem.


I have, therefore, assumed that Windows 10 is the culprit and some recent 
update 6 or 8 weeks ago caused a change in the way Windows releases files. 
The time taken may vary depending on what else the system is doing thus 
causing the occasional failure even with that pause.


I have only just upgraded to RBase X but my first impression is that the 
same pause is needed but that's not really a surprise for what seems to be a 
Windows problem.


Regards,
Alastair.




-Original Message- 
From: Brad Davidson

Sent: Friday, April 8, 2016 10:49 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


Just a summary report for those interested in the reviving of compiled 
applications in our multiuser environ.


I closely reviewed my DB backup after noon maintenance, something I did not 
see during remote connection today. Sitting at the server this morning found 
some indexes and constraints dropped, as well, most of our rules. Also, 
operation of the program in multi user mode was uncharacteristically pokey 
and discovered one of our bridged Ethernet ports inop - bad cable - see, you 
can only do so much remotely - one gets spoiled!


Anyway, re-installed RBGXE, rebuilt database from copy before optimization, 
and of course, made a replacement Ethernet patch cable and all is good.


Dan, decided - for now - to leave my years-old logic for connect/disconnect 
throughout all programs in my compiled app as is. Will beta a version per 
Razzak's suggestion, and your method - one connection in external form 
file - to review performance pros-cons, in near future...


Brad Davidson

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf 
Of Brad Davidson

Sent: Friday, April 08, 2016 12:25 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a 
Multi-User Network Environment


Thanks for this, Razzak, a welcome checklist for my work today!

Brad Davidson

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf 
Of A. Razzak Memon

Sent: Thursday, April 07, 2016 7:12 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tips: Running R:BASE X/XE Compiled Apps in a Multi-User 
Network Environment


Thursday, April 7, 2016

Tips: Running R:BASE X/XE Compiled Apps in a Multi-User Network Environment

So, you have upgraded/migrated your R:BASE 9.5 (32/64) database(s)/compiled
application(s) to R:BASE X and R:BASE X Enterprise. Congratulations!

Remember, it took you a while to perfect the network environment and the 
current setup to run your existing R:Compiled R:BASE 9.5 (32/64) databases 
and applications.


Now, consider the checklist and tips to run your migrated R:BASE X and XE 
databases and applications in a multi-user environment as follows:


-- Network Related

01.
If you have created a new folder to run your compiled application on your 
network, make sure to assign the exact same network access (privileges).


02.
If you are running an anti-virus utility/program, make sure to define the 
same exceptions/exclusions, including the new engine DLLs and compiled 
executables.


03.
Every user MUST have "full access rights" to the application folder as well 
as the folder defined for TEMP (SCRATCH) folders.


04.
If everything is under one folder with full access privileges, make sure to 
include "-A" option for user's desktop shortcut to run your compiled 
application.


-- R:Compiler X/XE Related

05.
Using the new R:Compiler X/XE, open the compiler project (.RCP) file and 
verify/update the .DAT file as well as the PATH for all resource files, if 
applicable.


06.
Verify and update all sections of Additional Resources, including:
- External Form Files
- Runtime Licenses
- Plugins

07. You MUST use R:BASE X/XE Runtime Licenses, if applicable.

08. You MUST use R:BASE X/XE Plugins, if applicable.

09. Take advantage of Show Loading Window with all new options.

10. Always save your project before compiling the application.

Good luck and make sure that you are having fun!

Very Best R:egards,

Razzak


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

To post to this group, send email to rbase-l@googlegroup