Re: [RBASE-L] - Grab file names in a folder

[Albert Berry]

Make the temp table match the file listing, then cursor the filename column. 
CREATE TEMP TABLE `MyFiles` +
(FileDate DATE,+
FileTime TIME,+
AMPM, TEXT (2),+
FileSize INTEGER,+
FileName TEXT 128)

Albert

> On Oct 10, 2019, at 11:17, Dan Goldberg  wrote:
> 
> I did the output and it gives me all the info.
>  
>  
> Volume in drive \ has no label.
> Volume Serial Number is N/A
>  
> Directory of \\appserv3\salesdb\ 
>  
> 10/02/2119  12:47 PM 594 aa.RMD
> 06/04/2118  06:30 AM   5,479 bobsmonthly.rmd
> 09/30/2119  08:21 AM 899 bowler.rmd
> 09/25/2119  02:46 PM  11,531 dashboard.rmd
> 04/03/2118  03:20 PM   5,137 dealerloactorapp.rmd
> 07/24/2119  01:03 PM   1,344 DealerLocatorUpdate.rmd
> 09/03/2119  10:12 AM  10,227 inv1spnodel.rmd
>7 File(s)  35,211 bytes
>0 Dir(s)0 bytes free
>  
> Is there a way just to get the file name and not the other info?
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> mailto:rbase-l@googlegroups.com>> On Behalf Of Dan 
> Goldberg
> Sent: Thursday, October 10, 2019 10:06 AM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: RE: [RBASE-L] - Grab file names in a folder
>  
> Thx Albert. That will work!
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> mailto:rbase-l@googlegroups.com>> On Behalf Of 
> Albert Berry
> Sent: Thursday, October 10, 2019 10:04 AM
> To: 'jim schmitt' via RBASE-L  <mailto:rbase-l@googlegroups.com>>
> Subject: Re: [RBASE-L] - Grab file names in a folder
>  
> Dan, Import the file names to a temp table and delete as they are completed. 
>  
> Output ThisDir.dat
> DIR *.csv
> Output screen 
> Create temp table …
> Decl cursor c1 for select from temp table
> Proc 1st
> Del from … where count= 1
> Sele count(*) into vNumFilesLeft - - when zero, exit
> Proc Next 
>  
> Albert
>  
> 
> On Oct 10, 2019, at 10:47, Dan Goldberg  <mailto:d...@lancecamper.com>> wrote:
>  
> I need to write a routine that will grab a file, import it, process it, 
> delete it, then grab then next file until they are done in that folder.
>  
> What command do I use to grab the file name if I do not know the name? They 
> will be csv files.
>  
> TIA
>  
> Dan Goldberg 
>  
> -- 
> 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/2E4830CEC16615458329D3D83342F8D0011EBAAD08%40EXCHANGE10
>  
> <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAD08%40EXCHANGE10?utm_medium=email_source=footer>.
>  
> -- 
> 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/CAD6CB61-82A0-4EA4-B98B-7B592EADF864%40albertberry.com
>  
> <https://groups.google.com/d/msgid/rbase-l/CAD6CB61-82A0-4EA4-B98B-7B592EADF864%40albertberry.com?utm_medium=email_source=footer>.
> -- 
> 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/2E4830CEC16615458329D3D83342F8D0011EBAAE75%40EXCHANGE10
>  
> <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EBAAE75%40EXCHANGE10?utm_medium=email_source=foot

Re: [RBASE-L] - Grab file names in a folder

[Albert Berry]

Dan, Import the file names to a temp table and delete as they are completed. 

Output ThisDir.dat
DIR *.csv
Output screen 
Create temp table …
Decl cursor c1 for select from temp table
Proc 1st
Del from … where count= 1
Sele count(*) into vNumFilesLeft - - when zero, exit
Proc Next 

Albert

> On Oct 10, 2019, at 10:47, Dan Goldberg  wrote:
> 
> I need to write a routine that will grab a file, import it, process it, 
> delete it, then grab then next file until they are done in that folder.
>  
> What command do I use to grab the file name if I do not know the name? They 
> will be csv files.
>  
> 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/2E4830CEC16615458329D3D83342F8D0011EBAAD08%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/CAD6CB61-82A0-4EA4-B98B-7B592EADF864%40albertberry.com.

Re: [RBASE-L] - db combo lookup box not showing value

[Albert Berry]

Perhaps displaying the vendor in a text box and having a double click drop down 
EEP on the field that would only see the active vendors?
Albert

> On Sep 11, 2019, at 4:05 PM, Dan Goldberg  wrote:
> 
> I have a part form with a db combo lookup box. I want to use the where clause 
> to only select active vendors, which works fine. But if I want to look at a 
> part that has an inactive vendor the field shows blank.
>  
> How can I show the value but still only let the user see/select the actives?
>  
>  
>  
> 
>  
>  
> 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/2E4830CEC16615458329D3D83342F8D0011EB52B9D%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/03CA3D8E-8286-4A9A-AD31-C6C071EE369D%40albertberry.com.

Re: [RBASE-L] - Sophos Anti-Virus

[Albert Berry]

I am not using Sophos, but sometime in the past I had a similar problem and 
excluded the R:Base .exe executables and extensions .rx1,.rx2,.rx3,.rx4 and 
.rb1,.rb2,.rb3 and rb4. There were some others as well, but this should give 
you some ‘blues clues’. 

Alter



> On Aug 13, 2019, at 9:10 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> Anyone use Sophos?  I have an out-of-state company that uses an external IT 
> service.  They have changed to Sophos AV and say that RBase (version 10 
> Enterprise) is now extremely slow.  Uninstalling Sophos makes everything work 
> fine.  They claim (but I cannot prove, not being there and not knowing how 
> Sophos works) that they have exclusions for the entire directory that the 
> RBase software is installed on (one shared server directory) and the entire 
> directory where the database is.  
> 
> I don't understand a lot about AV.  If everything for RBase is installed on 
> the server, I'm going to assume they have the AV running on both the server 
> and all the workstations, right?  Are exclusions set up on both server and 
> workstations?
> 
> Anyone else using Sophos and having it work okay or not?  
> 
> Thanks!
> 
> Karen
> 
> 
> -- 
> 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/862975966.4997855.1565709014574%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/AE067437-1374-42FA-BE46-E62B8A2D6052%40albertberry.com.

Re: [RBASE-L] - forms problems

[Albert Berry]

Perhaps they are forms based on temporary tables/views?


> On Jul 18, 2019, at 8:33 AM, 'jim schmitt' via RBASE-L 
>  wrote:
> 
> Good morning to all:
> 
> When working with forms this AM, I am seeing something I have never seen 
> before.
> 
> Under Database exployer > FORMS > when viewing the list of form names, form 
> table, on a few forms I see () to the right of the Form Table name.  
> 
> If I highlight the form, and choose design, I get a form design with nothing 
> on it (white screen). 
> Can anyone tell me what causes this?
> 
> Thanks in advance.
> 
> 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/61598.3779725.1563460411323%40mail.yahoo.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/45DD3564-ABE8-4765-A9D0-011E3118D869%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Need assistance when creating an account.

[Albert Berry]

There is a password set for the table, I suspect. 


> On Jul 12, 2019, at 9:50 AM, 'jim schmitt' via RBASE-L 
>  wrote:
> 
> Good Morning:
> 
> I have installed RB X.5 - latest version for a new user.
> New application...when she tries to add a new account, she received the 
> message
> 'Unauthorized access to table PAYERS for user NONE (2039)'.
> I don't understand what is causing this problem.never had it before
> 
> In doing a {CVAL('USER')), it returns a user name of NONE.
> 
> Any assistance would be most appreciated.
> 
> Thanks
> 
> Jim Schmitt
> Ohio Software Services
> 614-863-1850
> 
> -- 
> 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/561383832.931035.1562946652594%40mail.yahoo.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2C40AB5F-94A6-4040-893E-970C8444C002%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - special fonts in body of Rmail email

[Albert Berry]

[U], [/U] for underline

> On May 27, 2019, at 11:10 AM, Albert Berry  wrote:
> 
> Jim, if it is a report, I would create a VARCHAR variable for the particular 
> lines, and apply formatting in the report. 
> If it is a slew of text, try inserting [B] before the text to bold it and 
> [/B] after to return to normal text. I don’t know how to add colors to text. 
> 
> Send me an email when you are in the shop and we can see if it works. 
> 
> Albert. 
> 
>> On May 27, 2019, at 9:11 AM, Jim Belisle > <mailto:j...@kaypark.com>> wrote:
>> 
>> Is the only way to have formatting (underlining, bold and different colors) 
>> in the body of an email generated by Rmail, to use HTML?
>> I would rather not have to learn HTML if I can avoid it but some of my users 
>> are wanting some lines to stand out with the special formatting.
>>  
>> James Belisle
>>  
>> Making Information Systems People Friendly Since 1990
>> 
>>  
>> 
>> -- 
>> 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/DM6PR02MB4539BD5A860BC0B84B9F8759A01D0%40DM6PR02MB4539.namprd02.prod.outlook.com
>>  
>> <https://groups.google.com/d/msgid/rbase-l/DM6PR02MB4539BD5A860BC0B84B9F8759A01D0%40DM6PR02MB4539.namprd02.prod.outlook.com?utm_medium=email_source=footer>.
>> For more options, visit https://groups.google.com/d/optout 
>> <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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/5E741514-CCC1-49AB-BC2C-EB4EF909B2A8%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - special fonts in body of Rmail email

[Albert Berry]

Jim, if it is a report, I would create a VARCHAR variable for the particular 
lines, and apply formatting in the report. 
If it is a slew of text, try inserting [B] before the text to bold it and [/B] 
after to return to normal text. I don’t know how to add colors to text. 

Send me an email when you are in the shop and we can see if it works. 

Albert. 

> On May 27, 2019, at 9:11 AM, Jim Belisle  wrote:
> 
> Is the only way to have formatting (underlining, bold and different colors) 
> in the body of an email generated by Rmail, to use HTML?
> I would rather not have to learn HTML if I can avoid it but some of my users 
> are wanting some lines to stand out with the special formatting.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> 
> -- 
> 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/DM6PR02MB4539BD5A860BC0B84B9F8759A01D0%40DM6PR02MB4539.namprd02.prod.outlook.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/94CC4FFD-7E5F-49D3-9C6D-32658AD1D489%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Form version number

[Albert Berry]

Workaround I have used: copy the form, play with the revisions, etc. in the 
copy until happy, then copy the form back to the original. Modify a couple to 
times to make it v3.
Albert 

> On May 22, 2019, at 1:16 PM,  
>  wrote:
> 
> Doug,
>  
> R:azzak provided the solution to obtain the version by code but you can 
> always find it using the DB Explorer:
>  
> 
>  
> I use the version number to check which is the latest version but I wish 
> there would be an extra field where we could enter our own version number and 
> select which is the working version.
> When I am working on and testing a form/report as I go along, every time I 
> run the form/report from the designer after a change the form is saved (as it 
> should be) and the version number is increased (again as it should be) by one 
> and by the time I am done it might be on version 50 or 60 even when I am on 
> only the second version of the upgraded form.
> It would be handy to have a versioning system where various iterations of the 
> form could be saved with the same name but a different user version number 
> and one could be selected to run as default when the form/report name is 
> called and one could go back to previous version if the new one has 
> issues.…makes sense? Just thinking aloud… 
> Probably will be in the next update. J
>  
> Javier,
>  
> Javier Valencia, PE
> O: 913-829-0888
> C: 913-915-3137
> -Original Message-
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Doug Hamilton
> Sent: Wednesday, May 22, 2019 1:31 PM
> To: R:Base List
> Subject: [RBASE-L] - Form version number
>  
> I'm really beginning to rely on form and report version numbers.
> Is there a property to get the version number of a form or report? (I 
> couldn't find one in RDocs).
> Version # doesn't show in a form Ctrl-Alt-I.
>  
> It would be helpful in a development situation where I'm working on a 
> form and I need to check to make sure the production db has the most 
> recent form.
> TIA,
> Doug
>  
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus 
>  
> -- 
> 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/29deb638-3d50-6b7a-1299-d8c34a3c1ba3%40wi.rr.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 
> .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/!%26!AAAYAO1ueGVb5zRMiwo7hebUe7jCgAAAEPs2XxxwjidEtVRebqBEGKwBAA%3D%3D%40vtgonline.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/5C80DDD1-133B-4A81-947C-EA73DE8E586F%40albertberry.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Form search

[Albert Berry]

DB Explorer
Forms
Highlight All
[Ctrl-F]
Control Properties



> On Apr 17, 2019, at 10:13 AM, jan johansen  wrote:
> 
> All,
>  
> Is there a way to search FORMS for a particular object i.e. Bit Button, Speed 
> Button, etc?
>  
> Jan
> 
> -- 
> 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.

Re: [RBASE-L] - The current R:BASE build is incompatible with the database files.

[Albert Berry]

Point taken, but I was suggesting a rebuild from the backup database.
Albert

> On Apr 8, 2019, at 7:48 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> But not when you can't connect to the database!
> 
> Karen
> 
> 
> 
> -Original Message-
> From: Albert Berry 
> To: rbase-l 
> Sent: Mon, Apr 8, 2019 8:35 am
> Subject: Re: [RBASE-L] - The current R:BASE build is incompatible with the 
> database files.
> 
> Weird errors such as this are often corrected by: 
> 
> CONNECT backups
> OUTPUT bakcupdb.all 
> UNLOAD ALL
> OUTPUT SCREEN
> Create a new folder
> Copy backupdb.ALL and LOB into it
> Start RBGXE
> Navigate to the new folder
> RUN backups.ALL to recreate the database.
> 
>> On Apr 5, 2019, at 10:11 PM, MD > <mailto:m...@mdenterprises.net>> wrote:
>> 
>> I just returned from vacation to a phone call from a customer that she 
>> cannot open the developed application.
>>  
>> I am using:  R:BASE X, Enterprise, U.S. Version, Build: 10.0.4.10912
>>  
>> This one really have me stumped! 
>> This database have been in service for several years but today when I try to 
>> connect to it from the R>, I received the message in a dialog box:
>>  “The current R:BASE build is incompatible with the database 
>> files”, and I cannot connect.
>> With RScope the database checked Ok.  If I do an AUTOCHK dbName, from the R> 
>> it returns no errors.
>> I take the backup from yesterday, drop in the working folder and it works 
>> just fine.
>>  
>> Since the backup works find in the same environment I can assume that the 
>> issue is within the database but with AUTOCHK and RSCOPE showing no errors I 
>> am at a lost.  Here are a few other test performed that I am hoping may shed 
>> a clue to help me.
>>  ACTION  RETURNS
>> CONNECT dbName   The current R:BASE build is 
>> incompatible with the database files.
>> CONNECT dbName WRITE   The current R:BASE build is incompatible 
>> with the database files.
>> CONNECT dbName READ -ERROR- Unable to connect database (   7)
>> CONNECT  Gives me the file box to 
>> choose the db on the folder and then the incompatible message.
>>  
>>  
>> Any help will be greatly appreciated.  †
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - The current R:BASE build is incompatible with the database files.

[Albert Berry]

Weird errors such as this are often corrected by: 

CONNECT backups
OUTPUT bakcupdb.all 
UNLOAD ALL
OUTPUT SCREEN
Create a new folder
Copy backupdb.ALL and LOB into it
Start RBGXE
Navigate to the new folder
RUN backups.ALL to recreate the database.

> On Apr 5, 2019, at 10:11 PM, MD  wrote:
> 
> I just returned from vacation to a phone call from a customer that she cannot 
> open the developed application.
>  
> I am using:  R:BASE X, Enterprise, U.S. Version, Build: 10.0.4.10912
>  
> This one really have me stumped! 
> This database have been in service for several years but today when I try to 
> connect to it from the R>, I received the message in a dialog box:
>  “The current R:BASE build is incompatible with the database 
> files”, and I cannot connect.
> With RScope the database checked Ok.  If I do an AUTOCHK dbName, from the R> 
> it returns no errors.
> I take the backup from yesterday, drop in the working folder and it works 
> just fine.
>  
> Since the backup works find in the same environment I can assume that the 
> issue is within the database but with AUTOCHK and RSCOPE showing no errors I 
> am at a lost.  Here are a few other test performed that I am hoping may shed 
> a clue to help me.
>  ACTION  RETURNS
> CONNECT dbName   The current R:BASE build is 
> incompatible with the database files.
> CONNECT dbName WRITE   The current R:BASE build is incompatible 
> with the database files.
> CONNECT dbName READ -ERROR- Unable to connect database (   7)
> CONNECT  Gives me the file box to 
> choose the db on the folder and then the incompatible message.
>  
>  
> Any help will be greatly appreciated.  †
> 
> -- 
> 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.

Re: [RBASE-L] - Telephone Number Stored as Text Value in a Table

[Albert Berry]

R>SET VAR vPhone TEXT = '(250) 464-5864'
R>set var vDigits TEXT = (SKEEP(.vPhone,'1234567890'))
R>SET VAR vShowPhone TEXT = (FORMAT(.vDigits,'999-999-'))
 
R>SHOW v v%
Variable = ValueType
   --   ---
vPhone   = (250) 464-5864   TEXT
vDigits  = 2504645864   TEXT
vShowPhone   = 250-464-5864 TEXT


> On Mar 24, 2019, at 8:46 AM, Myron Finegold  wrote:
> 
> Background: I have a table that stores a telephone number as a text value.
> Challenge: How do display the telephone number in a form formatted as 
> 555-698-4567 (or something close)?
> I’ve used the input format mask as shown below.
>  
> I’ve tried the format mask (000) 000_;1;_ in a DB Edit ‘Input Format 
> Mask’ field – no joy.
> And I’ve tried !\(999\)\ 000\-;0; - again – no joy.
>  
> 
>  
>  
> And is there a way to format the number is an ‘Enhanced BD Grid Properties’ 
> column field?
>  
> Then of course the question that begs to be asked is; should I change the 
> table data to reflect the output I need?
> If so, what is the best way to accomplish this?
>  
> Myron Finegold
>  
> 
> -- 
> 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.

Re: [RBASE-L] - simple question

[Albert Berry]

This is what I got here. Straight copy and paste into a text file with the 
addition of a first line 
SET VAR vGaugeMsg = ’Somtething’
I cleared vGaugeMsge and got the same thing except it had .vGaugeMsg instead of 
’Something’

I think it might be because it cannot find the CFG file. If you are starting 
from a desktop icon, make sure the icon is set to look in the correct directory 
for the RBGXE.exe and .CFG files. 

Albert


PS - Claire is out of surgery and in recovery. No panics on my cell phone, so 
all the prayers we have been graced with have worked. I’ll be able to visit her 
about lunch time when she is in the ward.

A

> On Mar 21, 2019, at 10:28 AM, Jim Belisle  wrote:
> 
> I bring up the pause with gauge box quite often when running reports. In my 
> test DB the gauge comes up properly (colors, etc).
> In my application it is all plain and not fancy like it should be. I still 
> see only the outline and hardly see the lettering.
>  
> What setting in my CFG or startup file do I need to change in order to have 
> the gauge look like it should?
> This is the code I bring into the code from a command file table within RBASE.
>  
> -- Pause 3 with Gauge. JPB
> PAUSE 3 USING 'Calculating ... Please Stand By ...'  +
> CAPTION .vgaugemsg  +
> ICON WINDOWS  OPTION GAUGE_VISIBLE ON  +
> |GAUGE_COLOR RED  +
> |GAUGE_INTERVAL 10  +
> |MESSAGE_FONT_NAME VERDANA  +
> |MESSAGE_FONT_SIZE 10  +
> |MESSAGE_FONT_COLOR WHITE +
> |THEMENAME Steel Blue
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> 
> -- 
> 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.

Re: [RBASE-L] - Problem with a summary report

[Albert Berry]

With reports such as you describe, I usually create a temp table and just print 
it as detail. 

Create temp table tAgeSummaries (titles etc. Age_Range TEXT (12), Range_Count 
REAL
CREATE VARIABLES for the titles such as .vReptTitle, .vRptTitel2 …

INSERT INTO tAgeSummaries (RptTitle, Title2, Age_Range, Range_count) +
  SELECT .vRptTitle, .vTitle2, Age_Range, COUNT(*) group by  …


SELECT  SUM/COUNT 

> On Feb 11, 2019, at 10:44 AM, 'Patti Jakusz' via RBASE-L 
>  wrote:
> 
> 

-- 
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] - Working with external databases

[Albert Berry]

Javier: it might be the + continuation character. Try a straight long string on 
one line. 
Albert

> On Feb 11, 2019, at 10:28 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> I've never had to use username/password, but my notes say you include them in 
> your string with the semicolon delimiters like this:
> uid=my_user_name;pwd=my_pw
> 
> Karen
> 
> 
> 
> -Original Message-
> From: javier.valencia  >
> To: rbase-l mailto:rbase-l@googlegroups.com>>
> Sent: Mon, Feb 11, 2019 11:10 am
> Subject: RE: [RBASE-L] - Working with external databases
> 
> Thanks Buddy,
> I don’t believe the Access database requires an userid and password; I can 
> open it from Access directly. I will check with the creator of that database. 
> Where would I add the userid and password on the SCONNECT command?
>  
> Javier,
>  
> Javier Valencia, PE
> O: 913-829-0888
> C: 913-915-3137
>  
>  
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Buddy Walker
> Sent: Monday, February 11, 2019 7:50 AM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - Working with external databases
>  
> Javier
>Is it access rights. You may need a  user (uid) and password (psw).
>  
> Buddy
>  
>  
> From: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>> On Behalf Of 
> javier.valen...@vtgonline.com 
> Sent: Monday, February 11, 2019 1:58 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - Working with external databases
>  
> I am connecting to an external database using the DSNless command:
>  
> SET VAR vcommandC = ('SCONNECT ' +  +
> + ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program Files (x86)\sPMS 
> Program\SAMS.mdb;' + )
> 
>  
> And then SATTACH a table using the command:
> SATTACH 'SegmentData' AS 'ASegmentData' USING ALL ALIAS +
> ASubSection, +
> ASegmentID, +
> ARoad, +
> ABegSeg, +
> AEndSeg, +
> ADistrict, +
> APavementType, +
> ALength, +
> AWidth, +
> ATotalSize, +
> ALanes, +
> ADirection, +
> AClass, +
> ARightOfWay, +
> ABegMilepost, +
> AendMilepost, +
> AUtilities
>  
> I can access the table and data and run queries but I am having problems 
> trying to delete and insert rows to the attached table. For example, the 
> following command does not seem to work:
> DELETE ROWS FROM ASegmentData WHERE(ASubSection+ ASegmentID) +
> NOT IN (SELECT seg_chk FROM features WHERE sub_sys = 'CJC')
>  
> If a project the attached table to a local table:
>  
> PROJECT TEMPORARY BSegmentData FROM ASegmentData USING *
>  
> And run the DELETE ROWS command on the projected table it works correctly so 
> I know the syntax is correct, same thing with the
> INSERT INTO…
> command, works great on the projected table but not on the SATTACHEd table.
>  
> I am obviously missing something because I am pretty sure R+Base can 
> add/delete rows on external databases/tables and I believe I have done this 
> before but I can’t seem to find that particular application. Any help will be 
> greatly appreciated.
>  
> Javier,
>  
> Javier Valencia, PE
> O: 913-829-0888
> C: 913-915-3137
>  
>  
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of javier.valen...@vtgonline.com 
> Sent: Thursday, February 07, 2019 11:22 AM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - SQL tutorial
>  
> You can easily check this yourself. Place the following code in a command 
> file makings sure that vPOID has a valid value
>  
> SET ERROR VAR hold
> SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND 
> ReceiptStatus = 'P'
> IF hold = 0 THEN
>  
> Trace the code one line at the time looking at variables hold and vchk.
> Look at the value for vchk and hold after the code executes the second line.
> This should tell you how the ERROR VAR changes depending on whether you get a 
> valid value for vchk or not.
>  
> Javier,
>  
> Javier Valencia, PE
> O: 913-829-0888
> C: 913-915-3137
>  
>  
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of jan johansen
> Sent: Thursday, February 07, 2019 11:09 AM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - SQL tutorial
>  
> Group,
>  
> Part of this didn't get answered, maybe  obliquely.
>  
> In the OLD code
> IF Hold = 0
> Does that mean success or failure?
>  
> Jan
>  
>  
>   
> From: "jan johansen"  >
> To: rbase-l@googlegroups.com 
> Date: Tue, 05 Feb 2019 15:41:06 -0800
> Subject: 

Re: [RBASE-L] - SQL tutorial

[Albert Berry]

I use Razzak’s code, but with the addition of ‘AND LIMIT = 1’ causing the 
search to stop when it finds the first row. 
Albert

> On Feb 5, 2019, at 6:28 PM, A. Razzak Memon  wrote:
> 
> Jan,
> 
> Here is one approach to validate the existence of a row ...
> 
> SET VAR vRows INTEGER = 0
> SELECT COUNT(*) INTO vRows INDICATOR iv1 FROM PODetail WHERE PO_ID = .vPOID 
> AND ReceiptStatus = 'P'
> 
> IF vRows = 0 THEN
>   CLS
>   PAUSE 2 USING 'No record found!' CAPTION 'Receipt Status' ICON WARNING +
>   BUTTON 'Press any key to continue ...' +
>   OPTION BACK_COLOR WHITE +
>   |MESSAGE_FONT_NAME Tahoma +
>   |MESSAGE_FONT_COLOR RED +
>   |MESSAGE_FONT_SIZE 12
>   GOTO Done
> ENDIF
> 
> -- Do what you have to do here ...
> -- Example
>   CLS
>   EDIT USING ReceiptStatus WHERE PO_ID = .vPOID AND ReceiptStatus = 'P'
> LABEL Done
>   CLEAR VARIABLES iv%,vRows
>   RETURN
> 
> Hope it helps!
> 
> Razzak
> 
> 
> At 06:41 PM 2/5/2019, jan johansen wrote:
> 
>> All,
>> 
>> I think I need a SQL refresher.
>> I need to update old code that looks like this.
>> 
>> SET ERROR VAR hold
>> SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND 
>> ReceiptStatus = 'P'
>> IF hold = 0 THEN
>> 
>> So is
>> IF hold = 0 the same as
>> IF SQLCODE = 0?
>> 
>> Sorry such a dumb question.
>> 
>> Jan
>> 
>> --
>> 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.

Re: [RBASE-L] - Code update

[Albert Berry]

We also sat side by side at a “pull” contest watching your sweetie use his 8 
million horsepower pickup truck …
That was fun!
Albert

> On Jan 21, 2019, at 9:52 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> Gosh, remember you and me sitting side by side cranking out code for Howard 
> Simon's huge client???  We had a lot of the early "legends" in that room back 
> then, didn't we?  It was fun working with you
> 
> Karen
> 
> 
> -Original Message-
> From: Albert Berry 
> To: rbase-l 
> Sent: Mon, Jan 21, 2019 10:47 am
> Subject: Re: [RBASE-L] - Code update
> 
> I think you converted me to Jeff’s idea during my Chicago days. 
> Albert
> 
>> On Jan 21, 2019, at 8:50 AM, 'Karen Tellef' via RBASE-L 
>> mailto:rbase-l@googlegroups.com>> wrote:
>> 
>> I don't know if any of you remember Jeff Ward, I worked with him on RBase 
>> projects in the 90s, and he and I were the co-chairs of the Chicago Area 
>> RBase Users Group (CARBUG)
>> 
>> Anyway, at one of our meetings he put out a challenge that he could replace 
>> any Declare Cursor with a series of SQL commands (update and such) and have 
>> the SQL work perform faster.  People brought examples and he was able to 
>> convert each one if I remember correctly.  
>> 
>> In case you knew Jeff, he quit all programming years ago, made a bit of 
>> money inventing the Lapinator  (one of the first laptop "desks" of which his 
>> website named me as the muse for the idea).  He is heavy into local politics 
>> here in the Chicago area, has been jailed by the political folk he routinely 
>> ticks off (altho he welcomes it because his jail posts are priceless), has 
>> his own political blog, is a columnist in local papers, or you can search 
>> Facebook for the "Curmudgeon Book Club"
>> 
>> Karen
>> 
>> 
>> 
>> 
>> -Original Message-
>> From: Dan Goldberg mailto:d...@lancecamper.com>>
>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>> mailto:rbase-l@googlegroups.com>>
>> Sent: Sun, Jan 20, 2019 4:10 pm
>> Subject: Re: [RBASE-L] - Code update
>> 
>> I use temp tables alot to speed up processing and view usage. They make a 
>> huge difference!
>> 
>> Daniel Goldberg
>> Mis Manager
>> Lance Camper
>> 
>> 
>> 
>> 
>> On Sat, Jan 19, 2019 at 3:47 PM -0800, "jan johansen" 
>> mailto:j...@jjcalibrations.com>> wrote:
>> 
>> All,
>>  
>> I've been tasked with going through all old code looking for areas to 
>> improve.
>>  
>> One area is evaluating and updating cursors.
>>  
>> Old code ran a cursor and took 63 seconds.
>> New code runs temporary tables and select update and now takes 2 seconds.
>>  
>> It's a win.
>>  
>> Jan
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.c

Re: [RBASE-L] - Code update

[Albert Berry]

I think you converted me to Jeff’s idea during my Chicago days. 
Albert

> On Jan 21, 2019, at 8:50 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> I don't know if any of you remember Jeff Ward, I worked with him on RBase 
> projects in the 90s, and he and I were the co-chairs of the Chicago Area 
> RBase Users Group (CARBUG)
> 
> Anyway, at one of our meetings he put out a challenge that he could replace 
> any Declare Cursor with a series of SQL commands (update and such) and have 
> the SQL work perform faster.  People brought examples and he was able to 
> convert each one if I remember correctly.  
> 
> In case you knew Jeff, he quit all programming years ago, made a bit of money 
> inventing the Lapinator  (one of the first laptop "desks" of which his 
> website named me as the muse for the idea).  He is heavy into local politics 
> here in the Chicago area, has been jailed by the political folk he routinely 
> ticks off (altho he welcomes it because his jail posts are priceless), has 
> his own political blog, is a columnist in local papers, or you can search 
> Facebook for the "Curmudgeon Book Club"
> 
> Karen
> 
> 
> 
> 
> -Original Message-
> From: Dan Goldberg mailto:d...@lancecamper.com>>
> To: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>>
> Sent: Sun, Jan 20, 2019 4:10 pm
> Subject: Re: [RBASE-L] - Code update
> 
> I use temp tables alot to speed up processing and view usage. They make a 
> huge difference!
> 
> Daniel Goldberg
> Mis Manager
> Lance Camper
> 
> 
> 
> 
> On Sat, Jan 19, 2019 at 3:47 PM -0800, "jan johansen" 
> mailto:j...@jjcalibrations.com>> wrote:
> 
> All,
>  
> I've been tasked with going through all old code looking for areas to improve.
>  
> One area is evaluating and updating cursors.
>  
> Old code ran a cursor and took 63 seconds.
> New code runs temporary tables and select update and now takes 2 seconds.
>  
> It's a win.
>  
> Jan
> -- 
> 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 
> .

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

[Albert Berry]

Which report?
I’ll have a look
Albert

> On Jan 18, 2019, at 9:51 AM, Jim Belisle  wrote:
> 
> How does one delete a sub report from an existing report?
> I have tried clicking on the sub report and using the delete button or the F9 
> button. No luck there.
> I looked in the help under sub report and saw nothing about deleting a sub 
> report.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> 
> -- 
> 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.

Re: [RBASE-L] - FW: RBase error

[Albert Berry]

Ajay, I googled Error 216. Your Win 7 machine probably has a virus. 

Getting Rid of Runtime Error 216 « wiki-errors.com
wiki-errors.com/getting-rid-of-runtime-error-216/ 
 

 

 

Getting Rid of Runtime Error 216. ... When left alone for too long, this 
Runtime Error can blossom and create more havoc such as sudden system freezes 
and/or crashes. Runtime Error 216 Causes. The number one most common cause for 
this specific Runtime Error is the SubSeven Trojan Virus infecting a PC.

One solution is MalwareBytes. Even the free version should be able to get rid 
of it.

Albert
> On Jan 17, 2019, at 8:55 AM, Ajay Sanghvi  wrote:
> 
> Good Morning 
>  
> I have a compiled App that when run on a Win 10 Machine runs without an error 
> but the same compiled app on a Win 7 gives the following error. 
> What am I missing?
>  
> 
>  
>  
> AJAY SANGHVI
> Vice President
> 700 Blair Road
> Carteret, New Jersey  07008 U.S.A.
> 
> T (973) 748 8980 
> F (973) 680 9618
> E asang...@berjeinc.com 
>  
>  
>  
> 
> Berjé Inc. - an SQF Level 3 Quality Certified Supplier No. 7751 and Certified 
> by WQS. 
> ** Markets are moving rapidly, please note all prices and volume offers are 
> kindly to be considered subject final confirmation, including any pending 
> tariff changes, unless otherwise stated. ** 
> 
> -- 
> 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.

Re: [RBASE-L] - Enhanced DBGRID

[Albert Berry]

Doesn’t apply to the whole grid, only to a date object. 
Albert

> On Dec 28, 2018, at 5:39 AM, Ajay Sanghvi  wrote:
> 
> Hello all
>  
> I am not sure what I am missing but in my DB grid properties the ability to 
> click on Date picker is grayed out. Any ideas why?
>  
> 
>  
> AJAY SANGHVI
> Vice President
> 700 Blair Road
> Carteret, New Jersey  07008 U.S.A.
> 
> T (973) 748 8980 
> F (973) 680 9618
> E asang...@berjeinc.com 
>  
>  
> 
> Berjé Inc. - an SQF Level 3 Quality Certified Supplier No. 7751 and Certified 
> by WQS. 
> ** Markets are moving rapidly, please note all prices and volume offers are 
> kindly to be considered subject final confirmation, including any pending 
> tariff changes, unless otherwise stated. ** 
> 
> -- 
> 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.

Re: [RBASE-L] - Happy Holidays from R:BASE Technologies

[Albert Berry]

And a very happy 2019 to everyone on and off this list from Canada.
Albert

> On Dec 24, 2018, at 8:42 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> SET HAPPY_HOLIDAYS ON
> 
> 
> Karen
> 
> 
> 
> -Original Message-
> From: A. Razzak Memon 
> To: rbase-l 
> Sent: Mon, Dec 24, 2018 9:21 am
> Subject: [RBASE-L] - Happy Holidays from R:BASE Technologies
> 
> Monday, December 24, 2018
> 
> Dear R:BASE Community,
> 
> He's making a database.
> 
> He's sorting it twice.
> 
>   R> SELECT * FROM Contacts WHERE Behavior = 'Nice' ORDER BY LastName
> 
> R:Santa Clause is coming to town!
> 
> The team at R:BASE Technologies would like to extend our sincere 
> thanks and appreciation
> for your business, partnership, and friendship!
> 
> In celebrating our 20th Anniversary, we are grateful for your role in 
> our achievements,
> and look forward to providing new opportunities to help you reach 
> your goals for growth
> and prosperity.
> 
> We're honored that a uniquely warm-spirited community has let us be a 
> part of your
> business, and we are overwhelmingly proud to have been able to 
> deliver products and
> support that have helped achieve your database objectives!
> 
> However you celebrate, we wish you the very best for this holiday 
> season and a happy,
> healthy, and prosperous 2019!
> 
> My very best R:egards,
> 
> Razzak
> 
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Enhanced DB Grid Question - Version 10X

[Albert Berry]

Deselect TabStop on all the ReadOnly Columns. 
Albert

> On Dec 17, 2018, at 12:10 PM, Bill Eyring  wrote:
> 
> That only works on 2nd and successive rows, not on first row.
>  
> Thanks,
>  
> Bill
>  
> From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com 
> ] 
> Sent: Monday, December 17, 2018 1:15 PM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - Enhanced DB Grid Question - Version 10X
>  
> On the properties of the enhanced grid itself, you'll see a checkbox for 
> "skip read only columns"
>  
> Karen
>  
>  
>  
> -Original Message-
> From: Bill Eyring mailto:beyr...@lampsoftware.com>>
> To: rbase-l mailto:rbase-l@googlegroups.com>>
> Sent: Mon, Dec 17, 2018 11:54 am
> Subject: [RBASE-L] - Enhanced DB Grid Question - Version 10X
> 
> I have a number forms which contain Enhanced DB Grids.
>  
> I have No need for filters in these grids.
>  
> All of the grids that I am talking about have one thing in common;
>  
> all columns are read-only except for one column that I need to 
> edit.
>  
> The column that I need to edit is necessarily in the middle of the grid.
>  
> Being the only editable column in the grid, I cannot find any command to set 
> the focus on that editable column.
>  
> It seems that the focus is always on the first column of the grid until I 
> actually click on the editable column, then that keeps focus through the 
> whole grid.
>  
> My question then is;
>  
> Is there any way to automatically set focus on the first editable column in 
> an enhanced DBgrid ?
>  
>  
>  
> Thanks,
>  
> Bill Eyring
> Lamp Software Inc
> 516-965-3890
>  
> -- 
> 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 
> .

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

[Albert Berry]

Check your windows settings to see if R:Base is “allowed” to access 
Thunderbird. Sometimes weird things crop up with computers. 
Albert

> On Dec 11, 2018, at 3:06 PM, Carpet Broker, Dick Fey  
> wrote:
> 
> This is NOT actually an R:base issue, but is driving us completely nuts.
> 
> Many places in our R:base X application automatically sends out emails. 
> (invoice, confirmations, etc)
> We use the EMAIL ON code in the print command.  All the settings are drawn 
> from a user table.
> For years all worked fine, now 2 of our users cannot send emails, even though 
> there have been no changes
> to the R:base code, nor to the email program itself.  We all use Thunderbird 
> as our E:Mail client.
> They have no problem sending or receiving mail directly from Thunderbird.
> 
> I have discussed with John Minyo tryng R:Mail, but he doesn't think that's 
> going to solve our problem.
> 
> Anyone have a suggestion as to where I might look?
> 
> Dick Fey
> Carpet Broker Inc.
> 
> Code is below:
> 
>   PRINT  +
>   WHERE refnum = .vrefnum  OPTION PDF | ORIENTATION PORTRAIT +
>   |FILENAME  +
>   |EMAIL ON +
>   |EMAIL_HOST mail.thecarpetbroker.COM +
>   |EMAIL_USERID  +
>   |EMAIL_PASSWORD  +
>   |EMAIL_TO_LIST   +
>   |EMAIL_BCC_LIST  +
>   |EMAIL_FROM_NAME Carpet Broker +
>   |EMAIL_FROM_ADDRESS  +
>   |EMAIL_SUBJECT   +
>   |EMAIL_BODY   +
>   |EMAIL_AUTHENTICATION ON +
>   |EMAIL_DELETE_AFTER_SEND OFF +
>   |EMAIL_SHOW_DIALOG OFF
> 
> -- 
> Carpet Broker Inc
> P: 913-894-9211
> F: 913-894-0138
> 
> 
> -- 
> 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.

Re: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Albert Berry]

Check into the settings of your virus/malware programs. They may be slowing 
down the import to the point that R:Base thinks it’s done before it is. 
Albert

> On Dec 9, 2018, at 6:06 PM, Bruce A. Chitiea  wrote:
> 
> Win10Pro / RGBX5E
> 
> GATEWAY IMPORT CSV
> 
> Wondering if there's a practical limit to the record count or file size of a 
> source CSV file, or if there's a "choke" setting to be tweaked.
> 
> I had successfully imported several CSV files, the largest of which contained 
> 634,500 records (101mb. )
> 
> RBASE started and then dropped efforts (without error message) to import a 
> file containing 800,000 records (128mb. )
> 
> Without additional modification to internal data or structure, once this file 
> was cut into halves (400,000 records, @64mb each), RBASE happily imported the 
> halves.
> 
> Thoughts?
> 
> Best wishes for the season, all!
> 
> Bruce Chitiea
> SafeSectors, Inc.
> 909.238.9012  m 
> 
> -- 
> 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.

Re: [RBASE-L] - Looking for Column Info in forms

[Albert Berry]

Open a form. Open the object inspector [View - Toolbars]. Increase the size of 
the inspector for existing components to include the Component ID column. 

Albert

> On Dec 6, 2018, at 9:46 AM, Doug Hamilton  wrote:
> 
> I think I trashed several forms and need to remake them, so I'm looking for a 
> way to easily get some component info.
> 
> The forms have an enhanced DBGrid with 9 columns.
> Is there a way to to quickly find a list of the properties for each column 
> rather than F11 the grid, choosing Columns, going to each column, clicking 
> Column properties and going through the various tabs to write down the 
> options I need?
> 
> Object Inspector has the format I'm looking for, but I can't find detail info 
> on the columns.  (Not saying that I didn't miss it :)
> Are column properties available somewhere in Object Inspector?  Or somewhere?
> 
> TIA,
> Doug
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> -- 
> 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.

Re: [RBASE-L] - PK autonumber question

[Albert Berry]

I have encountered this problem a few times over the years. As it is possible 
to PACK INDEX in multiple user live environment, in some situations I have done 
this on the way into the form. (ON BEFORE START EEP) This has cut the error 
count down significantly. 

Albert 

> On Dec 5, 2018, at 3:24 PM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> Well, there's the good old-fashioned way of resetting the autonumber.  This 
> is safe to do in multi-user in terms of design, but I'm not sure what the 
> result would be if you tried to renumber as a person is adding a new row to 
> the table simultaneously
> 
> select max(id) into vcount from tablename
> set var vcount = (.vcount + 1)
> autonumber idcolumn in tablename using .vcount, 1 nonum
> 
> 
> Karen
> 
> 
> 
> -Original Message-
> From: Tom Frederick  >
> To: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>>
> Sent: Wed, Dec 5, 2018 4:09 pm
> Subject: [RBASE-L] - PK autonumber question
> 
> I have had a couple of incidents where an auto numbered  Primary Key will 
> change the next Initial key value (1100) to less than the current actual 
> maximum value (1102). That creates the ‘must be unique number’ error. The 
> error is rarely the same table.  The database was just rebuilt two days ago 
> with no messages.  So two questions:
>  
> 1.   Is there a way to create a variable for a table’s current PK initial 
> key auto number to check against the actual maximum row number used?
> 2.   Is there a way to change a table’s initial key number while the 
> database is in active use without using the ‘design table’ option? Learned 
> the hard way (a long time ago) to not use the ‘design table’ while users are 
> active.  
>  
> Tom Frederick
> Elm City Center
> President/CEO
> 1314 W Walnut
> Jacksonville, IL 62650
> tom.freder...@elmcity.org 
> 217-245-9504 
> 217-370-9437 
>  
> -- 
> 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.

Re: [RBASE-L] - SQL Help - OT

[Albert Berry]

Bill, my example above used the RowID as the “ordering" column, and returned 
the results from his admittedly small sample set. That is how I read his query. 

Albert

> On Nov 27, 2018, at 11:04 AM, Bill Downall  wrote:
> 
> Unfortunately for you, Paul, the SQL definition of a table is "an unordered 
> set of rows." So the concept of a "next row" is problematic to building a 
> query. Your query provides the order through the ORDER BY clause.
> 
> Will the ID2 column match a ID1 column more than once in the table?
> 
> I'd be working on something like:
> 
> SELECT t1.ROWID, t1.PART_ID, t1.ID1, t1.ID2 +  
>   FROM tablename t1 +
>   WHERE t1.ID2 NOT IN +
> (SELECT t2.ID2 FROM tablename t2) +
>   ORDER BY 1,2,3,4
> 
> Bill
> 
> On Tue, Nov 27, 2018 at 10:27 AM  > wrote:
> Dan,
> 
>  
> 
> It will always be the previous row. I would sort on the ID1 column so it 
> would always be the previous row.
> 
>  
> 
> Thanks,
> 
> Paul
> 
>  
> 
> From: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>> On Behalf Of Dan 
> Goldberg
> Sent: November 27, 2018 10:09 AM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - SQL Help - OT
> 
>  
> 
> Is it only from the previous row or any of the rows?
> 
>  
> 
> Dan Goldberg
> 
>  
> 
>  
> 
> From: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>> On Behalf Of 
> p...@buckleyandassoc.com 
> Sent: Tuesday, November 27, 2018 6:48 AM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - SQL Help - OT
> 
>  
> 
> Dan,
> 
>  
> 
> Thanks but it’s only coincidental that the sample I created I needed the 
> “odd” rowid’s. My guess is it will be 50/50 odd or even.
> 
>  
> 
> What I need is to check ID1 & ID2 and if the ID1 from the next row equals the 
> ID2 from the previous row I don’t select that row.
> 
>  
> 
> Thanks anyway,
> 
> Paul
> 
>  
> 
> From: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>> On Behalf Of Dan 
> Goldberg
> Sent: November 27, 2018 9:37 AM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - SQL Help - OT
> 
>  
> 
> You can do this to get the odd rowid values in rbase.
> 
>  
> 
> Select ROWID, PART_ID, ID1, ID2 from tablename where (MOD(ROWID,2)) = 1
> 
>  
> 
> Dan Goldberg
> 
>  
> 
>  
> 
>  
> 
> From: rbase-l@googlegroups.com  
> mailto:rbase-l@googlegroups.com>> On Behalf Of 
> p...@buckleyandassoc.com 
> Sent: Tuesday, November 27, 2018 6:23 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - SQL Help - OT
> 
>  
> 
> Good morning,
> 
>  
> 
> I need some help with a SQL select command, not specifically for R:BASE. See 
> my little table sample below. What I’d like to end up with after the SQL 
> select is the following rows:
> 
>  
> 
> Results of SQL Select/Query
> 
> ROWID PART_ID  ID1
>  ID2
> 
> 1  PV216365006R   -00105  
>  -00106
> 
> 3  PV216365006R   -00107  
>  -00108
> 
> 5  PV216365006R   -00109  
>  -00110
> 
> 7  PV216365006R   -00111  
>  -00112
> 
>  
> 
> Sample Table to Query
> 
> ROWID PART_ID  ID1
>  ID2
> 
> 1  PV216365006R   -00105  
>  -00106
> 
> 2  PV216365006R   -00106  
>  -00105
> 
> 3  PV216365006R   -00107  
>  -00108
> 
> 4  PV216365006R   -00108  
>  -00107
> 
> 5  PV216365006R   -00109  
>  -00110
> 
> 6  PV216365006R   -00110  
>  -00109
> 
> 7  PV216365006R   -00111  
>  -00112
> 
> 8  PV216365006R   -00112  
>  -00111
> 
>  
> 
> I know how I’d do this in a Declare statement in R:BASE but as I said, it has 
> to be done with a SQL select command.
> 
>  
> 
> Any blues clues would be greatly appreciated.
> 
>  
> 
> TIA,
> 
> Paul Buckley
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> 
> --- 
> You received this message because you are 

Re: [RBASE-L] - SQL Help - OT

[Albert Berry]

The attached RMD will create a database (double quotes) with the one table, load the data you supplied and run a query that returns your results. You can modify the query to suit your needs. Albert



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


QueryTest.RMD
Description: Binary data
On Nov 27, 2018, at 7:23 AM, p...@buckleyandassoc.com wrote:ROWID PART_ID  ID1 ID21  PV216365006R   -00105   -001062  PV216365006R   -00106   -001053  PV216365006R   -00107   -001084  PV216365006R   -00108   -001075  PV216365006R   -00109   -001106  PV216365006R   -00110   -001097  PV216365006R   -00111   -001128  PV216365006R   -00112   -00111



-- 
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] - Forms - Tables in Forms - Custom Table Relationships

[Albert Berry]

You are more than welcome. I have received so much help from others on this 
forum and its predecessors since 1984 I feel honour bound to return the favour. 
 
Albert 

> On Nov 26, 2018, at 3:19 PM, Myron Finegold  wrote:
> 
> Albert,
> I just finished recreating the form and all works fine.
> I added all the tables and the links first, then added the columns.
> Thanks for the help.
> Myron
>  
> From: rbase-l@googlegroups.com  On Behalf Of Albert 
> Berry
> Sent: November 26, 2018 2:57 PM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
>  
> Myron, check the one to many, many to many etc. settings. Razzak has an 
> article on these type of things on base.com <http://base.com/> here:
>  
> http://www.razzak.com/fte/pdf/CustomTableRelationships.pdf 
> <http://www.razzak.com/fte/pdf/CustomTableRelationships.pdf>
>  
> Albert
> 
> 
>> On Nov 26, 2018, at 9:31 AM, Myron Finegold > <mailto:myron.fineg...@gmail.com>> wrote:
>>  
>> Albert - thanks for the response.
>> The database has had its integrity checked and has been reloaded. And, all 
>> of the common columns have been indexed accordingly.
>> 
>> Myron
>> 
>> 
>> -----Original Message-
>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>> mailto:rbase-l@googlegroups.com>> On Behalf Of 
>> Albert Berry
>> Sent: November 26, 2018 9:05 AM
>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>> Subject: Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
>> 
>> Thoughts:
>> 1. Reload the database
>> 2. Is the common column indexed in all the tables?
>> 
>> Albert 
>> 
>> 
>>> On Nov 26, 2018, at 8:21 AM, Myron Finegold >> <mailto:myron.fineg...@gmail.com>> wrote:
>>> 
>>> The conversation.  Design a form > from the menu bar on the top of the 
>>> screen choose  add a master table (or one has already been added).
>>> As you progress in the form development you want to add a second table 
>>> (or in my case a 3rd and 4th) that has a common column. Easy, look at 
>>>  and add the table you want. Then highlight the table 
>>> (right
>>> box) and click on (settings) on the bottom. A dialog box opens and now 
>>> click on .  The issue: the functionality 
>>> of using the  stops functioning, meaning 
>>> you can't link columns. The question: can a form become corrupt where 
>>> the functionality of  stops functioning. 
>>> I've done the form twice with the same results.  Thanks for any 
>>> advice.  Myron
>>> 
>>> 
>>> --
>>> 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>.
>>> For more options, visit https://groups.google.com/d/optout 
>>> <https://groups.google.com/d/optout>.
>> 
>> --
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
> 
>  
> -- 
> For group guidelines,

Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships

[Albert Berry]

Myron, check the one to many, many to many etc. settings. Razzak has an article 
on these type of things on base.com here:

http://www.razzak.com/fte/pdf/CustomTableRelationships.pdf 
<http://www.razzak.com/fte/pdf/CustomTableRelationships.pdf>

Albert

> On Nov 26, 2018, at 9:31 AM, Myron Finegold  wrote:
> 
> Albert - thanks for the response.
> The database has had its integrity checked and has been reloaded. And, all of 
> the common columns have been indexed accordingly.
> 
> Myron
> 
> 
> -Original Message-
> From: rbase-l@googlegroups.com  On Behalf Of Albert 
> Berry
> Sent: November 26, 2018 9:05 AM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
> 
> Thoughts:
> 1. Reload the database
> 2. Is the common column indexed in all the tables?
> 
> Albert 
> 
>> On Nov 26, 2018, at 8:21 AM, Myron Finegold  wrote:
>> 
>> The conversation.  Design a form > from the menu bar on the top of the 
>> screen choose  add a master table (or one has already been added).
>> As you progress in the form development you want to add a second table 
>> (or in my case a 3rd and 4th) that has a common column. Easy, look at 
>>  and add the table you want. Then highlight the table 
>> (right
>> box) and click on (settings) on the bottom. A dialog box opens and now 
>> click on .  The issue: the functionality 
>> of using the  stops functioning, meaning 
>> you can't link columns. The question: can a form become corrupt where 
>> the functionality of  stops functioning. 
>> I've done the form twice with the same results.  Thanks for any 
>> advice.  Myron
>> 
>> 
>> --
>> 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.

-- 
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] - Forms - Tables in Forms - Custom Table Relationships

[Albert Berry]

Thoughts:
1. Reload the database
2. Is the common column indexed in all the tables?

Albert 

> On Nov 26, 2018, at 8:21 AM, Myron Finegold  wrote:
> 
> The conversation.  Design a form > from the menu bar on the top of the
> screen choose  add a master table (or one has already been added).
> As you progress in the form development you want to add a second table (or
> in my case a 3rd and 4th) that has a common column. Easy, look at
>  and add the table you want. Then highlight the table (right
> box) and click on (settings) on the bottom. A dialog box opens and now click
> on .  The issue: the functionality of using the
>  stops functioning, meaning you can't link
> columns. The question: can a form become corrupt where the functionality of
>  stops functioning. I've done the form twice
> with the same results.  Thanks for any advice.  Myron
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Product Deactiviation: Nuance

[Albert Berry]

Contact John III - he can make it work for you. 

Albert

> On Nov 24, 2018, at 3:38 PM, Bruce A. Chitiea  wrote:
> 
> All:
> 
> As the last gasp before deactivating a product license, we are informed:
> 
> "Product deactivation should ONLY be performed if you wish to permanently 
> remove the software, and it will not be re-installed on this specific 
> computer.
> 
> "Please be aware that you will no longer be able to run this software on this 
> computer."
> 
> Fair enough. A question, though. 
> 
> I'm performing a full system wipe, OS reset, and install everything from 
> scratch on a pristine hard drive. So after the reset, there WILL be an 
> attempt at reinitialization.
> 
> Does the activation validation process look for a marker in the computer 
> hardware - which suggests re-licensing activity, or does it key off a marker 
> in the (soon to vanish) prior installation of the OS, in which case no 
> worries?
> 
> Thanks much,
> 
> Bruce Chitiea
> SafeSectors, Inc.
> 909.238.9012  cell
> 
> -- 
> 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.

Re: [RBASE-L] - changing a column's length?

[Albert Berry]

Using your column name 
LIST COLUMN ComputedColumnName
You just might have it in a reporting table
If that is so, then alter table xxx DROP ComputtedColumnName until you have one 
instance, then ALTER TABLE yyy ALTER COLUMN ….
ALTER TABLE xxx ADD ComputedColumnName …

Albert

> On Nov 17, 2018, at 8:55 PM, Buddy Walker  wrote:
> 
> Lin
>Make sure the length of the computed column is at least the same as the 
> total length of the two columns. Also make sure the concatenated column name 
> isn’t in any other table if so the length has to be the same. 
> 
> Buddy 
> 
> Sent from my iPhone
> 
> On Nov 17, 2018, at 8:43 PM, Lin MacDonald  > wrote:
> 
>> Hello,
>> 
>> I had to change a column's length to accommodate a very long last name.  The 
>> table contained a computed column that concatenated the first and last name. 
>>  To change the last name's length, I had to delete the expression on the 
>> column that did the concatenation.  Now, I can't put it back.  When I do, 
>> the table refuses to save.  Am I missing something?
>> 
>> thanks!
>> 
>> Lin
>> 
>> -- 
>> 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.

Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

[Albert Berry]

Aren’t they just great? The slightest problem, no matter how insignificant, is 
fixed as if the whole program was failing. 
Albert

> On Nov 15, 2018, at 11:36 AM, Claudine Robbins  wrote:
> 
> This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!
>  
> Claudine
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Claudine Robbins
> Sent: Friday, October 26, 2018 3:08 PM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - LISTOF question 10.0.4.10913
>  
> Hello all,
>  
> My experience with LISTOF is that it automatically puts quotes around fields 
> that contain commas but I’m running into a situation where it does not.
>  
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value. 
>  
> However, it correctly returns 3 for the ITEMCNT variable.
>  
> What am I overlooking?
>  
> R>sho v vValueList
> YELLOW JACKET CONSTRUCTION, 
> INC.,YELLOW JACKET 
> OILFIELD,YELLOWHOUSE 
> MACHINERY CO.
>  
> 
> -- 
> 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.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Albert Berry]

Have you tried another set of data with an embedded comma? If you hit the same 
problem again, it might be something for RDCC. They are pretty good at fixing 
inadvertent boo-boos. My latest was RSTYLE telling me the NO_FOCUS option on 
PAUSE was not a legal command. They fixed it and told me so Wednesday. I sent 
it in late Friday (when everyone was in Vegas!). 

Albert

> On Oct 26, 2018, at 2:52 PM, Albert Berry  wrote:
> 
> Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
> make any difference, but it’s a cheap try. 
> 
> 
> 
>> On Oct 26, 2018, at 2:07 PM, Claudine Robbins > <mailto:crobb...@iexgroup.com>> wrote:
>> 
>> Hello all,
>>  
>> My experience with LISTOF is that it automatically puts quotes around fields 
>> that contain commas but I’m running into a situation where it does not.
>>  
>> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
>> space plus INC. as a separate value. 
>>  
>> However, it correctly returns 3 for the ITEMCNT variable.
>>  
>> What am I overlooking?
>>  
>> R>sho v vValueList
>> YELLOW JACKET CONSTRUCTION, 
>> INC.,YELLOW JACKET 
>> OILFIELD,YELLOWHOUSE 
>> MACHINERY CO.
>>  
>> 
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <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] - LISTOF question 10.0.4.10913

[Albert Berry]

79/18 is the 32 bit version. Your dat file is probably dated back in RBG95 
days, before you went RBG95_64 and/or RBGXE
Albert


> On Oct 26, 2018, at 3:30 PM, Claudine Robbins  wrote:
> 
> Albert,
>  
> Setting namewidth to 40 didn’t work but it brings an interesting question 
> I’ve never asked myself before because I “assumed” that all settings could be 
> reset in the .DAT file and namewidth is not one I have an entry for.  So I 
> don’t know why 79/18 is my default setting.  Looks like I seriously need to 
> review my .DAT file.
>  
> Corrections/comments welcome.
>  
> TIA,
>  
> Claudine
>  
>  
> 
>  
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf 
> Of Albert Berry
> Sent: Friday, October 26, 2018 3:53 PM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913
>  
> Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
> make any difference, but it’s a cheap try. 
>  
> 
> 
> 
> On Oct 26, 2018, at 2:07 PM, Claudine Robbins  <mailto:crobb...@iexgroup.com>> wrote:
>  
> Hello all,
>  
> My experience with LISTOF is that it automatically puts quotes around fields 
> that contain commas but I’m running into a situation where it does not.
>  
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value. 
>  
> However, it correctly returns 3 for the ITEMCNT variable.
>  
> What am I overlooking?
>  
> R>sho v vValueList
> YELLOW JACKET CONSTRUCTION, 
> INC.,YELLOW JACKET 
> OILFIELD,YELLOWHOUSE 
> MACHINERY CO.
>  
> 
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - LISTOF question 10.0.4.10913

[Albert Berry]

Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
make any difference, but it’s a cheap try. 



> On Oct 26, 2018, at 2:07 PM, Claudine Robbins  wrote:
> 
> Hello all,
>  
> My experience with LISTOF is that it automatically puts quotes around fields 
> that contain commas but I’m running into a situation where it does not.
>  
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value. 
>  
> However, it correctly returns 3 for the ITEMCNT variable.
>  
> What am I overlooking?
>  
> R>sho v vValueList
> YELLOW JACKET CONSTRUCTION, 
> INC.,YELLOW JACKET 
> OILFIELD,YELLOWHOUSE 
> MACHINERY CO.
>  
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Form Timer

[Albert Berry]

I had a look at the Help for this, and that was no help at all for your 
question. R:Docs X wasn’t any more help either. 

Just bumping the thread.

Albert


> On Oct 23, 2018, at 3:51 PM, Doug Hamilton  wrote:
> 
> When enabling a form timer after
> PROPERTY RBASE_FORM TIMERENABLED 'FALSE',
> does the timer reset to its initial interval or continue from the elapsed 
> time when it was disabled?
> (Hopefully the latter)
> 
> Also, if the timer runs an EEP, does the timer restart as soon as its 
> interval has expired or
> does it start when the associated custom EEP is finished?
> 
> TIA,
> Doug
> RB X for now, upping to X.5 soon.
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> -- 
> 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] - Value change in a form

[Albert Berry]

I need to know if a specific value (a DBEDIT: Date) has been changed by the 
user. 
Is the old school, get a before value, compare with after value still the best 
way to go?
I could create an entry eep to save the value on entry into the row, and then 
get the after value on exit using RBTI_FORM variables, but is there a better 
way?

Albert

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

[Albert Berry]

A client has problems with “bad” dates in the database — dates in the future. 
In order to rectify the future dates already in the DB, before adding field 
level controls, I’m just finishing up a find routine. 

Anyone interested in the code, just drop me a PM. 

The routine is not DB specific.
It checks every date column in the DB against .#DATE
Finds the rows immediately before and after the offending row(s)
Assembles the data in a table
BROWSEs the table to display the data

BROWSER VIEW:
  

-- 
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] - Enhanced db grid - refresh filter

[Albert Berry]

The column number is zero based. 
It is the column in the grid
3 would be the 4th column from the left in the grid.
I think the “REFRESH” is not needed, and might cancel the FILTER statement. 
(Wild Guess)

Albert

> On Oct 3, 2018, at 7:32 AM, Doug Hamilton  wrote:
> 
> Need help please.
> I can't get FILTERS to work.
> Is the nnn column number the number of the column in the table or on the grid?
> Is the column number zero based?
> I've tried all permutations of the above, with and without quotes around the 
> FILTERS [NNN]->VALUE.
> 
> I 'm using a new form with only an enhanced DB grid, comp ID cidSHPIGrid 
> (SHPI isn't a typo) and a pusbutton with this code:
> 
> SET MESSAGE ON
> SET ERROR MESSAGE ON
> SET TRACE ON
> 
> PROPERTY cidSHPIGrid FILTERS[3]->VALUE 'UPAC'
> 
> PROPERTY cidSHPIGrid REFRESH 'TRUE'
> 
> SET TRACE OFF
> SET MESSAGE OFF
> SET ERROR MESSAGE OFF
> RETURN
> 
> Running the code produces no change in the grid, no messages.
> Are there any DB Grid Options that should or should not be checked?
> Any other settings required or shouldn't be selected?
> And, yes, UPAC is a existing text value in the column.
> RB XE, 10913.
> 
> TIA
> DOUG
> 
> On 10/2/2018 10:31 AM, Albert Berry wrote:
>> I just had a look in R:Docs X
>> 
>> PROPERTY  'FILTERS[NNN]->VALUE' ‘Filter_Vaue'
>> 
>> Changes the filter value on the Enhanced DB Grid column, where nnn is the 
>> column number.
>> 
>> Example:
>> 
>>PROPERTY EnhDBGrid FILTERS[2]->VALUE 'CA'
>>PROPERTY EnhDBGrid FILTERS[2]->VALUE ''
>> 
>> Albert
>> 
>> 
>>> On Oct 1, 2018, at 3:30 PM, Dan Goldberg >> <mailto:d...@lancecamper.com>> wrote:
>>> 
>>> Thx but I just tried it and no change. 
>>>  
>>> Dan Goldberg
>>>  
>>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>>> mailto:rbase-l@googlegroups.com>> On Behalf Of 
>>> Albert Berry
>>> Sent: Monday, October 1, 2018 2:25 PM
>>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>>> Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter
>>>  
>>> Have you tried POSTing the table before REFRESH?
>>>  
>>> 
>>> 
>>> On Oct 1, 2018, at 3:13 PM, Dan Goldberg >> <mailto:d...@lancecamper.com>> wrote:
>>>  
>>> I have an enhanced db grid with a filter turned on. 
>>>  
>>> 
>>>  
>>> If I change the value to the row and save it, I want the filter to add it 
>>> to the list.
>>>  
>>> 
>>>  
>>> So if I change the value of “App Status in a row to “X” and save it, the 
>>> drop down should now include “X” but doesn’t.
>>>  
>>> I have tried table refresh and it doesn’t show. Does anyone know how to 
>>> recalculate the filter?
>>>  
>>> TIA
>>>  
>>> Dan Goldberg 
>>>  
>>>  
>>> -- 
>>> 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>.
>>> For more options, visit https://groups.google.com/d/optout 
>>> <https://groups.google.com/d/optout>.
>>>  
>>> -- 
>>> 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>.
>>> For more options, visit https://groups.google.com/d/optout 
>>> <https://groups.google.com/d/optout>.
>>> 
>>> -- 
>>> 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 

Re: [RBASE-L] - Enhanced db grid - refresh filter

[Albert Berry]

If you are using the built-in popup in the form, perhaps one of the combo boxes 
would work better. It will depend entirely on your specific application, 
though. 
Albert


> On Oct 2, 2018, at 11:02 AM, Dan Goldberg  wrote:
> 
> Thx Albert. That will filter but I need to refresh the popup filter.
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com  On Behalf Of Albert 
> Berry
> Sent: Tuesday, October 2, 2018 8:31 AM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter
>  
> I just had a look in R:Docs X
>  
> PROPERTY  'FILTERS[NNN]->VALUE' ‘Filter_Vaue'
>  
> Changes the filter value on the Enhanced DB Grid column, where nnn is the 
> column number.
>  
> Example:
>  
>PROPERTY EnhDBGrid FILTERS[2]->VALUE 'CA'
>PROPERTY EnhDBGrid FILTERS[2]->VALUE ''
>  
> Albert
>  
> 
> 
> On Oct 1, 2018, at 3:30 PM, Dan Goldberg  <mailto:d...@lancecamper.com>> wrote:
>  
> Thx but I just tried it and no change. 
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> mailto:rbase-l@googlegroups.com>> On Behalf Of 
> Albert Berry
> Sent: Monday, October 1, 2018 2:25 PM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter
>  
> Have you tried POSTing the table before REFRESH?
>  
> 
> 
> 
> On Oct 1, 2018, at 3:13 PM, Dan Goldberg  <mailto:d...@lancecamper.com>> wrote:
>  
> I have an enhanced db grid with a filter turned on. 
>  
> 
>  
> If I change the value to the row and save it, I want the filter to add it to 
> the list.
>  
> 
>  
> So if I change the value of “App Status in a row to “X” and save it, the drop 
> down should now include “X” but doesn’t.
>  
> I have tried table refresh and it doesn’t show. Does anyone know how to 
> recalculate the filter?
>  
> TIA
>  
> Dan Goldberg 
>  
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - Enhanced db grid - refresh filter

[Albert Berry]

I just had a look in R:Docs X

PROPERTY  'FILTERS[NNN]->VALUE' ‘Filter_Vaue'

Changes the filter value on the Enhanced DB Grid column, where nnn is the 
column number.

Example:

   PROPERTY EnhDBGrid FILTERS[2]->VALUE 'CA'
   PROPERTY EnhDBGrid FILTERS[2]->VALUE ''

Albert


> On Oct 1, 2018, at 3:30 PM, Dan Goldberg  wrote:
> 
> Thx but I just tried it and no change. 
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com  On Behalf Of Albert 
> Berry
> Sent: Monday, October 1, 2018 2:25 PM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter
>  
> Have you tried POSTing the table before REFRESH?
>  
> 
> 
> On Oct 1, 2018, at 3:13 PM, Dan Goldberg  <mailto:d...@lancecamper.com>> wrote:
>  
> I have an enhanced db grid with a filter turned on. 
>  
> 
>  
> If I change the value to the row and save it, I want the filter to add it to 
> the list.
>  
> 
>  
> So if I change the value of “App Status in a row to “X” and save it, the drop 
> down should now include “X” but doesn’t.
>  
> I have tried table refresh and it doesn’t show. Does anyone know how to 
> recalculate the filter?
>  
> TIA
>  
> Dan Goldberg 
>  
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - Enhanced db grid - refresh filter

[Albert Berry]

Have you tried POSTing the table before REFRESH?


> On Oct 1, 2018, at 3:13 PM, Dan Goldberg  wrote:
> 
> I have an enhanced db grid with a filter turned on. 
>  
> 
>  
> If I change the value to the row and save it, I want the filter to add it to 
> the list.
>  
> 
>  
> So if I change the value of “App Status in a row to “X” and save it, the drop 
> down should now include “X” but doesn’t.
>  
> I have tried table refresh and it doesn’t show. Does anyone know how to 
> recalculate the filter?
>  
> 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 
> .
> 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] - Rotate a JPG?

[Albert Berry]

I was just supposing that you might direct draw the PDF without converting it 
first. 

I don’t know if it would work, but if it did …

Albert

> On Sep 28, 2018, at 9:54 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> As a routine, I always check Direct Draw.  I'm not sure why, but I always 
> have.  Can't say I've noticed what the difference might have been.
> 
> Karen
> 
> 
> 
> -----Original Message-
> From: Albert Berry 
> To: rbase-l@googlegroups.com 
> Sent: Fri, Sep 28, 2018 10:45 am
> Subject: Re: [RBASE-L] - Rotate a JPG?
> 
> 
> 
>> On Sep 28, 2018, at 9:40 AM, 'Karen Tellef' via RBASE-L 
>> mailto:rbase-l@googlegroups.com>> wrote:
>> 
>> I'm not sure how you did yours, but I brought up my JPG in an editor and 
>> resaved it as a PNG and it retains the same orientation.   Saving as a BMP 
>> looks terrible, kept the same orientation.  No there's no way to display a 
>> PDF on a report.
>> 
>> At the moment, they are fine with keeping the JPG oriented the normal way, 
>> which results in a smaller picture on the report.  If it was me, I'd want it 
>> rotated.  But for the ease of it, I hope they continue to be okay with it.  
>> My programming buddy said he could do the rotation for me if needed.
>> 
>> Karen
>> 
>> 
>> 
>> -Original Message-
>> From: Albert Berry mailto:alb...@albertberry.com>>
>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>> mailto:rbase-l@googlegroups.com>>
>> Sent: Fri, Sep 28, 2018 10:33 am
>> Subject: Re: [RBASE-L] - Rotate a JPG?
>> 
>> I had similar problem here with a logo about a month ago. I copied the JPG 
>> to PNG and it works A-OK. Saving the JPG to BMP turned it upside down, which 
>> doesn’t look all that great. Much more flexibility with PNG in reports. 
>> Seeing as yours are PDF they should convert easily as well. I wonder if you 
>> can just place the PDF on the report?
>> 
>> Albert
>> 
>>> On Sep 26, 2018, at 9:50 AM, 'Karen Tellef' via RBASE-L 
>>> mailto:rbase-l@googlegroups.com>> wrote:
>>> 
>>> I probably know the answer to this, but what the heck
>>> 
>>> I got my buddy to write an easy routine to convert a PDF to a JPG via 
>>> command line.   The PDFs are from their scanner, of engineering prints.  
>>> Those PDFs are oriented landscape, the JPGs produced are also landscape 
>>> (longer than it is tall). 
>>> 
>>> I need to print these JPGs on the reverse side of a portrait-mode RBase 
>>> report.   If I locate a regular Image control, it goes across and the image 
>>> isn't very big.  The image would be bigger if I could rotate it sideways on 
>>> the page.  I don't see an option to do that.  I've asked my friend if he 
>>> can do the rotating in his conversion, but wondering if I'm missing the 
>>> ability to do this from within the RBase report.
>>> 
>>> Thanks!
>>> 
>>> 
>>> Karen
>>> 
>>> 
>>> 
>>> -- 
>>> 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>.
>>> For more options, visit https://groups.google.com/d/optout 
>>> <https://groups.google.com/d/optout>.
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
>> 
>> -- 
>> 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 
>> "

Re: [RBASE-L] - Rotate a JPG?

[Albert Berry]

I had similar problem here with a logo about a month ago. I copied the JPG to 
PNG and it works A-OK. Saving the JPG to BMP turned it upside down, which 
doesn’t look all that great. Much more flexibility with PNG in reports. Seeing 
as yours are PDF they should convert easily as well. I wonder if you can just 
place the PDF on the report?

Albert

> On Sep 26, 2018, at 9:50 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> I probably know the answer to this, but what the heck
> 
> I got my buddy to write an easy routine to convert a PDF to a JPG via command 
> line.   The PDFs are from their scanner, of engineering prints.  Those PDFs 
> are oriented landscape, the JPGs produced are also landscape (longer than it 
> is tall). 
> 
> I need to print these JPGs on the reverse side of a portrait-mode RBase 
> report.   If I locate a regular Image control, it goes across and the image 
> isn't very big.  The image would be bigger if I could rotate it sideways on 
> the page.  I don't see an option to do that.  I've asked my friend if he can 
> do the rotating in his conversion, but wondering if I'm missing the ability 
> to do this from within the RBase report.
> 
> Thanks!
> 
> 
> Karen
> 
> 
> 
> -- 
> 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] - R:BASE EDITOR

[Albert Berry]

How can I stop the R:Base editor from saving *.PRO files as *.RMD as well and 
similar problems? I must be blind, but I cannot find out how to set the editor 
to simply save a file with only the extension I want on the end. 

-- 
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] - Released: R:BASE X/XE (Version 10) - Add-on Products

[Albert Berry]

Not to mention the fact that the updates just do their thing with no fuss, no 
muss, and quite quickly. 
Albert

> On Sep 12, 2018, at 7:59 AM, Bruce A. Chitiea  wrote:
> 
> Service like this puts the entire global software industry to shame. Bottle 
> and sell it to the others, and make beellions.
> 
> Bruce Chitiea
> SafeSectors, Inc.
> 909.238.9012 m
> 
> -- Original Message --
> Sent: 9/11/2018 9:05:00 PM
> Subject: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products
> From: "A. Razzak Memon" mailto:raz...@rbase.com>>
> To: rbase-l@googlegroups.com 
> Cc:
> 
> Wednesday, September 12, 2018
>  
> To All Users of R:BASE X and R:BASE X Enterprise Add-on Products:
>  
> Updates are now available for the following add-on products for R:BASE X
> and R:BASE X Enterprise (Version 10):
>  
> https://www.rbaseupdates.com 
>  
> Build: 10.0.4.10912 - Update 4
>  
> . Oterro X and Oterro X Enterprise
> . R:Mail X
> . R:PDFWorks X
> . R:Docs X
>  
> This is a FREE update for all registered users who are within one year of
> their purchase or are active R:SAP subscribers for their licensed product.
>  
> Very Best R:egards,
>  
> Razzak.
>  
> https://www.rbase.com 
> www.facebook.com/rbase 
> -- 36 years of continuous innovation!
> 20 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
> --
>  
> -- 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.

Re: [RBASE-L] - Positioning of popup menus

[Albert Berry]

1. POPUP Menus. I assume you are using CHOOSE within an edit field. I have not 
done that for donkey’s years. Use a DB Combo Lookup instead, unless you are 
running DOS, of course.\. Combo Lookups “hang” from the field it belongs to. 
This is a snapshot of a drop down in the Contact form of my Parish Records 
database. In this case the Roman Catholic ID is 1. On an empty field it 
immediately looks like below. I always set WALKMENU on, so the user could press 
the first letter of the name and that would highlight. Down one for Greek 
Orthodox after presiding “G”, for example. In my case, I use the name for the 
popup order, but could just as easily use the ID.
 


Albert


> On Aug 31, 2018, at 11:00 AM, Stuart Hellman  wrote:
> 
> Greetings all,
>  
> When using a popup menu in RBase X, is there a way you can set the 
> coordinates as to where the menu will display?  The list of choices is 
> displaying right over the field I’m trying to populate. The popup menu shows 
> up right in the middle of the form. I’ve tried an ‘ugly’ solution of moving 
> the position of the form executing the popup off to the side, but there has 
> got to be a better solution.
>  
> When doing a CHOOSE command, there is an option to set the TOP & LEFT 
> coordinates. I was looking for a similar functionality for the popup menu.
>  
>  
> Along the same line, is there a way to highlight an selection on the popup 
> menu (again like the CHOOSE command)? This would be useful when setting 
> default selections or when user goes back to edit a field, seeing what has 
> been selected. 
>  
>  
> Thank you in advance.
>  
>  
> Stu Hellman
> 
> -- 
> 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.

Re: [RBASE-L] - Thanks to the DreamTeam

[Albert Berry]

I have found them absolutely amazing myself. We are extremely lucky to have 
them behind us — although they are usually ahead of us. 


> On Aug 13, 2018, at 12:54 PM,  
>  wrote:
> 
> Good afternoon,
> 
> I wanted to take the time to thank the DreamTeam on this list. I submitted an 
> issue late last week, didn't even want to call it a bug until they had a 
> chance to look it over. Today they contacted me with the fixed version of 
> R:BASE and a couple of changes required in my code because of a new data type 
> they created.
> 
> There is no place on the planet to get response and service like this.
> 
> My heartfelt thanks the DreamTeam and Razzak for putting them together and 
> making us look good. I can't wait to see everyone in Las Vegas.
> 
> Thanks,
> Paul Buckley
> 
> -- 
> 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.

Re: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options

[Albert Berry]

If we thanked the R:Dream Team for every enhancement, the postings would be 10 
X what they are on here. 

Albert the appreciative.

> On Aug 8, 2018, at 10:41 AM, A. Razzak Memon  wrote:
> 
> 
> You should thank the resilient and talented R:Dream Team to implement such a
> cool and useful tool based on a request from one of our corporate customers.
> 
> You all are simply the beneficiaries of such vision and dedication.
> 
> Enjoy!
> 
> Razzak
> 
> 
> At 11:18 AM 8/8/2018, karentellef via RBASE-L wrote:
> 
>> I can sure see using the "whole word" search!
>> 
>> But being me, I always test to the nth degree, and I am thrilled to
>> announce that it works perfectly, ignoring punctuation.
>> 
>> For example, it found the whole word even if there was parenthesis
>> or commas around it.  It located the word "BLNo" in these
>> 2 examples I typed into a custom eep:
>> 
>> CREATE TEMP TABLE tmpBL (BLNo Int ..)
>> SELECT blno, bdate INTO ..
>> 
>> Good job!
>> 
>> Karen
>> 
>> -Original Message-
>> From: A. Razzak Memon 
>> To: rbase-l 
>> Sent: Wed, Aug 8, 2018 7:08 am
>> Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word 
>> Search Options
>> 
>> Wednesday, August 08, 2018
>> 
>> Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
>> Product...: R:BASE X and R:BASE X Enterprise (Version 10)
>> Build.: 10.0.4.10808 or higher
>> Sections..: Database Explorer, Forms, Reports, Labels, External Forms
>> Keywords..: Search, EEPs, Expressions, Control Properties, Case
>> Sensitive, Whole Word
>> 
>> Did you know the search capabilities for finding text in Custom EEPs,
>> Control Properties, and
>> Expressions has been enhanced to include "case sensitive" and "whole
>> word" criteria?
>> 
>> When searching for text in Custom EEPs, Control Properties, and
>> Expressions, for database Forms,
>> Reports, Labels, External Forms, and Applications, the "Find in"
>> dialog now includes the "Match
>> Case" and "Whole Word" options for more detailed searches.
>> 
>> Emacs!
>> 
>> 
>> http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png
>> 
>> The added capability adds to the existing search capabilities built
>> into R:BASE X/X Enterprise
>> (Version 10) for users to locate text within the database modules and
>> within external files,
>> including:
>> 
>> 01. Find in Database Explorer
>> 02. Find in Stored Procedures
>> 03. Find in Custom EEPs - [Ctrl] + F
>> . Find in Form Custom EEPs
>> . Find in Report Custom EEPs
>> . Find in Label Custom EEPs
>> . Find in Application Custom EEPs
>> . Find in External Form Custom EEPs
>> 04. Find in Control Properties - [Ctrl] + L
>> . Find in Form Control Properties
>> . Find in Report Control Properties
>> . Find in Label Control Properties
>> . Find External Form Control Properties
>> 05. Find in Expressions - [Ctrl] + [Shift] + F
>> . Find in Form Expressions
>> . Find in Report Expressions
>> . Find in Label Expressions
>> 06. Find in Files
>> 07. Find in R> Prompt Output
>> 
>> From The Edge: http://www.razzak.com/fte
>> Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10)
>> 
>> Very Best R:egards,
>> 
>> Razzak.
>> 
>> https://www.rbase.com
>> http://www.facebook.com/rbase/
> 
> 
> 
> 
> -- 
> 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.

Re: [RBASE-L] - using user IDs and passwords for RBASE

[Albert Berry]

Create a Windows file and add it to the line in the user icon that calls the 
database. It should read as Buddy suggested. In the icon command line below, I 
called it DBLogin.dat

IF CVAL (‘USER’) <> (‘NETUSER’) THEN
PAUSE 2 USING ‘Not Authorized’
EXIT
RETURN

The icon would read along these lines. The default is RBASE.DAT but I would not 
recommend that, because that would give you indigestion every time you tried to 
log into the database.
C:\RBTI\RBGXE\RBGXE.exe DBLogin.dat

As Razzak would say “That’s all there is to it”

Albert


> On Aug 4, 2018, at 9:16 AM, Jim Belisle  wrote:
> 
> Buddy,
>  
> Thanks for the response.
> You are talking to someone who is very ignorant of how to even start down 
> this road.
>  
> At the present the DB is setup without IDs (USER is NONE) I need to know how 
> to get that setup in the first place.
> The code set var vu = (CVAL('USER')) gives my NONE as an answer.
>  
> So I will need to start from the beginning.
> We are talking about an application in which 12 to 15 users will be accessing 
> the DB.
> I do not know the passwords for the users.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> Buddy Walker
> Sent: Saturday, August 4, 2018 10:02 AM
> To: rbase-l@googlegroups.com
> Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE
>  
> Jim
>   Use the CVAL(‘USER’) and CVAL(‘NETUSER’)
>  
>   If CVAL(‘USER’) <> CVAL(‘NETUSER’) THEN
>PAUSE 2 USI ‘Not Authorized’ 
>EXIT
>   ENDIF
>
>  Just make sure the CFG name matches the Network User Name.  This way you 
> won’t have to worry about R:Base password Windows should handle everything.
>  
> Buddy
>  
>  
> From: rbase-l@googlegroups.com  On Behalf Of Jim 
> Belisle
> Sent: Saturday, August 4, 2018 9:43 AM
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - using user IDs and passwords for RBASE
>  
> We are needing to change our RBASE application so as to require user IDS and 
> passwords. Here is what we want to do.
> We want the computer login USER and password to be used as the login for 
> RBASE.
> In other words, I want this to be automatic so the user does not need to fill 
> in their user and password for each session of RBASE.
> When they log into the computer that information would go into variables and 
> RBASE would see it in either the CFG or DAT file.
> To possibly complicate matters, out IT has instituted a mandatory password 
> change within a certain time periods (ongoing into the future).
> Of course the code would have to take password changes into consideration.
> I noticed in the command pdf there is a WINAUTH command that looks promising, 
> however this is all new to me.  
>  
> I have an idea of what the code would have to do but have never really worked 
> with meshing what Windows “sees” with RBASE.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> -- 
> 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.

Re: [RBASE-L] - Blank date value

[Albert Berry]

A different resource than a printed book, but one I find indispensable, is an 
R:Docs subscription. A bit more than a book, but it’s right there when you need 
it and you can cut and paste the code running it side by side with R:Base. The 
on line resources listed at the bottom of the post here, in particular Razzak/s 
FTE series is invaluable as well. 

Albert 


> On May 27, 2018, at 3:18 AM, Cathy Grimes  wrote:
> 
> Please add me to where I can buy an R:Base book newer than my R:Base 4.0 and 
> 4.5 manuals.  I have R:Base Extreme 9.5 (32) and the changes are too much to 
> make those manuals helpful anymore.  I haven’t had much luck at all using the 
> software’s Help function, so this Forum has made my R:Base use so much easier 
> and better.  And having a “How-To” manual that works for my R:Base would be 
> wonderful!
>  
> Cathy
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Hannaway, Lance
> Sent: Saturday, May 26, 2018 11:45 AM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - Blank date value
>  
> Hi guys, what book is this, I am looking for a good SQL reference book since 
> all of my coding goes back to the Rbase for Dos days!
>  
>  
> Sent from my Verizon, Samsung Galaxy smartphone
>  
>  
>  Original message 
> From: Claudine Robbins > 
> Date: 5/25/18 4:06 PM (GMT-05:00) 
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - Blank date value 
>  
> CAUTION: This Email is sent from outside our organization. Please DO NOT 
> Click on any links or open any attachments unless you recognize the sender.
> Please forward any Suspicious Email "as an attachment" to mis...@bronxleb.org 
> 
>  
> 
> No problem Bill.  I still refer to your and David’s SQL book almost monthly. 
>  
> Claudine
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Bill Downall
> Sent: Friday, May 25, 2018 1:31 PM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - Blank date value
>  
> So sorry. I jumped in to the middle of the conversation, and missed the main 
> details.
> 
> 
> (sent from Moto Z)
>  
> On Fri, May 25, 2018, 8:34 AM karentellef via RBASE-L 
> > wrote:
>> Bill:  She's saying that NULL date values are displaying like that in a 
>> form.   
>>  
>> Claudine:  does the database see them as null?  If you did a select where 
>> datecol is null, do they show up?
>>  
>> Karen
>>  
>>  
>>  
>> -Original Message-
>> From: Bill Downall >
>> To: rbase-l >
>> Sent: Fri, May 25, 2018 7:19 am
>> Subject: Re: [RBASE-L] - Blank date value
>> 
>> Claudine, 
>>  
>> If you can write a WHERE clause that finds all the bad dates, you should be 
>> able to write an UPDATE that fixes them. 
>>  
>> Are all the wrong dates off by exactly a century? If not, you will have to 
>> make your WHERE clause more complicated, and do this more than once.
>>  
>> SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'
>>  
>> UPDATE tablename SET datecolumn = +
>>  (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
>> WHERE datecolumn <= '01/01/1900'
>>  
>> Bill
>>  
>> On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins > > wrote:
>> Hello all,
>>  
>> I’m on latest release.  Some null values in a date field on a form are 
>> coming up 12/30/99, fully extended to 12/30/1899!  There are no values in 
>> that field in the table and the field correctly takes whatever date is 
>> inserted and saves it to the table.
>>  
>> I switched from 2-digit year to 4-digit year a few months ago and wonder if 
>> that’s when this started.  I reloaded the database, ran it through R:Scope 
>> and all is sound.
>>  
>> Any ideas on how to fix this?
>>  
>> TIA,
>>  
>> Claudine
>> -- 
>> 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 
>> 

Re: [RBASE-L] - Announcement - R:BASE Technologies' 20th Anniversary Conference

[Albert Berry]

R:Base has come a long Long long way since 2.11 (R:Base for DOS). That’s when I 
started using it. I’m looking forward to the enhancements in X.5

Albert in the Rockies


> On May 16, 2018, at 2:57 PM, Claudine Robbins  wrote:
> 
> Wow!  20 years is a long time and worthy of celebration.
> 
> Claudine
> 
> -Original Message-
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of A. Razzak Memon
> Sent: Wednesday, May 16, 2018 2:00 PM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - Announcement - R:BASE Technologies' 20th Anniversary 
> Conference
> 
> Wednesday, May 16, 2018 (3:00 PM Eastern Time)
> 
> Dear R:BASE Community,
> 
> I am ecstatic to finally share this news!
> 
> For the 20th Anniversary of R:BASE Technologies, Inc., we are celebrating an 
> R:BASE Conference in October 2018 in Las Vegas, Nevada!
> 
> And, on Saturday, October, 20, 2018, we will be officially unveiling the 
> release of R:BASE X.5/X.5 Enterprise (Version 10.5)!
> 
> All are urged to "save the date" and join us in celebrating "the 20th on the 
> 20th!"
> 
> Festivities will be held for this landmark occasion at the remarkable South 
> Point Hotel Casino and Spa: https://southpointcasino.com
> 
> The growth we've experienced over the years is because of a superior 
> community of R:BASE users, who unwaveringly support us!
> 
> Please stay tuned for more details ...
> http://www.rbase.com/conference
> 
> We hope to see you all in Las Vegas!
> 
> Razzak.
> 
> A. Razzak Memon
> Founder, President & CEO
> R:BASE Technologies, Inc.
> http://www.rbase.com
> http://www.facebook.com/rbase
> 
> --
> 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.

Re: [RBASE-L] - RBase on Linux

[Albert Berry]

I am running R:Base on a MacBook Air using MacOS high Sierra with the help of 
Parallels (about $100) and an installation of Windows 7 Pro. ($300). Parallels 
is available for Liniux as well. 
Another developer put me on to Parallels. Ir runs Windows in a Windows all 
screen session (or a window) without rebooting back and forth. On the Mac, a 3 
finger swipe takes me to the full screen Windows and back. Data transfers 
between the two OS with no problems. 

Albert 

> On May 16, 2018, at 6:49 PM, karentellef via RBASE-L 
>  wrote:
> 
> I am posting for a friend who is not active on this list.
> 
> Has anyone here run RBase X/XE on a Linux server?  Specifically locating the 
> database there, perhaps also the RBase executables.  They are willing to pay 
> someone for their time if setting up such an arrangement is possible.   If 
> you like, you may contact me off-list to discuss specifics.
> 
> Thanks!!!(PS: might not be on the list much Thursday, so be patient if I 
> don't respond)
> 
> Karen
> 
> 
> -- 
> 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.

Re: [RBASE-L] - R:BASE Technologies, Inc. - Special Announcement

[Albert Berry]

I have TipoftheDayDigest_2017.pdf sitting on my desktop. 

Albert

> On May 15, 2018, at 3:45 PM, Claudine Robbins  wrote:
> 
> LOL Bill.  I know the “announcement” is for tomorrow…
>  
> I was asking a separate question about the TipoftheDayDigest, there was one 
> in 2016 and I was wondering if one was provided for 2017 or did I miss it?
>  
> Claudine
>  
> From: bdown...@downallconsulting.com  
> [mailto:bdown...@downallconsulting.com 
> ] On Behalf Of Bill Downall
> Sent: Tuesday, May 15, 2018 2:18 PM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - R:BASE Technologies, Inc. - Special Announcement
>  
> Claudine,
>  
> I know! Me too. But he said Wednesday, May 16 at 3:00 pm. And that hasn't 
> happened yet.
>  
> Bill
>  
> On Tue, May 15, 2018 at 3:15 PM, Claudine Robbins  > wrote:
> Like a kid waiting for Santa...  Did I miss it or was there no 
> TipoftheDayDigest_2017.pdf?
> 
> Claudine :-)
> 
> -Original Message-
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of A. Razzak Memon
> Sent: Saturday, May 12, 2018 12:24 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - R:BASE Technologies, Inc. - Special Announcement
> 
> Saturday, May 12, 2018
> 
> To R:BASE Community:
> 
> Stay tuned for a special announcement from R:BASE Technologies, Inc., 
> on Wednesday, May 16, 2018 at 3:00 PM (EST).
> 
> Very Best R:egards,
> 
> Razzak
> 
> A. Razzak Memon
> Founder, President & CEO
> R:BASE Technologies, Inc.
> http://www.rbase.com 
> http://www.facebook.com/rbase 
> 
> 
> 
> -- 
> 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 
> .
> 
> -- 
> 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.

Re: [RBASE-L] - Greetings from Sweden to the R:BASE Community

[Albert Berry]

There is so much more in X that I strongly suggest you get R:Docs. I use it 
constantly. It makes sorting out syntax so much easier. 

Albert

> On May 2, 2018, at 9:52 AM, Bo Franzén <bo.fran...@ekohist.su.se> wrote:
> 
> Than you, Albert. Well, I will soon order 5-seater or so of ... GX I guess. 
> Even easier and faster? OK, fine, to put it mildley! Feel a little spoilt I 
> must admit.
> ​Bo Franzén
> Från: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> för Albert Berry 
> <alb...@albertberry.com <mailto:alb...@albertberry.com>>
> Skickat: den 2 maj 2018 17:30
> Till: rbase-l@googlegroups.com
> Ämne: Re: [RBASE-L] - Greetings from Sweden to the R:BASE Community
>  
> Welcome back to the list, Bo. I’ve missed your insightful posts. I can 
> personally say the RBGX and RBGXE are fabulous and even easier and faster to 
> develop with than earlier versions. Razzak and his team at RBTI have done a 
> fabulous lot of work. 
> 
> Albert
> 
>> On May 2, 2018, at 3:41 AM, Bo Franzén <bo.fran...@ekohist.su.se 
>> <mailto:bo.fran...@ekohist.su.se>> wrote:
>> 
>> I’m a Swedish academic that off and on since 1990 have been using R:BASE in 
>> my research about the economy in the Middle Ages. In the beginning of 2017, 
>> I realised that my retirement from Stockholm University was approaching and 
>> that my work with relational databases perhaps was over. But then my former 
>> supervisor came back as a senior professor to my department. He suggested a 
>> project with four members about networks in Medieval Sweden and said that 
>> among other things my skills in SQL was needed. We got what we had applied 
>> for, including a PhD student, and I’ll start in January (10 % in three 
>> years). We received very good ratings from the contributors for the high 
>> level of expertise in digital aids – thank you R:BASE!
>>  
>> I’m surprised that not more history colleagues have learned how to handle 
>> relational databases since they often turn out to be extremely efficient 
>> (e.g. the SELECT command). PhD students and other professionals sometimes 
>> ask me about my databases. Then they get a copy exported in any format they 
>> wish for, so that they can be reused in other research projects. Of course, 
>> must I now get the latest version and try to attend a training seminar, if 
>> possible this fall. I really appreciate the work of Adrian in arranging 
>> seminars here in Europe.
>>  
>> Greetings from Sweden
>> Bo Franzén
>> Department of Economic History
>> Stockholm University​
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - Greetings from Sweden to the R:BASE Community

[Albert Berry]

Welcome back to the list, Bo. I’ve missed your insightful posts. I can 
personally say the RBGX and RBGXE are fabulous and even easier and faster to 
develop with than earlier versions. Razzak and his team at RBTI have done a 
fabulous lot of work. 

Albert

> On May 2, 2018, at 3:41 AM, Bo Franzén  wrote:
> 
> I’m a Swedish academic that off and on since 1990 have been using R:BASE in 
> my research about the economy in the Middle Ages. In the beginning of 2017, I 
> realised that my retirement from Stockholm University was approaching and 
> that my work with relational databases perhaps was over. But then my former 
> supervisor came back as a senior professor to my department. He suggested a 
> project with four members about networks in Medieval Sweden and said that 
> among other things my skills in SQL was needed. We got what we had applied 
> for, including a PhD student, and I’ll start in January (10 % in three 
> years). We received very good ratings from the contributors for the high 
> level of expertise in digital aids – thank you R:BASE!
>  
> I’m surprised that not more history colleagues have learned how to handle 
> relational databases since they often turn out to be extremely efficient 
> (e.g. the SELECT command). PhD students and other professionals sometimes ask 
> me about my databases. Then they get a copy exported in any format they wish 
> for, so that they can be reused in other research projects. Of course, must I 
> now get the latest version and try to attend a training seminar, if possible 
> this fall. I really appreciate the work of Adrian in arranging seminars here 
> in Europe.
>  
> Greetings from Sweden
> Bo Franzén
> Department of Economic History
> Stockholm University​
> 
> -- 
> 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.

Re: [RBASE-L] - Sorting Question in a Form

[Albert Berry]

Does the revised whatever have a revision date as well as a revision code? 
Albert

> On Apr 27, 2018, at 12:06 PM, Paul C. Buckley  
> wrote:
> 
> Good afternoon,
> 
> I'm using the latest version of R:BASE X Enterprise. I'm trying to sort in a 
> form where there is a revision column. When it's A-Z there's no problem but 
> when we get into double digits AA, AB etc. I'm trying to figure out how to 
> determine the current revision. For example, I have rev W, X, Y, AA & AB I 
> was hoping to be able to sort in a way that puts the newest, AB, either on 
> the top or bottom. If that's not possible, any suggestions on how to find the 
> "newest" revision?
> 
> Thanks,
> Paul Buckley
> 
> -- 
> 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.

Re: [RBASE-L] - IT update and problem

[Albert Berry]

I think the wonderful John Minyo is your goto person. The IT's server has lost 
the registration for R:Base. John can help you with this sort of nightmare in 
nothing flat. He’s done it multiple times for me in situations like this, 
including moving everything to my MacBook Air when my Windows laptop packed it 
in. Of course I was unable to deactivate the licenses on the laptop. Not a 
problem to them, although it was a problem to me.   

RBTI are the best

Albert

> On Apr 26, 2018, at 12:52 AM, Jim Belisle  wrote:
> 
> Last week the IT company we use for our servers and computer security did 
> updates and a server reboot. In fact they have done a number of reboots in 
> the last couple of weeks.
> After they did these on Friday of last week I was no longer able to have 
> direct access to the RBASE explorer and instead the activation box (see 
> below) comes up as if I never activated RBASE.
> My compiled applications are working but the DB itself is acting as if I 
> never activated RBASE.
> 
>  
> Now the IT people are claiming they need more information from me. My 
> question to the list is this:
> What other information can I give them? I am not an IT person and have no 
> idea where the license would be located other than I have been told it is in 
> the Windows registry.
> I know this is not a RBASE issue but I thought maybe some of you with IT 
> knowledge can help me.
>  
> I am in another country right now and am six hours ahead of Central Time so 
> it may take hours between my emails to you if you do respond.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> 
> -- 
> 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.

Re: [RBASE-L] - RBase 101

[Albert Berry]

That is interesting, indeed. 
I have no idea why the where clause in the second fails. 
I’m such a log of help!
Albert

> On Apr 21, 2018, at 12:45 PM, Claudine Robbins  wrote:
> 
> I’m stumped and probably because I fail to remember some basic rule in RBase.
>  
> Why does:
>  
> sel count(*) fro i_companies whe company_name is null
> count (*)  
>  -- 
>   2
>  
> But:
>  
> R>sel * fro i_companies whe company_name is null
>  No rows exist or satisfy the specified clause.  (2059)
>  
> Can someone set me straight?
>  
> TIA,
>  
> Claudine
> 
> -- 
> 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] - Pick Files in Order

[Albert Berry]

I had a need to choose backup files for a restore procedure, and found the 
users were unhappy with the latest being last in the list, so I created this 
little RMD file to solve the problem. 

Fell free to use / complain / throw brickbats / whatever.

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


ChooseBackupFile.RMD
Description: Binary data

Re: [RBASE-L] - 2 page report in Rbase X

[Albert Berry]

Are you filling a form?
Albert

> On Apr 17, 2018, at 10:24 PM, Kayza Kleinman <kklein...@jccgci.org> wrote:
> 
> Each row of data gets spread over 2 pages. Some items can be printed 
> directly, but they need to be in VERY specific spots. For other data fields, 
> I need to place a tick mark in a specific spot based on the value. So, 
> assuming coordinates x,y, for Field1= 1 x is at x,y; Field1 = 2, X is at x+2; 
> y etc. I’ve figured ot how to make that happen, although it’s a pain. What I 
> can’t figure out is if I can have both pages print as one report.
>  
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> www.jccgci.org <http://www.jccgci.org/>
> www.nphd.org <http://www.nphd.org/>
>  
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> Albert Berry
> Sent: Tuesday, April 17, 2018 3:43 AM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - 2 page report in Rbase X
>  
> Kayza, it would be helpful to have a more detailed description of the two 
> pages. Do you want specific data in specific locations on each page? Are all 
> the data elements in a single row in a table? etc. 
> Albert
> 
> 
> On Apr 16, 2018, at 11:27 PM, Kayza Kleinman <kklein...@jccgci.org 
> <mailto:kklein...@jccgci.org>> wrote:
>  
> Is there a way to print a report that takes up two pages per row? (I posted 
> about the precursor to this report 2 years ago, and I’m still saddled with 
> it.)
>  
> Currently, what I’m doing in ver 9.5 is
>  
> Declare cursor
> Fetch cursor
> While sqlcode <>100
>Print Page1
>Print Page2
>Fetch Cursor
> Endwhile
>  
> Is there a way to have a report that allows the data to be put on two pages? 
> If not, is there any way to output to PDF (or any other file format, for that 
> matter) with each “print” job appending to the existing file rather than 
> creating a new file for each page?
>  
> Thanks for any help you can give!
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> 3001 West 37th Street
> Brooklyn NY 11224
> 718 449-5000 x 2266
> fax 347-946-6390
> www.jccgci.org <http://www.jccgci.org/>
> www.nphd.org <http://www.nphd.org/>
>  
>  
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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.

[Albert Berry]

If a column name is computed, such as Total CURRENCY = (SalePrice*NumSold) you 
cannot put it in as plain CURRENCY. You have to carry the calculation with it. 

Albert

> On Apr 17, 2018, at 2:54 AM, Alastair Burr  wrote:
> 
> 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 
>>   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 
>>> .
>>> 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 
>> .
> 
> 
> -- 
> 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.

Re: [RBASE-L] - 2 page report in Rbase X

[Albert Berry]

Kayza, it would be helpful to have a more detailed description of the two 
pages. Do you want specific data in specific locations on each page? Are all 
the data elements in a single row in a table? etc. 
Albert

> On Apr 16, 2018, at 11:27 PM, Kayza Kleinman  wrote:
> 
> Is there a way to print a report that takes up two pages per row? (I posted 
> about the precursor to this report 2 years ago, and I’m still saddled with 
> it.)
>  
> Currently, what I’m doing in ver 9.5 is
>  
> Declare cursor
> Fetch cursor
> While sqlcode <>100
>Print Page1
>Print Page2
>Fetch Cursor
> Endwhile
>  
> Is there a way to have a report that allows the data to be put on two pages? 
> If not, is there any way to output to PDF (or any other file format, for that 
> matter) with each “print” job appending to the existing file rather than 
> creating a new file for each page?
>  
> Thanks for any help you can give!
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> 3001 West 37th Street
> Brooklyn NY 11224
> 718 449-5000 x 2266
> fax 347-946-6390
> www.jccgci.org 
> www.nphd.org 
>  
>  
> 
> -- 
> 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.

Re: [RBASE-L] - Date Chooser Dialog?

[Albert Berry]

Not in 9.5, but it is an option in X. It is really quite simple to make a 
variable form with the date popup. 
Albert

> On Apr 16, 2018, at 11:20 PM, Kayza Kleinman  wrote:
> 
> I often need to get dates from users before I run a report or form. Is there 
> a way to build a dialog that gives a date chooser similar to what you can do 
> in a form, without  having to create a form for it?
> 
> Thanks!
>  
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> 3001 West 37th Street
> Brooklyn NY 11224
> 718 449-5000 x 2266
> fax 347-946-6390
> www.jccgci.org 
> www.nphd.org 
>  
>  
> 
> -- 
> 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.

Re: [RBASE-L] - Re: SV: updating many columns in a table

[Albert Berry]

Further to John’s note, I suspect that your system, or the university’s system, 
has spam checking enabled. I had this happen on one account, and the problem 
was that the spam/spoof checker detected that you had sent yourself the 
message. The solution is to white list this site.

Albert 

> On Apr 5, 2018, at 7:50 AM, John Minyo II  wrote:
> 
> Hello Claes-Robert Julander,
> 
> The spoof warning in the message only appears in email messages that you 
> receive, after sending your message to the list. 
> 
> The warning does not appear in your original post to the list, so you are 
> considered a safe sender to the group.
> 
> If you wish to investigate why the warning is inserted in your received 
> message, please review the provided link in your message. 
> 
> Very best regards,
> 
> John Minyo II
> Customer Service
> R:BASE Technologies, Inc.
> 
> 
> At 02:50 AM 4/5/2018, Claes-Robert Julander wrote:
>> Hallo,
>> Apparently I was not considered as a safe sender to this group. Could the 
>> administrator please explain. I have been a customer of rbase for many 
>> years, I am a professor emeritus of the Stockholm School of Economics etc. 
>> Now I 
>> Wonder what the problem is.
>> Sincerely
>> Claes-Robert Julander 
>> Från: rbase-l@googlegroups.com  för Claes-Robert 
>> Julander 
>> Skickat: den 3 april 2018 12:25:38
>> Till: rbase-l@googlegroups.com
>> Ämne: [RBASE-L] - updating many columns in a table 
>>  
>> Den här avsändaren har underkänts i bedrägerikontrollen och kanske 
>> egentligen är någon annan. Läs mer om förfalskning 
>> 
>> Feedback  
>> Hallo,
>> I used  rbase since it was called Microrim,  but with long intervals between 
>> each usage occasion (all depending on what type of research I  was 
>> conducting). In my current research I work with several tables and use rbase 
>> for organizing my data and SPSS for statistical analysis. The tables are 
>> fairly large, one table has 39000 rows and 150 columns.  This table I have 
>> in SPSS and I export it to Rbase. (I use Rbase extreme). When doing this 
>> missing data in SPSS, a., become 0, and not null. So, I need to change all 
>> the zeroes to null for 150 variables. This can of course be done with the 
>> update command, but it becomes rather tedious to write this command for all 
>> 150 columns. Is there any possibility to write a shorter command that will 
>> change all the zeroes to null for all variable and rows? 
>> Looking forward to your thoughts on this,
>> Sincerely
>> Claes-Robert Julander
> 
> 
> -- 
> 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.

Re: [RBASE-L] - updating many columns in a table

[Albert Berry]

You may be able to avoid the update by 
SET ZERO OFF
Before loading the data. The ZERO setting tells R:Base to use 0 for NULL 
entries where appropriate. 

Albert

PS - I date back to v 2.11




> On Apr 3, 2018, at 4:25 AM, Claes-Robert Julander 
>  wrote:
> 
> Hallo,
> I used  rbase since it was called Microrim,  but with long intervals between 
> each usage occasion (all depending on what type of research I  was 
> conducting). In my current research I work with several tables and use rbase 
> for organizing my data and SPSS for statistical analysis. The tables are 
> fairly large, one table has 39000 rows and 150 columns.  This table I have in 
> SPSS and I export it to Rbase. (I use Rbase extreme). When doing this missing 
> data in SPSS, a., become 0, and not null. So, I need to change all the zeroes 
> to null for 150 variables. This can of course be done with the update 
> command, but it becomes rather tedious to write this command for all 150 
> columns. Is there any possibility to write a shorter command that will change 
> all the zeroes to null for all variable and rows? 
> Looking forward to your thoughts on this,
> Sincerely
> Claes-Robert Julander
> 
> -- 
> 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.

Re: [RBASE-L] - AW: CHAR €

[Albert Berry]

This works in RBEdit:

set vE text = (char(0128))
pause 2 using .vE
ret



> On Mar 19, 2018, at 7:13 AM, Clive  wrote:
> 
> 
>  
> Regards
>  
> Clive Williams
>  
> This e-mail message and accompanying data may contain information that is 
> confidential and subject to legal professional privilege. If you are not the 
> intended recipient you are notified that any use, dissemination, distribution 
> or copying of this message or data is prohibited. All content is to be 
> treated as confidential unless otherwise specified, and is not to be 
> forwarded to third parties without the prior permission of the author. If you 
> have received this e-mail message in error please delete it and notify the 
> sender.
>  
> Although this message has been checked for viruses, it is the responsibility 
> of the addressee to scan this message for viruses also.
> Neither Clive Williams nor CRW Services warrant that the information herein 
> is free from any virus, defect or error.
>  
> P PLEASE CONSIDER THE ENVIRONMENT BEFORE YOU PRINT THIS E-MAIL
>  
> From: rbase-l@googlegroups.com  On Behalf Of Armin 
> Thoma
> Sent: Tuesday, 20 March 2018 00:05
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - AW: CHAR €
>  
> That works in WORD, but in RBase Editor:  ¼
>  
> 
> Von: rbase-l@googlegroups.com  
> > im Auftrag von 
> Stephen Markson >
> Gesendet: Montag, 19. März 2018 13:57
> An: rbase-l@googlegroups.com 
> Betreff: [RBASE-L] - RE: CHAR €
>  
> Try alt-8364
>  
>  
> Regards,
>  
> Stephen Markson
> The Pharmacy Examining Board of Canada
> 416.979.2431 x251
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Armin Thoma
> Sent: March-19-18 7:59 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - CHAR €
>  
>  
> Hi
>  
> in RBase Editor I would like to get € by [alt gr] + [e],  but I get ÿ.
>  
> What's wrong with my settings?
>  
> Any idea?
>  
> Armin
>  
>  
> -- 
> 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 
> .
> 
> -- 
> 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.

Re: [RBASE-L] - WHERE Clause ?

[Albert Berry]

WHERE … AND LIMIT = 1

I think that will bring up only the first occurrence. The alternate would be

WHERE … AND COUNT = LAST

Albert

> On Mar 1, 2018, at 11:37 AM, Carpet Broker, Dick Fey  
> wrote:
> 
> I have a table that may have multiple lines from an order that are identical.
> I want to create a form with a where clause that will allow editing, but only 
>  one of each line that is unique.
> 
> 
> IE:
> Table holds:
> 
> 180500  Red
> 180500  Red
> 180500  Red
> 180500  Blue
> 180500  Blue
> 180500  Blue
> 
> My form using the where clause would only show:
> 
> 18500  Red
> 18500  Blue
> 
> Dick Fey
> Carpet Broker Inc
> 
> P: 913-894-9211
> F: 913-894-0138
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Test

[Albert Berry]

Normal here


> On Feb 23, 2018, at 8:57 PM, Claudine Robbins  wrote:
> 
> My messages are being flagged as coming from a spoofed address.
>  
> Claudine
> 
> -- 
> 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.

Re: [RBASE-L] - File location and path

[Albert Berry]

And another way: Put this in a text file called alb.rmd and run it. 

———
  SET VAR+
vFilePath TEXT,  +
vFileName TEXT, +
vLastParen INTEGER, +
vPathLength INTEGER, +
vFileName TEXT
  SET VAR vFilePath = (FINDFILE("alb.rmd"))
  SET VAR vLastParen INTEGER = (SLOCP(.vFilePath,"\",-1))
  SET VAR vPathLength INTEGER = (SLEN(.vFilePath))
  SET VAR vFileName TEXT = (SGET(.vFilePath,(.vPathLength-.vLastParen),+
  (.vLastParen + 1)))
  PAUSE 2 USING .vfilepath
  PAUSE 2 USING .vfilename
  RETURN



> On Feb 15, 2018, at 1:27 PM, jan johansen  wrote:
> 
> Well that works too. More than one way to skin a cat.
>  
>  
> -Original Message-
> From: Dan Goldberg 
> To: "rbase-l@googlegroups.com" 
> Date: Thu, 15 Feb 2018 20:23:58 +
> Subject: RE: [RBASE-L] - File location and path
>  
> You would need to strip it out.
>  
> This what I use to get the filename.
>  
>  
> PLUGINS loadfilename vefilename |fullpath on |TITLE SELECT file +
> TO attach |view_mode list |initial_dir 
>  
> SET VAR vefilename2 = (SRPL(.vefilename,'\',',',0))
>  
> SET VAR veitemcnt = (ITEMCNT(.vefilename2))
>  
> set var vfilenameonly = (SSUB(.vefilename2,.veitemcnt))
>  
> Dan Goldberg
>  
>  
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> jan johansen
> Sent: Thursday, February 15, 2018 12:06 PM
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - File location and path
>  
> I'm looking for ideas.
>  
> I need BOTH the fullpath and the filename without the path.
> I don't think there is an option using either of the loadfile plugins.
>  
> Thoughts?
> --
> 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 
> .

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

[Albert Berry]

I just checked 9.5_64 WIN and INITVAL is not in the help search. Maybe it was 
added in RBGX 

> On Feb 9, 2018, at 3:00 PM, Lena Dammstrom  wrote:
> 
> Hi all.
>  
> I am wondering/trying to confirm…
> Is the OPTION INITVAL available for CHOOSE command in RBase for DOS?
>  
> My gut is telling windows only.
>  
> Regards
> Lena
> 
> 
>  
> Lena Dammstrom
> Software Developer  
> Email:  ldammst...@qmiusa.com 
> Toll Free:  800-446-2500
> International:  01 630-529-7111
> Extension:  1037
> www.qmiusa.com 
>  
>  
> .
> This email may contain material that is confidential, privileged and/or 
> attorney work product for the sole use of the intended recipient. Any review, 
> reliance or distribution by others or forwarding without express permission 
> is strictly prohibited. If you are not the intended recipient, please contact 
> the sender and delete all copies
> 
> -- 
> 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.

Re: [RBASE-L] - CHOOSE command

[Albert Berry]

I have DOS versions up to 7 in a developer’s pack. I can look for your version 
if it is that early. 
Albert

> On Feb 9, 2018, at 3:00 PM, Lena Dammstrom  wrote:
> 
> Hi all.
>  
> I am wondering/trying to confirm…
> Is the OPTION INITVAL available for CHOOSE command in RBase for DOS?
>  
> My gut is telling windows only.
>  
> Regards
> Lena
> 
> 
>  
> Lena Dammstrom
> Software Developer  
> Email:  ldammst...@qmiusa.com 
> Toll Free:  800-446-2500
> International:  01 630-529-7111
> Extension:  1037
> www.qmiusa.com 
>  
>  
> .
> This email may contain material that is confidential, privileged and/or 
> attorney work product for the sole use of the intended recipient. Any review, 
> reliance or distribution by others or forwarding without express permission 
> is strictly prohibited. If you are not the intended recipient, please contact 
> the sender and delete all copies
> 
> -- 
> 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.

Re: [RBASE-L] - Lost rows

[Albert Berry]

If you are using SQL Grant/Revoke, you can deny delete on any table for all but 
the owner. 
If not, you can certainly add it to your system. Razzak’s ate web site has a 
comprehensive article on the use of Grant/Revoke to prevent troubles with your 
data. 

Albert

> On Feb 8, 2018, at 10:15 AM, Buddy Walker  wrote:
> 
> Dick
>  Have you re-loaded/packed the database recently. I would suggest pack keys 
> for the table in question. It could be the index is corrupt and the row is 
> not really deleted. 
> 
>  If the row is actually deleted I would suggest putting an On Before DELETE 
> trigger on the table. This way you could get the row information and insert 
> into  tblDeletions and add username to that row. This way you will know who 
> is doing the deletions. 
> 
> Buddy
> 
> 
> -Original Message-
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> Carpet Broker, Dick Fey
> Sent: Thursday, February 8, 2018 10:46 AM
> To: RBase Maillist 
> Subject: [RBASE-L] - Lost rows
> 
> Help...
> 
> We are having a problem with occasional rows just disappearing from a table.  
> We know they were there in the beginning, because we print an order when 
> entered.
> 
> Sometimes coming back to the order later, 1 or more detail rows are missing.  
> I have no idea how that can happen.
> 
> The question is Can I make it impossible for rows to be deleted from a 
> table under any circumstances ?
> 
> Found a rule restricting deletion, but not absolute.   Any ideas would be 
> helpful.
> 
> Thanks,
> 
> Dick Fey
> 
> --
> Carpet Broker Inc
> P: 913-894-9211
> F: 913-894-0138
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Autofill a form field

[Albert Berry]

I vaguely remember Razzak showing how using an ON KEYPRESS EEP. Perhaps a 
search of this and of Razzak’s helpful site would give you the clue. 
Albert

> On Jan 31, 2018, at 3:28 PM, dkfowler6179  wrote:
> 
> R:Base X, newest version.  Looking for a way to autofill a field in a form 
> with a value from an existing table based in characters typed in.  For 
> example.  If we have a table that holds city names, I'd like to autofill a 
> field for city in a form based on what is being typed, with the more 
> characters being typed increasing the accuracy of the fill choice.  This 
> value then needs to be saved when the row of data specific to a the job being 
> entered is saved.  I've played with a DB Lookup List View and this acts 
> similar to what I'm hoping for.  However you have to type very quickly to 
> keep it from switching the lookup back to the first letter of the street 
> name.  I also don't need a long list, just a few choices as more characters 
> are entered and narrow down the options to the correct choice.  
> Any help is appreciated.  
> Thanks,
> 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.

-- 
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] - Command History buttons

[Albert Berry]

[Ctrl]-[F11] and save the command in the note pad. 
Albert

> On Jan 27, 2018, at 1:52 PM, MD  wrote:
> 
> Hello,
> Is there a way to preset in the command history view the button?
> 
>  
>  
> I would love to have these come up every time but it defaults to a different 
> sequence.
>  
> 
> Thank you,
> Manuel de Aguiar
> M|D Enterprises
> 
> -- 
> 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.

Re: [RBASE-L] - RE: Check for an Internet Connection

[Albert Berry]

My suspicion is confirmed — the delay is the wild interface. Thanks for the 
timing check. Even transistors cannot compensate for some things. 
Albert

> On Jan 26, 2018, at 10:05 AM, karentellef via RBASE-L 
> <rbase-l@googlegroups.com> wrote:
> 
> It was instant on mine (win 10, wired)
> 
> Karen
> 
> 
> 
> -Original Message-
> From: Albert Berry <alb...@albertberry.com>
> To: rbase-l <rbase-l@googlegroups.com>
> Sent: Fri, Jan 26, 2018 10:55 am
> Subject: Re: [RBASE-L] - RE: Check for an Internet Connection
> 
> Now there is one I didn’t know about. Tried it in RBGXE running on Win 7 Pro 
> via Parallels on my MacBook Air. A little under 5 seconds returned YES. The 
> connection is via Mac OS X High Sierra through the Parallels interface to 
> WiFi on the MacBook. I don’t know why, but I suspect that the convoluted 
> interface I run under might have contributed to the time the command took ;)
> 
> Albert
> 
> 
> On Jan 26, 2018, at 9:46 AM, Dan Goldberg <d...@lancecamper.com 
> <mailto:d...@lancecamper.com>> wrote:
> 
> GETPROPERTY APPLICATION IsInternetConnected 'varname'
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf 
> Of Richardson, Jeff
> Sent: Friday, January 26, 2018 8:43 AM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: [RBASE-L] - Check for an Internet Connection
>  
> Hello. Is there a command that will check for an Internet connection in 
> R:Base X Enterprise? Thanks!
>  
>  
> Jeff Richardson | Project Manager, Asset Verification Services (AVS)
> DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 
> 650, Fort Wayne, IN 46802
> Cell: 724-366-1724
> Connect:  <mailto:jrichard...@dmainc.com>jrichard...@dmainc.com 
> <mailto:jrichard...@dmainc.com> | Website <http://www.dmainc.com/> | LinkedIn 
> <https://www.linkedin.com/company/ducharme-mcmillen-&-associates> | Twitter 
> <https://twitter.com/DMATAX> | Facebook 
> <https://www.facebook.com/DMAtaxservices>
> ___
> ATTENTION: This message and all attachments are PRIVATE, and may contain 
> information that is CONFIDENTIAL and PRIVILEGED.  If you have received this 
> message in error, please notify the sender by reply e-mail and delete the 
> message immediately.
>  
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> 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>.
> For more options, visit https://groups.google.com/d/optout 
> <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] - RE: Check for an Internet Connection

[Albert Berry]

Now there is one I didn’t know about. Tried it in RBGXE running on Win 7 Pro 
via Parallels on my MacBook Air. A little under 5 seconds returned YES. The 
connection is via Mac OS X High Sierra through the Parallels interface to WiFi 
on the MacBook. I don’t know why, but I suspect that the convoluted interface I 
run under might have contributed to the time the command took ;)

Albert


> On Jan 26, 2018, at 9:46 AM, Dan Goldberg  wrote:
> 
> GETPROPERTY APPLICATION IsInternetConnected 'varname'
>  
> Dan Goldberg
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Richardson, Jeff
> Sent: Friday, January 26, 2018 8:43 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - Check for an Internet Connection
>  
> Hello. Is there a command that will check for an Internet connection in 
> R:Base X Enterprise? Thanks!
>  
>  
> Jeff Richardson | Project Manager, Asset Verification Services (AVS)
> DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 
> 650, Fort Wayne, IN 46802
> Cell: 724-366-1724
> Connect: jrichard...@dmainc.com  | Website 
>  | LinkedIn 
>  | Twitter 
>  | Facebook 
> 
> ___
> ATTENTION: This message and all attachments are PRIVATE, and may contain 
> information that is CONFIDENTIAL and PRIVILEGED.  If you have received this 
> message in error, please notify the sender by reply e-mail and delete the 
> message immediately.
>  
> -- 
> 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.

Re: [RBASE-L] - Phantom number

[Albert Berry]

Dick, pack your indexes and constraints. You have a spurious index entry I 
suspect. 
Albert

> On Jan 15, 2018, at 8:48 AM, Carpet Broker, Dick Fey  
> wrote:
> 
> Have an integer column in our order table that holds our order numbers.  
> Maximum ever is  99
> Command to generate a new number for new order, is to compute Max no. from 
> table and add 1
> That becomes the new order no.
> 
> Last week the system conjured up a number or 10 or 12 digits, and added 1
> If you looked at the table, that number did not exist.
> Edit all using that number returned nothing.
> 
> I fixed it by setting a limit on the compute max command to 99, but sure
> would like to understand where that phantom number is coming from.
> 
> Dick Fey
> 
> -- 
> Carpet Broker Inc
> P: 913-894-9211
> F: 913-894-0138
> 
> 
> -- 
> 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.

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

[Albert Berry]

Here’s a test file that will show how to do this. It works, but you will have 
to modify it if the time span is 24 hrs or more.  Copy this into a text file 
and run it at the R>


  CLEAR VAR vdatetime1, vdatetime2, vElapsed1, vElapsed2
  SET VAR vDateTime1 = (.#now - 85000) -- a little less than a day earlier
  SET VAR vDateTime2 = (.#now) -- than this datetime (24h = 
86,400 sec)
  SET VAR vElapsed1 = (.vDateTime2-.vDateTime1)
  SET VAR vElapsed2 = (RTIME(0,0,.vElapsed1))
  PAUSE 2 USING .vElapsed2
  RETURN



> On Jan 12, 2018, at 7:10 PM, 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.

-- 
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] - Any way to have DIALOG pre-select the default text.

[Albert Berry]

As mentioned above: create a variable form to accept the variable. 
Set the focus to the variable edit.
Set auto select on.
Set focus to the variable edit in the “On after start” eep. 
Albert

> On Jan 12, 2018, at 9:37 AM, Albert Berry <alb...@albertberry.com> wrote:
> 
> Just had a quick check, and the dialog value doesn’t seem to have a preselect 
> parameter available. 
> 
> When I hit this sort of problem, I whip up a quick form that looks just like 
> the Dialog box. 
> 
> That might be your best option. 
> 
> Albert
> 
>> On Jan 12, 2018, at 8:08 AM, 'Lawrence Lustig' via RBASE-L 
>> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> wrote:
>> 
>> I'm starting a DIALOG command with a default value already in the variable 
>> used by the DIALOG.
>> 
>> The appearance is that the cursor is positioned at the beginning of the 
>> value in the DIALOG's input edit.
>> 
>> I would prefer the value to be already selected so that anything the user 
>> enters replaces what's there already.  I cannot find anything in the OPTIONS 
>> documentation to pre-select the value display.
>> 
>> Anyone know if this is possible.
>> --
>> Larry
>> 
>> -- 
>> 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>.
>> For more options, visit https://groups.google.com/d/optout 
>> <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] - Any way to have DIALOG pre-select the default text.

[Albert Berry]

Just had a quick check, and the dialog value doesn’t seem to have a preselect 
parameter available. 

When I hit this sort of problem, I whip up a quick form that looks just like 
the Dialog box. 

That might be your best option. 

Albert

> On Jan 12, 2018, at 8:08 AM, 'Lawrence Lustig' via RBASE-L 
>  wrote:
> 
> I'm starting a DIALOG command with a default value already in the variable 
> used by the DIALOG.
> 
> The appearance is that the cursor is positioned at the beginning of the value 
> in the DIALOG's input edit.
> 
> I would prefer the value to be already selected so that anything the user 
> enters replaces what's there already.  I cannot find anything in the OPTIONS 
> documentation to pre-select the value display.
> 
> Anyone know if this is possible.
> --
> Larry
> 
> -- 
> 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.

Re: [RBASE-L] - Any way to have DIALOG pre-select the default text.

[Albert Berry]

SET VAR vDialog TEXT = “whatever”
DIALOG …..

Albert

> On Jan 12, 2018, at 8:08 AM, 'Lawrence Lustig' via RBASE-L 
>  wrote:
> 
> I'm starting a DIALOG command with a default value already in the variable 
> used by the DIALOG.
> 
> The appearance is that the cursor is positioned at the beginning of the value 
> in the DIALOG's input edit.
> 
> I would prefer the value to be already selected so that anything the user 
> enters replaces what's there already.  I cannot find anything in the OPTIONS 
> documentation to pre-select the value display.
> 
> Anyone know if this is possible.
> --
> Larry
> 
> -- 
> 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.

Re: [RBASE-L] - [Business Web Applications using Java]

[Albert Berry]

Slick! Thanks for letting us snoop!
Albert

> On Jan 5, 2018, at 10:38 AM, jan johansen  wrote:
> 
> All,
>  
> If you are interested in looking at a Java site that works with Oterro into 
> our RBaseX database,
> goto
> www.jjcalibrations.com/equipmgr/
> Use the following to login;
> guest
> jjguest
>  
> We had Raffee convert our PHP application.
>  
> Hope this helps.
>  
> Jan
>  
> -Original Message-
> From: "A. Razzak Memon" 
> To: rbase-l@googlegroups.com
> Date: Thu, 04 Jan 2018 21:42:31 -0500
> Subject: Re: [RBASE-L] - [Business Web Applications using Java]
>  
> If anyone is planning to develop and deploy robust and secure web
> applications/portals,
> they should look into using Java.
> 
> In 2017, we have switched all our corporate clients and their mission
> critical business
> applications and web portals to Java running on MS Windows Server
> 2012R2 and 2016.
> 
> In doing so, the latest versions and updates of Oterro XE (Version
> 10, Version 10.5)
> are made fully compatible with Java.
> 
> Java is by far the most robust and secure environment. It has become
> a preferred choice
> for developing web applications for a cross platform approach. Since
> Java works on most
> leading Operating Systems, it is used in a wide range of platforms
> from desktops to
> mobile devices.
> 
> Our own R:BASE Updates portal https://www.rbaseupdates.com 
>  is a great
> example of our
> showcase.
> 
> If anyone is interested in seeing business applications and customer
> web portals using
> R:BASE XE, Oterro XE, and Java running on MS Windows Server 2012R2
> and Server 2016,
> please contact R:BASE Technologies' Services Division at
> mailto:servi...@rbase.com .
> 
> Very Best R:egards,
> 
> Razzak
> 
> At 04:44 PM 1/4/2018, Jim Belisle wrote:
> 
> >We are looking into having our customers be able to order product
> >directly into RBASE
> >from the web. They of course would fill out a form, create a user
> >name and password
> >and be able to order. This would also give the ability for them to
> >print certain
> >reports showing what they ordered.
> >Anyone out there use a specific software that you have found helpful
> >in this case?
> >
> >You can send directly to my email if you want.
> 
> 
> 
> 
> --
> 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.

Re: [RBASE-L] - Phishing

[Albert Berry]

I also got one. I get similar from myself on occasion. 
Albert

> On Jan 4, 2018, at 6:00 PM, peterjryanc...@gmail.com wrote:
> 
> Thank you I agree 
> 
> Sent from my iPhone
> 
> On Jan 3, 2018, at 9:20 AM, Buddy Walker  > wrote:
> 
>> I just received an email from rbase-l@googlegroups.com 
>>  wishing me a Merry Christmas and it has an 
>> e-card attached. I didn’t click on and would suggest if you received this 
>> don’t click on it.
>>  
>> It was 
>>  delivered to my in box instead of my R:Base folder. 
>> Missing from address “On Behalf Of” …
>> The email address associated with it is mel...@plazauniversel.com 
>> 
>>  
>> Just a heads up.
>>  
>> Happy New Year
>>  
>> Buddy
>>  
>>   <>
>> 
>> -- 
>> 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.

Re: [RBASE-L] - One last question, if possible

[Albert Berry]

r.
>  
> Cathy
>  
>  
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf 
> Of Larry Wilson
> Sent: Sunday, December 31, 2017 2:06 PM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: Re: [RBASE-L] - One last question, if possible
>  
> Cathy,
>  
> IF you really want to confirm date, time and file size changes here is a sure 
> method.
>  
> Make certain that you have a current backup of your database.
> #1 - exit to the R> prompt
> #2 - R> dir *.RB?
> make not fo the date. time and file sizes
> #3 - R> Disconnect
> #4 - R> Set Multi Off
> #5 - R> Pack
> #6 - R> Dir *.RB?
> make note of the  date, time and file sizes - they should have changed
> Reconnect to your database
> Hope this helps and gives you comfort.
>  
> Larry
> 
> Larry Wilson
> President & CEO 
> 
> Promesa Consulting Group, Inc.
> 1727 N Street NW, Suite 400
> Washington, DC 20036
> 202-808-8836 (O)
> 202-733-7006 (C)
> 202-808-8837 (F)
> 
>  
> On Sun, Dec 31, 2017 at 12:52 PM, Cathy Grimes <cfgri...@verizon.net 
> <mailto:cfgri...@verizon.net>> wrote:
>> Thank you, Albert.  The date and time does not change no matter what I do, 
>> or when I make any changes.
>>  
>> The file sizes not changing is what concerns me most.   I have not been 
>> creating new databases or tables, but regularly edit the data and create 
>> and/or edit reports….but still no file size change (or date change) at all.
>>  
>> Hopefully, since I don’t seem to be losing my changed data, the static file 
>> sizes are not affecting the integrity of the database.  But it would really 
>> ease my mind if I could find out how to fix it.
>>  
>> Cathy
>>  
>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On 
>> Behalf Of Albert Berry
>> Sent: Sunday, December 31, 2017 9:33 AM
>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>> Subject: Re: [RBASE-L] - One last question, if possible
>>  
>> The date/time is last connection time, not the time you disconnected, I 
>> think.
>> I don’t think you need to change the dates. When you disconnect and 
>> reconnect, the date/time will be updated to the time of connection. 
>>  
>> File sizes, on the other hand, should change as you manipulate the data and 
>> the database files are saved.
>>  
>> Albert
>>  
>>  
>>  
>>  
>> 
>>> On Dec 31, 2017, at 9:20 AM, Cathy Grimes <cfgri...@verizon.net 
>>> <mailto:cfgri...@verizon.net>> wrote:
>>>  
>>> Thank you, Buddy, for taking the time to respond.  I am the only user so no 
>>> one else in the database ever.  I’m not sure what you mean by R:Base 
>>> possibly considering the database as being out of sync, but I’ve had no 
>>> problems accessing the database, making changes, etc., then having the 
>>> changes (ones I’ve checked) still there after I’ve exited, updated the 
>>> dates, then re-accessed.  I do check my back-up drive periodically to make 
>>> sure that all 4 of the data files are copied after I’ve forced a date 
>>> change.
>>>  
>>> Because I do manually update the dates and copy the files every couple of 
>>> days, that should accomplish the same end result as your schedule task 
>>> suggestion – it just takes me a few seconds each time (even if it is 
>>> annoying to have to do this).  That is a good thing, because I would have 
>>> no idea how to create a schedule task.  My tech guy set up Acronic True 
>>> Image in the separate back-up hard drive, and I have periodically have 
>>> problems with that working properly.
>>>  
>>> I guess I just wanted to be assured that my database is still ok with my 
>>> manual updating, especially since the file sizes do not change at all when 
>>> I update them.
>>>  
>>> Cathy
>>>  
>>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>>> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On 
>>> Behalf Of Buddy Walker
>>> Sent: Sunday, December 31, 2017 7:56 AM
>>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>>> Subject: RE: [RBASE-L] - One last question, if possible
>>>  
>>> Cathy
>>>I believe the date wil

Re: [RBASE-L] - One last question, if possible P.S. to Jan

[Albert Berry]

Check the header and make sure you are inspecting the database you are actually 
connected to. It sounds as if in file explorer you are looking at the wrong 
directory. 

Albert. [——]
   



> On Jan 1, 2018, at 3:58 AM, Cathy Grimes <cfgri...@verizon.net> wrote:
> 
> P.S.  I forgot to add… I also have Explorer show File size, which is another 
> reason for my concern since none of the 4 files has changed size for months 
> now.
>  
> Cathy
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf 
> Of jan johansen
> Sent: Sunday, December 31, 2017 11:23 AM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: RE: [RBASE-L] - One last question, if possible
>  
> Open the folder and check thusly
>  
>   
>> -Original Message-
>> From: "jan johansen" <j...@jjcalibrations.com 
>> <mailto:j...@jjcalibrations.com>>
>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>> Date: Sun, 31 Dec 2017 11:18:16 -0800
>> Subject: RE: [RBASE-L] - One last question, if possible
>>   
>> Are you using Windows 10? You may need to change the file attributes that 
>> you wish to see in the folder.
>> There are several dates available.
>>  
>>   
>>> -Original Message-
>>> From: "Cathy Grimes" <cfgri...@verizon.net <mailto:cfgri...@verizon.net>>
>>> To: <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>>
>>> Date: Sun, 31 Dec 2017 09:52:49 -0800
>>> Subject: RE: [RBASE-L] - One last question, if possible
>>>   
>>> Thank you, Albert.  The date and time does not change no matter what I do, 
>>> or when I make any changes.
>>>  
>>> The file sizes not changing is what concerns me most.   I have not been 
>>> creating new databases or tables, but regularly edit the data and create 
>>> and/or edit reports….but still no file size change (or date change) at all.
>>>  
>>> Hopefully, since I don’t seem to be losing my changed data, the static file 
>>> sizes are not affecting the integrity of the database.  But it would really 
>>> ease my mind if I could find out how to fix it.
>>>  
>>> Cathy
>>>  
>>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>>> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On 
>>> Behalf Of Albert Berry
>>> Sent: Sunday, December 31, 2017 9:33 AM
>>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>>> Subject: Re: [RBASE-L] - One last question, if possible
>>>  
>>> The date/time is last connection time, not the time you disconnected, I 
>>> think.
>>> I don’t think you need to change the dates. When you disconnect and 
>>> reconnect, the date/time will be updated to the time of connection. 
>>>  
>>> File sizes, on the other hand, should change as you manipulate the data and 
>>> the database files are saved.
>>>  
>>> Albert
>>>  
>>>  
>>>  
>>> 
>>> 
>>> 
>>>> On Dec 31, 2017, at 9:20 AM, Cathy Grimes <cfgri...@verizon.net 
>>>> <mailto:cfgri...@verizon.net>> wrote:
>>>>  
>>>> Thank you, Buddy, for taking the time to respond.  I am the only user so 
>>>> no one else in the database ever.  I’m not sure what you mean by R:Base 
>>>> possibly considering the database as being out of sync, but I’ve had no 
>>>> problems accessing the database, making changes, etc., then having the 
>>>> changes (ones I’ve checked) still there after I’ve exited, updated the 
>>>> dates, then re-accessed.  I do check my back-up drive periodically to make 
>>>> sure that all 4 of the data files are copied after I’ve forced a date 
>>>> change.
>>>>  
>>>> Because I do manually update the dates and copy the files every couple of 
>>>> days, that should accomplish the same end result as your schedule task 
>>>> suggestion – it just takes me a few seconds each time (even if it is 
>>>> annoying to have to do this).  That is a good thing, because I would have 
>>>> no idea how to create a schedule task.  My tech guy set up Acronic True 
>>>> Image in the separate back-up hard drive, and I have periodically have 
>&

Re: [RBASE-L] - One last question, if possible

[Albert Berry]

The date/time is last connection time, not the time you disconnected, I think.
I don’t think you need to change the dates. When you disconnect and reconnect, 
the date/time will be updated to the time of connection. 

File sizes, on the other hand, should change as you manipulate the data and the 
database files are saved.

Albert




> On Dec 31, 2017, at 9:20 AM, Cathy Grimes  wrote:
> 
> Thank you, Buddy, for taking the time to respond.  I am the only user so no 
> one else in the database ever.  I’m not sure what you mean by R:Base possibly 
> considering the database as being out of sync, but I’ve had no problems 
> accessing the database, making changes, etc., then having the changes (ones 
> I’ve checked) still there after I’ve exited, updated the dates, then 
> re-accessed.  I do check my back-up drive periodically to make sure that all 
> 4 of the data files are copied after I’ve forced a date change.
>  
> Because I do manually update the dates and copy the files every couple of 
> days, that should accomplish the same end result as your schedule task 
> suggestion – it just takes me a few seconds each time (even if it is annoying 
> to have to do this).  That is a good thing, because I would have no idea how 
> to create a schedule task.  My tech guy set up Acronic True Image in the 
> separate back-up hard drive, and I have periodically have problems with that 
> working properly.
>  
> I guess I just wanted to be assured that my database is still ok with my 
> manual updating, especially since the file sizes do not change at all when I 
> update them.
>  
> Cathy
>  
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> Buddy Walker
> Sent: Sunday, December 31, 2017 7:56 AM
> To: rbase-l@googlegroups.com
> Subject: RE: [RBASE-L] - One last question, if possible
>  
> Cathy
>I believe the date will change when everyone is disconnected from the 
> database. Also I would be careful about forcing a new date because R:Base may 
> see this as the database being out of SYNC. 
>  
> The auto backup looking at dates may not backup up all 4 database rx 
> files. I would suggest using something like a schedule task that would start 
> R:Base and then copy all 4 files to a backup area. I did this in the past. I 
> would copy the database files at noon (limited activity) and then at 5:00pm 
> and then the normal daily backup at 11:00pm
>  
> Buddy
>   <>
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Cathy Grimes
> Sent: Sunday, December 31, 2017 10:10 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - One last question, if possible
>  
> I hope it’s ok if I ask one more question that has been driving me crazy (as 
> an end user, also the buyer of R:Base).  I was so happy to have my only other 
> main R:Base problem fixed by Razzak so quickly and easily.
>  
> When I last upgraded to R:Base Extreme 9.5(32), the file Attributes suddenly 
> stopped changing, i.e., the date modified never changes, and RB1 through RB4 
> never changes size (no matter how many rows I add or changes I make).
>  
> Because I have auto back-up drive that backs up changes only, it will not 
> back-up my R:Base data files unless I do it manually.  I found a program that 
> will automatically update the date changes to current (if I mark and select 
> those each time), but it does NOT change the size of any of the RB1 through 
> RB4 files.  My data always seems to be there, but I’m worried that the file 
> sizes are static.
>  
> Thank you.  Cathy
>  
>  
> -- 
> 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 

Re: [RBASE-L] - table with dates and date calculations

[Albert Berry]

Computed columns only look to their left — that’s why Col 1 has to be used. 

Albert

> On Dec 22, 2017, at 11:52 AM, Chaya Goldberg  wrote:
> 
> Thanks for your suggestions, Jan and Buddy – the problem is I don’t have a 
> driving table.  I’m generating this calendar table based solely on a start 
> date and end date.
>  
> There’s apparently a way to do this in SQL by assigning row numbers for the 
> number of dates in question (end date minus start date), then adding the 
> start date minus 1 to the entire column.  (Thanks to a coworker and google 
> for this construct!) 
> Is there something similar I can do in RBASE?
>  
> Thank you, Albert and everyone else for your suggestions.  By following your 
> syntax I was able to get the computed columns to work.  And I didn’t know 
> that the date must be in column 1 – so this potentially saves me lots of 
> confusion.
>  
> Thanks.
> Chaya
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of jan johansen
> Sent: Friday, December 22, 2017 1:27 PM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - table with dates and date calculations
>  
> Chaya,
>  
> You can use SELECT INTO from your driving table and it will populate your 
> TEMP table without a cursor.
>  
> Jan
>  
>  
> -Original Message-
> From: Chaya Goldberg  >
> To: "rbase-l@googlegroups.com " 
> >
> Date: Fri, 22 Dec 2017 18:14:29 +
> Subject: RE: [RBASE-L] - table with dates and date calculations
>   
> Another question.  Is there a way to create the original list of dates 
> without using a loop?
>  
> Thanks.
> Chaya
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Chaya Goldberg
> Sent: Friday, December 22, 2017 1:08 PM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - table with dates and date calculations
>  
> Thanks, Buddy.  That’s actually exactly what I was doing, but was getting 
> nowhere.  Looking at your code now, perhaps my syntax was a little off… 
> (Although I did not get any error messages).  Anyway, will try again.  
> Thanks. 
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Buddy Walker
> Sent: Friday, December 22, 2017 1:03 PM
> To: rbase-l@googlegroups.com 
> Subject: RE: [RBASE-L] - table with dates and date calculations
>  
> Chaya
>Take a look at functions for Date
>I did a temp table structure to get you started.
>  
> Buddy
>  
> CREATE TEMPORARY TABLE `TmpDates` +
> (`YourDateHere` DATE, +
> `YourDayOfWeek` = (TDWK(YourDateHere)) TEXT (25), +
> `YourMonthHere` = (TMON(YourDateHere)) TEXT (25))
>  
>  
>  <> 
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Chaya Goldberg
> Sent: Friday, December 22, 2017 12:43 PM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - table with dates and date calculations
>  
> Hi Everyone,
>  
> I’m trying to create a (temporary) table in which the first column will hold 
> all the date values between two given dates (for ex: 9/1/2017, 
> 9/2/2017….8/31/2018), and subsequent columns will hold calculations on this 
> date column (such as dayOfWeek, or the month of the date).  Seems like it 
> should be simple, but I’m having a lot of trouble with this.  Any advice 
> would be appreciated.
>  
> Thanks.
> Chaya
>  
> --
> 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 

Re: [RBASE-L] - RE: table with dates and date calculations

[Albert Berry]

And here all the functions you can use in the columns. The date must be in 
Column 1. 



Using 6/10/1940:
IMON: 6
IYR:1940
IDAY:  10
IWOY: 24 (week of year)
IDWK: 1
TDWK: Monday
IDIM: 30 (days in month 6)
etc.

> On Dec 22, 2017, at 11:02 AM, Jim Belisle  wrote:
> 
> Try this code.
> CREATE TEMP TABLE tdtimes (sdate DATE, dowdate=(TDWK(sdate)) text 20, 
> moddate=(TMON(sdate)) TEXT 20)
>  
> When you insert the date in the first col, you get the next two columns.
>  
> James Belisle
>  
> Making Information Systems People Friendly Since 1990
> 
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Chaya Goldberg
> Sent: Friday, December 22, 2017 11:43 AM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - table with dates and date calculations
>  
> Hi Everyone,
>  
> I’m trying to create a (temporary) table in which the first column will hold 
> all the date values between two given dates (for ex: 9/1/2017, 
> 9/2/2017….8/31/2018), and subsequent columns will hold calculations on this 
> date column (such as dayOfWeek, or the month of the date).  Seems like it 
> should be simple, but I’m having a lot of trouble with this.  Any advice 
> would be appreciated.
>  
> Thanks.
> Chaya 
>  
> 
> -- 
> 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.

Re: [RBASE-L] - From The Edge: Tip of the Day Digest (2017)

[Albert Berry]

On my desktop now. Thanks Razzak!


> On Dec 19, 2017, at 10:28 PM, A. Razzak Memon  wrote:
> 
> Wednesday, December 20, 2017
> 
> To R:BASE Community:
> 
> The updated end-of-the-year "Tip of the Day" Digest is now available!
> 
> The "Tip of the Day" Digest is an archive of all "Tip of the Day" threads
> posted on the R:BASE List Server, that is consolidated into a single PDF
> document.
> 
> The topics primarily detail areas of R:BASE X/X Enterprise (Version 10).
> 
> From The Edge: http://www.razzak.com/fte/
> 
> Article Title: Tip of the Day Digest (2017)
> Date Posted..: December 20, 2017
> File Format..: PDF
> Total Pages..: 372
> File Size: 23.9MB
> 
> Have Fun!
> 
> Very Best R:egards,
> 
> Razzak.
> 
> www.rbase.com
> www.facebook.com/rbase
> 
> -- 
> 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.

Re: [RBASE-L] - One Form for a Search - to have Multiple Forms Open at the Same Time

[Albert Berry]

Multiple MDI forms? A button somewhere allowing an opening of.a new MDI form in 
Enter mode?

Albert

> On Dec 18, 2017, at 2:51 PM, Myron Finegold  wrote:
> 
> The challenge.  To have the potential to have a form open multiple times 
> based on one form that is being used for the search.
> 
> A user (dispatcher) needs do a search based on a street address – this is the 
> form that the dispatcher sees. This is easy to do for one data set. The 
> address is picked and the detail information is shown on the screen.  Now, 
> another call comes in before the first one is finished, so the first group of 
> information has to stay on the screen. And, yes a third call comes in and the 
> first two sets of data needs to stay on the screen – until closed.  Ideally, 
> a tabbed form with the address in the tab would work but I have hit the wall.
> 
> Just an FYI, this is for a Posse application where patrol cars are calling in 
> the address.
> 
> Any clues would be appreciated.
> 
> Myron Finegold,
> 
> Volunteer at the Sheriff’s Posse of Sun City West
> 
>  
> 
> 
> -- 
> 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.

Re: [RBASE-L] - Re: [RBASE-L - Suppressing main R:Base screen

[Albert Berry]

I was thinking maybe immediately before the two MDI form calls, and add RSHOW 
after the close.

Albert

> On Dec 18, 2017, at 2:56 PM, dkfowler6179  wrote:
> 
> Albert,
> 
> You may be on to something.  Hope to have a few minutes to try it out yet 
> today.   Have to figure out where to place it so it works.
> 
> David
> 
> -- 
> 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] - Re: [RBASE-L - Suppressing main R:Base screen

[Albert Berry]

RHIDE

Albert

> On Dec 18, 2017, at 10:13 AM, DAVID FOWLER  wrote:
> 
> Razzak,
> 
> Thank you for the quick answer.  What you suggest is what I have done.  The 
> only difference is that the second for I open is also MDI.  If I open the 
> second without it being MDI, I can't move back and forth between the two 
> forms, I can only access the second form that is opened.  
> 
> Here's the code from the app that opens the forms.
> 
> CONNECT custmr
> PROPERTY APPLICATION TITLE 'Dispatch'
> EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator +
> MDI AS dispatchwindow CAPTION 'DISPATCHED JOBS'
> EDIT USING pendingjobs WHERE status='p' SORTED BY jobdate street +
> MDI AS pendingwindow CAPTION 'PENDING JOBS'
> RETURN
> 
> Thanks for any other ideas.
> 
> David Fowler
> 
> 
>> On December 18, 2017 at 10:12 AM "A. Razzak Memon"  wrote:
>> 
>> 
>> David,
>> 
>> Here is a very simple approach ...
>> 
>> 01. Create a command file, such as, MyApplication.DAT, that include 
>> all your database CONNECT statement and then EDIT USING formname , etc.
>> -- Example
>> -- MyApplication.DAT
>> CONNECT dbname
>> CLS
>> EDIT USING formname1 MDI
>> EDIT USING formname2
>> RETURN
>> 
>> 02. Create application shortcut as follows:
>> -- Example
>> Target: C:\RBTI\RBGX\RBGX.EXE MyApplication.DAT
>> Start in: C:\Databases\
>> 
>> 03. Double-clicking on the shortcut will launch RBGX.exe with all 
>> your statements in the MyApplication.DAT file.
>> 
>> 04. You may also RUN MyApplication.DAT at the R> Prompt or from the 
>> Database Explorer > Command Files as well.
>> 
>> That should provide you with the outcome you are looking for.
>> 
>> Hope that helps!
>> 
>> Very Best R:egards,
>> 
>> Razzak
>> 
>> 
>> 
>> At 09:41 AM 12/18/2017, dkfowler6179 wrote:
>> 
>>> I've got an app that opens two forms as MDI.  That part works, but 
>>> after the forms open, the main R:Base screen (database explorer, 
>>> editor, etc. Opens over top of the forms.  I can minimize that 
>>> window and hide it behind the forms and use them but would like to 
>>> suppress the window from opening at all.  I'm probably missing 
>>> something easy, but haven't been able to figure it out.
>>> 
>>> Thanks for any help.
>>> 
>>> 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.

Re: [RBASE-L] - Suppressing main R:Base screen

[Albert Berry]

PROPERTY RBASE_FORM STAY_ON_TOP ‘ON'

This is an MDI form property. I think if you do the two forms with this the 
main window will stay behind them. It’s worth a try anyway. 

Albert


> On Dec 18, 2017, at 10:13 AM, DAVID FOWLER  wrote:
> 
> Razzak,
> 
> Thank you for the quick answer.  What you suggest is what I have done.  The 
> only difference is that the second for I open is also MDI.  If I open the 
> second without it being MDI, I can't move back and forth between the two 
> forms, I can only access the second form that is opened.  
> 
> Here's the code from the app that opens the forms.
> 
> CONNECT custmr
> PROPERTY APPLICATION TITLE 'Dispatch'
> EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator +
> MDI AS dispatchwindow CAPTION 'DISPATCHED JOBS'
> EDIT USING pendingjobs WHERE status='p' SORTED BY jobdate street +
> MDI AS pendingwindow CAPTION 'PENDING JOBS'
> RETURN
> 
> Thanks for any other ideas.
> 
> David Fowler
> 
> 
>> On December 18, 2017 at 10:12 AM "A. Razzak Memon"  wrote:
>> 
>> 
>> David,
>> 
>> Here is a very simple approach ...
>> 
>> 01. Create a command file, such as, MyApplication.DAT, that include 
>> all your database CONNECT statement and then EDIT USING formname , etc.
>> -- Example
>> -- MyApplication.DAT
>> CONNECT dbname
>> CLS
>> EDIT USING formname1 MDI
>> EDIT USING formname2
>> RETURN
>> 
>> 02. Create application shortcut as follows:
>> -- Example
>> Target: C:\RBTI\RBGX\RBGX.EXE MyApplication.DAT
>> Start in: C:\Databases\
>> 
>> 03. Double-clicking on the shortcut will launch RBGX.exe with all 
>> your statements in the MyApplication.DAT file.
>> 
>> 04. You may also RUN MyApplication.DAT at the R> Prompt or from the 
>> Database Explorer > Command Files as well.
>> 
>> That should provide you with the outcome you are looking for.
>> 
>> Hope that helps!
>> 
>> Very Best R:egards,
>> 
>> Razzak
>> 
>> 
>> 
>> At 09:41 AM 12/18/2017, dkfowler6179 wrote:
>> 
>>> I've got an app that opens two forms as MDI.  That part works, but 
>>> after the forms open, the main R:Base screen (database explorer, 
>>> editor, etc. Opens over top of the forms.  I can minimize that 
>>> window and hide it behind the forms and use them but would like to 
>>> suppress the window from opening at all.  I'm probably missing 
>>> something easy, but haven't been able to figure it out.
>>> 
>>> Thanks for any help.
>>> 
>>> 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.

Re: [RBASE-L] - copying images

[Albert Berry]

You need a sub report formatted to match your input “table”. 
Albert


> On Dec 14, 2017, at 9:47 AM, Randy Larsen <thelars...@gmail.com> wrote:
> 
> Sorry, i wasn’t clear.. the table i’m referring is not a db table, but a 
> table printed in the form..essentially a “reusable" section of the report.
> 
> So basically is there a way to create a reusable section, that is populated 
> with data that could be shared amount many reports
> 
> HTH
> 
> Cheers,
> -Randy
> 
> 
> 
> 
> 
> 
> If you want to go fast, go alone.  If you want to go far, go together.
>   -African proverb
> 
> 
> 
> 
>> On Dec 14, 2017, at 11:17 AM, Buddy Walker <walker.bu...@comcast.net 
>> <mailto:walker.bu...@comcast.net>> wrote:
>> 
>> Randy
>>   If the “similar” is populated based on the user I would make the “similar” 
>> a temporary table. With that the report would print based on that table with 
>> data for that user. By the way other users would not see that table (since 
>> it is dropped when user exits R:Base). 
>> 
>> Buddy
>> 
>> Sent from my iPhone
>> 
>> On Dec 14, 2017, at 10:56 AM, Randy Larsen <thelars...@gmail.com 
>> <mailto:thelars...@gmail.com>> wrote:
>> 
>>> Hi Everyone, I’m also new to Rbase and I’m new to this group.. and very 
>>> happy to see that you are so active!
>>> 
>>> I have a question about Reports as well.
>>> 
>>> I have number of reports that all share a similar table.  I was wondering 
>>> if it is possible to create a report or sub report that can be 
>>> shared/included b/n multiple reports?
>>> 
>>> Thank you!
>>> 
>>> -Randy
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> If you want to go fast, go alone.  If you want to go far, go together.
>>> -African proverb
>>> 
>>> 
>>> 
>>> 
>>>> On Dec 14, 2017, at 10:49 AM, Chaya Goldberg <cgoldb...@omnirehab.com 
>>>> <mailto:cgoldb...@omnirehab.com>> wrote:
>>>> 
>>>> Thanks for your suggestion, Albert.  It gave me an idea.
>>>> I actually did use a sub report initially, but it has the same issue.  
>>>> However perhaps I can use separate sub reports for the two images, in 
>>>> order to eliminate the need for the UPDATE statement.
>>>> 
>>>> Thanks,
>>>> Chaya
>>>> 
>>>> -Original Message-
>>>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
>>>> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On 
>>>> Behalf Of Albert Berry
>>>> Sent: Wednesday, December 13, 2017 3:51 PM
>>>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
>>>> Subject: Re: [RBASE-L] - copying images
>>>> 
>>>> Would it perhaps be easier to use a sub report for the images rather than 
>>>> updating the main table? Sub reports work quite will in R:Base
>>>> 
>>>> Albert
>>>> 
>>>>> On Dec 13, 2017, at 1:33 PM, Chaya Goldberg <cgoldb...@omnirehab.com 
>>>>> <mailto:cgoldb...@omnirehab.com>> wrote:
>>>>> 
>>>>> Hi Everyone,
>>>>> 
>>>>> I’m writing a report which needs to have two or three images on it in a 
>>>>> certain order.  I get these images by querying our database.  The queried 
>>>>> images first get saved to separate temporary tables (one of which will 
>>>>> become the “main” table), then get collected into the main table using an 
>>>>> UPDATE statement.  I then print the report off of this main table.
>>>>> 
>>>>> The problem is that the results are inconsistent.  Sometimes it works and 
>>>>> the images print as they’re supposed to, but other times the second image 
>>>>> does not appear.  In reviewing the tables during their intermediate 
>>>>> stages, I’ve found that although both images initially appear when 
>>>>> queried, the second image does not copy during the UPDATE. 
>>>>> 
>>>>> Any suggestions or ideas as to why this would happen?
>>>>> 
>>>>> 
>>>>> Chaya

Re: [RBASE-L] - copying images

[Albert Berry]

Would it perhaps be easier to use a sub report for the images rather than 
updating the main table? Sub reports work quite will in R:Base
 
Albert

> On Dec 13, 2017, at 1:33 PM, Chaya Goldberg  wrote:
> 
> Hi Everyone,
> 
> I’m writing a report which needs to have two or three images on it in a 
> certain order.  I get these images by querying our database.  The queried 
> images first get saved to separate temporary tables (one of which will become 
> the “main” table), then get collected into the main table using an UPDATE 
> statement.  I then print the report off of this main table.
> 
> The problem is that the results are inconsistent.  Sometimes it works and the 
> images print as they’re supposed to, but other times the second image does 
> not appear.  In reviewing the tables during their intermediate stages, I’ve 
> found that although both images initially appear when queried, the second 
> image does not copy during the UPDATE. 
> 
> Any suggestions or ideas as to why this would happen?
> 
> 
> Chaya 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.
> 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.