Re: [RBASE-L] - Label question

['Buddy Walker' via RBASE-L]

Tom   Have you tried making the font size a little smaller or changing the font type. Buddy Sent from my iPhoneOn Dec 8, 2024, at 10:47 AM, Larry Nemetz  wrote:









Confusing?
What printer are you using? 
Zebra?
If the label printed fine with the settings for 1.75 and for 1.4, just putting the 1.25 labels in the machine and NOT changing
anything in the
Rbase label form should still print something on the label because printers are ‘stupid’
😉
I have 5 Zebra label printers (some 201DPI and some 301DPI) and labels 1” to 3” in height.
I know when I added 301DPI printers the form got screwy but I just left the old height setting alone or it would mess things up.

If you wish I can look at my 1” label form when I am back in the office to see the settings?
 
Larry Nemetz, DVM
The BIRD Clinic Veterinary Corp
200 S Tustin St. #E
Orange, CA
 92866
docb...@hotmail.com
 

From: rbase-l@googlegroups.com
  On Behalf Of Tom Hart
Sent: Sunday, December 8, 2024 7:09 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Label question

 

I have been using the same label for over a decade 3x1.75 but now my vendor is only selling 3x1.25 labels so I am trying to adjust the height and when I do only a blank label shows up.  I have even tried making a new label  and placed one
 data field in the middle of the label to make sure I was not off the page and still blank.  I can go down to 1.4"  and it will work, but no smaller.

Any 


 


Tom Hart


-- 
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 visit 
https://groups.google.com/d/msgid/rbase-l/CABX9BNdMke%3DknPKU5RjSqE2OZo6XZuq4b-73jzd8qOwpXmZSrw%40mail.gmail.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 visit https://groups.google.com/d/msgid/rbase-l/CY5PR11MB6259B45FC47DCEEF1333EE64BA332%40CY5PR11MB6259.namprd11.prod.outlook.com.




-- 
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/rbase-l/21832636-7D48-4B5A-9EC1-4E23FAEA4910%40comcast.net.

RE: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain characters

[Buddy Walker]

Dan

  You could also look at SKEEP

 

Buddy

 

 

From: 'Tony IJntema' via RBASE-L  
Sent: Tuesday, June 18, 2024 9:40 AM
To: rbase-l@googlegroups.com
Subject: Re: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain 
characters

 

Dan,

have a look at the function (SSTRIPI(source, chars))

It could look like this:

SET VAR vsstripi = (SSTRIPI('3935 Old William Penn Highway, 15668',' 
abcdefghijklmnopqrstuvwxyz01234567890-'))

if (slen(vsstripi)) > 0 then
 -- pause message
endif

 

Regards

 

Tony

 

 

Op 18-06-2024 om 15:01 schreef 'Dan Goldberg' via RBASE-L:

Hmm thx jim I will give it a try.

 

Thx

 

Dan Goldberg

 

From: 'jim schmitt' via RBASE-L   
 
Sent: Monday, June 17, 2024 3:17 PM
To: 'Dan Goldberg' via RBASE-L   

Subject: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain characters

 

Hi, Dan:

 

Not to elegant, but this will work, try it.

 

Regards,

 

Jim

 

 

 

   ---   VALIDATE THE PART NUMBER

   --- CHAR BY CHAR

 

   ---   06-17-24

 

   CLS

LABEL START

   SET VAR VF_TEXT = NULL

   SET VAR VF_MSG  - TEXT

 

   DIALOG 'Enter Part Number -or-  Type ''END'' to exit ' VF_TEXT= 20 vEndKey 1

 

   SET VAR VF_LEN  INTEGER = (SLEN(.VF_TEXT))

   IF VF_LEN = 0 THEN

  PAUSE 2 USING  'NO INPUT DATA - PLEASE RE-ENTER'

  GOTO START

   ENDIF

   IF VF_TEXT = 'END' THEN

  RETURN

   ENDIF

---

--  GET CHAR BY CHAR

SET VAR VF_POS  INTEGER = 1

SET VAR VF_CHAR TEXT = NULL

 

LABEL GETNEXT

IF VF_POS < (.VF_LEN +1) THEN

 SET VAR VF_CHAR TEXT = (SGET(.VF_TEXT,1,.VF_POS))

 

 IF VF_CHAR IN (0,1,2,3,4,5,6,7,8,9) THEN

---  BUMP POS COUNT

SET VAR VF_POS = (.VF_POS +1)

GOTO GETNEXT

 ENDIF

 IF VF_CHAR IN +

 (-,A,B,C,D,E,F,G,H,I,J,K.L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z) THEN

---  BUMP POS COUNT

SET VAR VF_POS = (.VF_POS +1)

GOTO GETNEXT

 ENDIF

 ---   MUST BE ILLEGAL CHAR

 SET VAR VF_MSG TEXT = ('PART ' +.VF_TEXT & ' IS INVALID !')

 PAUSE 2 USING .VF_MSG

 GOTO START

   ENDIF

   SET VAR VF_MSG TEXT = ('PART ' +.VF_TEXT & ' IS GOOD !')

   PAUSE 2 USING .VF_MSG

   GOTO START

 

RETURN

 

 

On Monday, June 17, 2024 at 12:46:55 PM EDT, 'Dan Goldberg' via RBASE-L 
mailto:rbase-l@googlegroups.com> > wrote: 

 

 

I need to limit a db edit field in a form to only numbers, letters and dash(-). 
I am not having much luck trying to figure it out.

 

I am wondering if anyone else has done this? If so, maybe can you share some 
details?

 

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/BY3PR19MB5027FBB9B273FA60A5E607CCD4CD2%40BY3PR19MB5027.namprd19.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/289731415.6990238.1718662592117%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/BY3PR19MB5027A968FA7AE3A7964B635BD4CE2%40BY3PR19MB5027.namprd19.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group

Re: [RBASE-L] - update not working

[Buddy Walker]

Dan  I would try putting paren around where clause asWhere ((t1.dlrnum = t2.dlrnum and t1.serial < 90) and t1.invdate is null)BuddySent from my iPhoneOn Mar 6, 2023, at 7:59 PM, Dan Goldberg  wrote:







I have an update command in am trying to run. I am using the newest rbase version.
 
update orders99 set region = t2.region from orders99 t1, dealer t2 where t1.dlrnum = t2.dlrnum and t1.serial < 90 and t1.invdate is null
 
it will say no rows exists
 
but if I run the browse command the rows come up. 
 
browse t1.dlrname, t1.region, t2.region from orders99 t1, dealer t2 where t1.dlrnum = t2.dlrnum and t1.serial < 90 and t1.invdate is null
 
I have checked the database, did an unload/reload, and I am stumped.

 
Any one have any ideas why the update command does not work?
 
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/PH0PR19MB5034C7C166E2112B5406E999D4B79%40PH0PR19MB5034.namprd19.prod.outlook.com.




-- 
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/6CBB3BF1-C783-4E7C-95F6-F62F34F392FC%40comcast.net.

RE: [RBASE-L] - Number of Columns in a DB

[Buddy Walker]

Doug
   Could it be that the select sum picks up all columns in the table and list 
command does not include the system table columns

Buddy

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Tuesday, January 24, 2023 11:34 PM
To: R:Base List 
Subject: [RBASE-L] - Number of Columns in a DB

Curious discrepancy:

When I SELECT SUM(SYS_NUM_COLUMNS) INTO vSumCols FROM SYS_Tables from a 
database, the sum is 1395.

When I do a List command, the number of columns in the database is 1346.

In another database, the sum was 698, List command was 614.

The databases were just connected so there were no temp tables or views.
The columns in permanent views don't account for the difference.

Not a pressing issue, just a curiosity.
Any ideas?  I'm sure the answer is simple - that's why it's escaping me.

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/28ec98ff-f00c-3127-0dc8-be64e9594c67%40wi.rr.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/001801d930c7%247d77ab00%2478670100%24%40comcast.net.

RE: [RBASE-L] - Detecting Row With Focus In Scrolling Region

[Buddy Walker]

Jim
  Wouldn’t setting a variable to the unique id when entering that row.

Buddy


-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of James 
Burroughs
Sent: Thursday, June 23, 2022 11:10 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Detecting Row With Focus In Scrolling Region

Does anyone know if there is a way to detect which row within a scrolling 
region has the focus?  For example, I would like to put code in the 
double-click EEP to perform certain actions, but only for the row which was 
clicked.

Thanks,

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/395bca56-e55e-d77a-2903-71f7320f05b6%40cox.net.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/005201d887c1%247ee00c80%247ca02580%24%40comcast.net.

Re: [RBASE-L] - Delete Trigger mystery?

[Buddy Walker]

Karen

  My first thought was primary and foreign keys with cascade. So when you 
delete row with primary key system deletes foreign key

Buddy

Sent from my iPhone

> On Mar 11, 2022, at 7:01 PM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> 
> 
> Why I needed the before-delete trigger:  no one should ever be deleting data 
> from this table.  And although they have the full version of RBase, no one 
> knows how to "get to the R> prompt".  There is a monthend routine that the 
> senior user runs that will delete a batch of data, but that's all (we remove 
> the trigger before this monthend routine, then put it back on)
> 
> Yet every now and then we find data mysteriously disappeared.
> 
> So I created a before-delete trigger.  It takes the record to be deleted and 
> appends it to an archive table.  3 columns in the archive table will hold the 
> deleted date / time and the user who deleted it.  Works perfectly at my 
> development environment and when I test it at the place where the database is 
> installed.  Records the date, time and the user.
> 
> However, twice now we have found records in that archive table that had been 
> deleted (hundreds at a time).  The records had the deleted date/time but had 
> NO user name.  
> 
> Here's the code I use in my stored procedure.  The DeletedDate and 
> DeletedTime works fine, it gets updated every time.  There is no login to 
> this app, so I grab the NetUser (used many times in the application for other 
> things, successfully).  The first time that the archive had no user name, I 
> modified the stored procedure to grab the ComputerName.  But still, 
> nothing.
> 
> 
>SET VAR vText TEXT = NULL
>SET VAR vText = (CVAL("NetUser"))
>IF vText IS NULL THEN
>  SET VAR vText = (CVAL("ComputerName"))
>ENDIF
> 
>UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
>  DeletedBy = .vText WHERE claim = .spClaim
> 
> 
> 
> Can anyone think of anything else I can trap that would help me figure out 
> how/when the records got deleted?  
> 
> Or does anyone know how records could get deleted when there actually is no 
> NetUser or ComputerName?  
> 
> 
> 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/1654695576.980450.1647043308102%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/C98666B1-D52E-444A-A976-2230F7941E53%40comcast.net.

RE: [RBASE-L] - TreeBuilder

[Buddy Walker]

Jean-Marc

 

   Quel champ est associé au chapitre. Je vais essayer de corriger le rapport 
dans votre pièce jointe.

 

 

   Which field is associated to chapter. I will try and fix the report in your 
attachment.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of 
Jean-Marc Massé
Sent: Sunday, February 13, 2022 2:44 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - TreeBuilder

 

Buddy,

 

Merci pour vos conseils, mais je n’arrive toujours pas a mon résultat.

Qu’entendez vous par un « point d’arrêt » ?

Il se peut que ce que je veux faire soit impossible !

A vous lire

 

Google,

 

Buddy,

 

Thank you for your advice, but I still can't get my result.

What do you mean by a "breakpoint"?

It may be that what I want to do is impossible!

To read you

Best regards,

 

 

 

  _  

Jean-Marc Massé (mobile : 06.08.82.80.86)

1, rue de la Paix

85500 Les Herbiers

  _  

 

 

De : rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > De la part de 
Buddy Walker
Envoyé : vendredi 4 février 2022 16:03
À : rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Objet : RE: [RBASE-L] - TreeBuilder

 

Jean-Marc

 

Avez-vous envisagé de créer des points d’arrêt dans le rapport?

 

Créez une variable vSubTotal et faites-la totaliser (calculez sur : Détail)

 

Créez un point d’arrêt pour le chapitre, puis réinitialisez/effacez vSubToal 
lors de la modification

 

localiser la variable vSubTotal dans le pied de page de rupture

   

J’espère que cela vous aidera

 

Buddy

 

 

 

 

 

Have you looked into creating break points in the report.

 

   Create a variable vSubTotal and have it total (calculate on: Detail)

 

   Create a break point for chapter then reset/clear vSubToal on change

 

   locate variable vSubTotal in break footer

   

 

   Hope this helps

 

Buddy

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Jean-Marc Massé
Sent: Friday, February 4, 2022 6:33 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - TreeBuilder

 

Bonjour à tous,

 

J’essaie depuis de nombreuses semaines de trouver le moyen de faire des 
sous-totaux et totaux de chapitres dans l’édition « TreeDisplayReport » et la 
base en exemple ci-joint sans succès.

Quelqu’un a-t-il déjà eu ce problème à régler ?

J’apprécierai vraiment un coup de main !

 

Bien amicalement, 

Jean-Marc Massé

MCS

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/cfe89f9dcb6845948da07f01b7dae6ca%40masse-charpente.fr
 
<https://groups.google.com/d/msgid/rbase-l/cfe89f9dcb6845948da07f01b7dae6ca%40masse-charpente.fr?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/005401d819d8%24560973c0%24021c5b40%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/005401d819d8%24560973c0%24021c5b40%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/7b4f50f5c00a4beeb1add53f3f1b7730%40masse-charpente.fr
 
<https://groups.google.com/d/msgid/rbase-l/7b4f50f5c00a4beeb1add53f3f1b7730%40masse-charpente.fr?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/004001d820e8%240ce4eaa0%2426aebfe0%24%40comcast.net.

RE: [RBASE-L] - TreeBuilder

[Buddy Walker]

Jean-Marc

 

Avez-vous envisagé de créer des points d’arrêt dans le rapport?

 

Créez une variable vSubTotal et faites-la totaliser (calculez sur : Détail)

 

Créez un point d’arrêt pour le chapitre, puis réinitialisez/effacez vSubToal 
lors de la modification

 

localiser la variable vSubTotal dans le pied de page de rupture

   

J’espère que cela vous aidera

 

Buddy

 

 

 

 

 

Have you looked into creating break points in the report.

 

   Create a variable vSubTotal and have it total (calculate on: Detail)

 

   Create a break point for chapter then reset/clear vSubToal on change

 

   locate variable vSubTotal in break footer

   

 

   Hope this helps

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of 
Jean-Marc Massé
Sent: Friday, February 4, 2022 6:33 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - TreeBuilder

 

Bonjour à tous,

 

J’essaie depuis de nombreuses semaines de trouver le moyen de faire des 
sous-totaux et totaux de chapitres dans l’édition « TreeDisplayReport » et la 
base en exemple ci-joint sans succès.

Quelqu’un a-t-il déjà eu ce problème à régler ?

J’apprécierai vraiment un coup de main !

 

Bien amicalement, 

Jean-Marc Massé

MCS

-- 
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/cfe89f9dcb6845948da07f01b7dae6ca%40masse-charpente.fr
 

 .

-- 
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/005401d819d8%24560973c0%24021c5b40%24%40comcast.net.

RE: [RBASE-L] - Multi-User commands Best Practices

[Buddy Walker]

Karen

   I was using NAME before netuser was available. I also kept the rbase.exe 
file on a network drive. That is why I only had one cfg and dat file to 
control.  Different users had different access to menu items and tables. Then 
when netuser came about I just set the name to it and continued using NAME.

 

Buddy

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, January 31, 2022 9:00 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Multi-User commands Best Practices

 

Go ahead and flame me on this one, but I've had the same modus operandi ever 
since I think version 9.0

 

I don't use CFG files.  Ever.  Anywhere.  I have no clue where/if they are 
installed, nor where they are.  And to this day it has never presented a 
problem in any of my installations.  To me it was one of the best enhancements 
ever, that you can basically ignore those CFG files if you want to.  Need to 
add a user? Give them the desktop icon that points to the network RBase install 
and you're done.  Do they have/need a CFG?  I've never assigned one to a new 
user.  I'm not sure how RBase handles it, but I don't care because it works 
wonderfully.

 

100% of my commands, like the ones you list Doug, are in the startup file.  
That way if you want to change anything, you change one program.  You don't run 
around and change/copy over new CFG files for every user.  I never use "name" 
anymore, I use NetUser.

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Sent: Mon, Jan 31, 2022 6:18 am
Subject: RE: [RBASE-L] - Multi-User commands Best Practices

Doug

   I would only put those in the cfg file. I would set the NAME in RBASE.DAT 
like this

 

   SET VAR vUserName = (CVAL(‘NETUSER’))

   SET NAME &vUserName

 

   I would then make sure the RBASE.DAT AND rbase CFG file were located in same 
folder as the rbase EXE 

   

   Make sure there aren’t any other RBASE.DAT and rbase CFG file located 
anywhere.

 

Buddy

 

 

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of Doug 
Hamilton
Sent: Sunday, January 30, 2022 10:32 PM
To: R:Base List mailto:rbase-l@googlegroups.com> >
Subject: [RBASE-L] - Multi-User commands Best Practices

 

In the recent R:Base Multi-User Guide, the recommended sequence for Multi-User 
Concurrency Settings in a startup file, e.g. RBASE.DAT, is:
DISCONNECT
SET MULTI ON
SET STATICDB ON
SET FASTLOCK ON
SET PAGELOCK OFF
SET ROWLOCKS ON
SET VERIFY COLUMN
SET WAIT 4
SET INTERVAL 5

The same settings are found in the .CFG file, e.g. RBENGINEX5E.CFG
MULTI   ON
STATICDBON
FASTLOCKON
PAGELOCKOFF
ROWLOCKSON
VERIFY  COLUMN
WAIT   4
INTERVAL   5

Is it correct that:
1) the CFG file is processed before the startup DAT file?
2) The order of the commands in the CFG should be the same as in the DAT file?
3) The SET commands in the DAT file are redundant and are not really necessary 
in the DAT file unless settings need to be changed for special circumstances?

Note that the user Guide states: "The settings may be set within the R:BASE 
configuration file. However, the settings are best set in a
startup file before connecting to the database. For example: ..."

Why are the settings best set in a startup file?  Shouldn't default settings be 
established in the CFG file and modified only if necessary?

TIA,
Doug

 

  _  


 <https://www.avast.com/antivirus> 

This email has been checked for viruses by Avast antivirus software. 
www.avast.com <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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.com
 
<https://groups.google.com/d/msgid/rbase-l/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/004901d8169c%24ad391c20%2407ab5460%24%40comcast.net
 
<https://groups.google.com/d/msgid/

RE: [RBASE-L] - Multi-User commands Best Practices

[Buddy Walker]

Doug

   I would only put those in the cfg file. I would set the NAME in RBASE.DAT 
like this

 

   SET VAR vUserName = (CVAL(‘NETUSER’))

   SET NAME &vUserName

 

   I would then make sure the RBASE.DAT AND rbase CFG file were located in same 
folder as the rbase EXE 

   

   Make sure there aren’t any other RBASE.DAT and rbase CFG file located 
anywhere.

 

Buddy

 

 

 

 

From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Sunday, January 30, 2022 10:32 PM
To: R:Base List 
Subject: [RBASE-L] - Multi-User commands Best Practices

 

In the recent R:Base Multi-User Guide, the recommended sequence for Multi-User 
Concurrency Settings in a startup file, e.g. RBASE.DAT, is:
DISCONNECT
SET MULTI ON
SET STATICDB ON
SET FASTLOCK ON
SET PAGELOCK OFF
SET ROWLOCKS ON
SET VERIFY COLUMN
SET WAIT 4
SET INTERVAL 5

The same settings are found in the .CFG file, e.g. RBENGINEX5E.CFG
MULTI   ON
STATICDBON
FASTLOCKON
PAGELOCKOFF
ROWLOCKSON
VERIFY  COLUMN
WAIT   4
INTERVAL   5

Is it correct that:
1) the CFG file is processed before the startup DAT file?
2) The order of the commands in the CFG should be the same as in the DAT file?
3) The SET commands in the DAT file are redundant and are not really necessary 
in the DAT file unless settings need to be changed for special circumstances?

Note that the user Guide states: "The settings may be set within the R:BASE 
configuration file. However, the settings are best set in a
startup file before connecting to the database. For example: ..."

Why are the settings best set in a startup file?  Shouldn't default settings be 
established in the CFG file and modified only if necessary?

TIA,
Doug

 

  _  


  

This email has been checked for viruses by Avast antivirus software. 
www.avast.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/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.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/004901d8169c%24ad391c20%2407ab5460%24%40comcast.net.

RE: [RBASE-L] - How to navigate to a specific table row and display it on a form

[Buddy Walker]

Jim
  I would prefer using DIALOG to get the date then based on date use CHOOSE 
which would return uniqueID for that row. Then EDIT USING formName WHERE 
UniqueID = .vUniqueID 

   If user didn't choose anything then using DIALOG ask  if they want to add a 
row if yes then ENTER USING formName 
   Else exit

Buddy

   

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of James 
Burroughs
Sent: Wednesday, January 26, 2022 9:54 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - How to navigate to a specific table row and display it on 
a form

I have a form which displays columns from a single row of a table.  The user is 
given the option either to enter a new row or to edit an existing row.  If a 
new row, then a blank form is displayed.  If an existing row, then the user 
selects a row from a drop down list based on a date.   My question is how to 
get the form to display the row that was selected?

I've tried the EDIT USING command with a WHERE clause from within an EEP to 
select the desired row and display the information on the form.  This works, 
but opens a new instance of the form.  I'm wondering if there is a better 
approach.

Thanks,

Jim Burroughs

--
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/28f5a21f-85d0-3267-9e30-dd91e86d77c0%40cox.net.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002601d81377%2471849560%24548dc020%24%40comcast.net.

RE: Re[2]: [RBASE-L] - Ampersanding in the Dark

[Buddy Walker]

Bruce

  I believe you are using the & wrong when setting up the string.

 

  To concantenate the string the & indicates a space

   Added vyearStart as integer which I assume is the  4 digit you are setting   

 

  I commented out two variables don’t need them unless you are using them 
elsewhere in the code.

 

  Try this

 

***start here

 

  SET VAR vcol_date TEXT = 'cpoDate'

  SET VAR vtableName TEXT = 'cpoHeader'

  --SET VAR vamp_dateCol_min TEXT = ('(MIN(' + .vcol_date + '))')

  --SET VAR vamp_dateCol_iyr4 TEXT = ('(IYR4(' + .vcol_date + '))')

  SET VAR vyearStart INTEGER = 2020

 

SET VAR vstring TEXT = +

  ('SELECT MIN(' + .vcol_Date + ') INTO vfts_dateStart INDICATOR vind1 FROM' & 
.vtableName & 'WHERE (IYR(' + .vcol_date + ')) =' & CTXT(.vyearStart))

 

  &vstring

 

*end here

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Bruce 
Chitiea
Sent: Friday, December 10, 2021 8:08 PM
To: rbase-l@googlegroups.com
Subject: Re[2]: [RBASE-L] - Ampersanding in the Dark

 

Razzak: Thank you.

 

If I understand your sample, my code should read:

 

  SET VAR vcol_date TEXT = 'cpoDate' 

  SET VAR vtableName TEXT = 'cpoHeader'

  SET VAR vamp_dateCol_min TEXT = ('(MIN(' + .vcol_date + '))')

  SET VAR vamp_dateCol_iyr4 TEXT = ('(IYR4(' + .vcol_date + '))')

 

  SET VAR vstring TEXT = +

  ('SELECT &vamp_dateCol_min INTO vfts_dateStart INDICATOR vind1 FROM' & 
.vtableName & 'WHERE &vamp_dateCol_iyr4 = .vyearStart') 

 

  &vstring

 

...which returns the error: "Column or variable MIN not found (2515)"

 

Perplexing.  But! Progress. By defining the "vamp_" variables in your correct 
syntax (as shown and run above), this code now works:

 

  SELECT &vamp_dateCol_min INTO vfts_dateStart INDICATOR vind1  + 

FROM &vtableName WHERE &vamp_dateCol_iyr4 = .vyearStart

 

Sadly, if I insert this code into parens as the vstring definition, the error: 
"Syntax is incorrect for the command SELECT (2045)" is returned.

 

So, still one level of mystery remains.

 

Best wishes, Bruce

 

Bruce A. Chitiea | SafeSectors, Inc.

112 Harvard Ave #272 | Claremont CA 91711-4716 | USA

rby...@safesectors.com   | +011 (909) 238-9012 c 
| +011 (909) 912-8678 f

 

-- Original Message --

From: "A. Razzak Memon" mailto:raz...@rbase.com> >

To: rbase-l@googlegroups.com  

Sent: 12/10/2021 1:41:19 PM

Subject: Re: [RBASE-L] - Ampersanding in the Dark

 

Bruce,

 

Try this very simple approach to form a command with correct syntax to execute.

 

SET VAR vTableName TEXT = 'cPOHeader'

SET VAR vString TEXT = ('SELECT ... FROM'&.vTableName)

&vString

 

See how the variable "vString" is executed.

 

Have fun!

 

Razzak

 

 

At 04:21 PM 12/10/2021, Bruce Chitiea wrote:

 

Gurus and Gurettes:

 

My greatest coding challenge remains the use of ampersand variables. I get the 
concept, but my execution ... hoo boy.

 

So here's what works:

 

  SELECT (MIN(cpoDate)) INTO vdateStart INDIC vind1 +

   FROM cpoHeader WHERE (IYR4(cpoDate)) = .vyearStart

 

But I need to sub-out the table name, and column name 'cpoDate' with the likes 
of 'invDate', 'shipDate', etc.Â

This does the trick for the column name:

 

  SET VAR vcol_date TEXT = 'cpoDate'

  SET VAR vamp_dateCol_min TEXT = '(MIN(&vcol_date))'

  SET VAR vamp_dateCol_iyr4 TEXT = '(IYR4(&vcol_date))'

 

  SELECT &vamp_dateCol_min INTO vfts_dateStart INDICATOR vind1 +

   FROM cpoHeader WHERE &vamp_dateCol_iyr4 = .vyearStart

 

... but only so long as the literal tablename 'cpoHeader' is included in the 
FROM clause.

 

This returns a syntax error:

  SET VAR vtableName TEXT = 'cpoHeader'

  SELECT ... FROM .vtableName ...

 

... as does this:

  SET VAR vtableName TEXT = 'cpoHeader'

  SELECT ... FROM &vtableName ...

 

... as does this:

  SET VAR vtableName TEXT = 'cpoHeader'

  SET VAR vamp_from_tablename TEXT = 'FROM .vtableName'

  SELECT ... &vamp_from_tableName ...

 

... as does this

  SET VAR vtableName TEXT = 'cpoHeader'

  SET VAR vamp_from_tablename TEXT = 'FROM &vtableName'

  SELECT ... &vamp_from_tableName ...

 

Clearly, I'm flailing. Any assistance much appreciated!Â

Bruce

 

Bruce A. Chitiea |Â SafeSectors, Inc.

112 Harvard Ave #272 |Â Claremont CA 91711-4716 |Â USA

rby...@safesectors.com  Â |Â +011 (909) 238-9012 
c |Â +011 (909) 912-8678 f

 

 

 

 

--

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 v

RE: [RBASE-L] - How to copy from a DBGrid cell?

[Buddy Walker]

Doug
  I haven't tried this but have you tried the GETPROPERTY for the grid

GETPROPERTY  'SELECTEDVALUES[NNN]' 'varname'

Have an variable edit control for the getproperty varname then copy to 
clipboard.

Buddy
 

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Tuesday, October 12, 2021 12:43 AM
To: R:Base List 
Subject: [RBASE-L] - How to copy from a DBGrid cell?

How do I copy a text value from a DBGrid cell to the clipboard?
Equivalent to Ctrl-C so it can be pasted into another window for mainframe 
inquiry.

PROPERTY  COPYTOCLIPBOARD 'SELECTED' only works for  Edit, Memo, 
Image, and Rich Text controls.

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/473b7da7-76f9-b77f-7b49-f9175caaf412%40wi.rr.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/001701d7bf54%245262e550%24f728aff0%24%40comcast.net.

RE: [RBASE-L] - Pre-selected list view/box

[Buddy Walker]

Ok misunderstood I believe Bruce answered your question.

 

From: 'Karen Tellef' via RBASE-L  
Sent: Tuesday, September 7, 2021 5:31 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Pre-selected list view/box

 

I don't need a WHERE clause.

 

My list box is going to show all 10 rows of my lookup table (LstScheduleTypes). 
 I want 3 of those rows to be pre-selected as if the user had just clicked 
them, based on my vST variable with the IDs of the 3 to be highlighted

 

Have you ever had a list box or list view on a form with values pre-selected?  
That's what I'm trying to find out how to do

 

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Sent: Tue, Sep 7, 2021 4:29 pm
Subject: RE: [RBASE-L] - Pre-selected list view/box

Should be .vST not .vStat

 

You could also use that as a WHERE clause

 

 

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Buddy Walker
Sent: Tuesday, September 7, 2021 5:25 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Pre-selected list view/box

 

Karen

  Compare the schedid to variable using IN. Variable would have to have () 
around the values and since they are integer you shouldn’t need quotes around 
each value



   SET VAR vST TEXT = (‘(‘ + .vST + ‘)’)

 

IF SchedID IN .vStat THEN

  X

ELSE

  Y

 ENDIF

 

Buddy

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Tuesday, September 7, 2021 4:05 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Pre-selected list view/box

 

I'm not sure I've tried this before, and I don't have any notes saved on how to 
do it.

 

I want either a variable list view or list box on a form where multiple values 
are pre-selected.  Anyone have code they can share to do this?

 

In my situation, it's a tiny table:

 

LstScheduleTypes

SchedID   (PK integer)

ScheduleType

 

 

I will have a list of the SchedIDs, such as  2, 4, 6

 

The list will show just the schedule types associated with those IDs

 

I have tried having the list box variable pre-defined:

vST TEXT = "2,4,6"

 

vST is the variable associated with my list box, with SchedID as the Key Field, 
and ScheduleType showing as the list, but nothing is pre-selected

 

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

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%2455a0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%2455a0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002e01d7a42f%246181e580%242485b080%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/002e01d7a42f%246181e580%242485b080%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.g

RE: [RBASE-L] - Pre-selected list view/box

[Buddy Walker]

Should be .vST not .vStat

 

You could also use that as a WHERE clause

 

 

 

 

From: rbase-l@googlegroups.com  On Behalf Of Buddy 
Walker
Sent: Tuesday, September 7, 2021 5:25 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Pre-selected list view/box

 

Karen

  Compare the schedid to variable using IN. Variable would have to have () 
around the values and since they are integer you shouldn’t need quotes around 
each value



   SET VAR vST TEXT = (‘(‘ + .vST + ‘)’)

 

IF SchedID IN .vStat THEN

  X

ELSE

  Y

 ENDIF

 

Buddy

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Tuesday, September 7, 2021 4:05 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Pre-selected list view/box

 

I'm not sure I've tried this before, and I don't have any notes saved on how to 
do it.

 

I want either a variable list view or list box on a form where multiple values 
are pre-selected.  Anyone have code they can share to do this?

 

In my situation, it's a tiny table:

 

LstScheduleTypes

SchedID   (PK integer)

ScheduleType

 

 

I will have a list of the SchedIDs, such as  2, 4, 6

 

The list will show just the schedule types associated with those IDs

 

I have tried having the list box variable pre-defined:

vST TEXT = "2,4,6"

 

vST is the variable associated with my list box, with SchedID as the Key Field, 
and ScheduleType showing as the list, but nothing is pre-selected

 

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

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%2455a0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%2455a0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002e01d7a42f%246181e580%242485b080%24%40comcast.net.

RE: [RBASE-L] - Pre-selected list view/box

[Buddy Walker]

Karen

  Compare the schedid to variable using IN. Variable would have to have () 
around the values and since they are integer you shouldn’t need quotes around 
each value



   SET VAR vST TEXT = (‘(‘ + .vST + ‘)’)

 

IF SchedID IN .vStat THEN

  X

ELSE

  Y

 ENDIF

 

Buddy

 

From: 'Karen Tellef' via RBASE-L  
Sent: Tuesday, September 7, 2021 4:05 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Pre-selected list view/box

 

I'm not sure I've tried this before, and I don't have any notes saved on how to 
do it.

 

I want either a variable list view or list box on a form where multiple values 
are pre-selected.  Anyone have code they can share to do this?

 

In my situation, it's a tiny table:

 

LstScheduleTypes

SchedID   (PK integer)

ScheduleType

 

 

I will have a list of the SchedIDs, such as  2, 4, 6

 

The list will show just the schedule types associated with those IDs

 

I have tried having the list box variable pre-defined:

vST TEXT = "2,4,6"

 

vST is the variable associated with my list box, with SchedID as the Key Field, 
and ScheduleType showing as the list, but nothing is pre-selected

 

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/448501553.2840480.1631045115484%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/002101d7a42e%24c71c71e0%2455a0%24%40comcast.net.

RE: [RBASE-L] - Variable Not Defined

[Buddy Walker]

Charles

  Have you tried CHKVAR checks to see if variable name exists

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Charles 
Stevens
Sent: Sunday, September 5, 2021 4:42 PM
To: RBASE-L 
Subject: [RBASE-L] - Variable Not Defined

 

What would be the best way to identify a variable as undefinied in an 
application and exit the routine? I have a reference to vMAXID which may not be 
defined under some circumstances (not just null), and I need to terminate 
processing. I have a SET VAR vMAXID = (IFEQ(.VMAXID,NULL,0,.VMAXID) which 
throws an error message "variable not defined" with an error code of 2515, but 
this seems a rather clumsy way to find the error. Thanks in advance . . . 

-- 
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/de7023d9-a39d-4bdb-a67b-b860f52c6abcn%40googlegroups.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/000c01d7a29e%2472fffaf0%2458fff0d0%24%40comcast.net.

RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

[Buddy Walker]

Javier

  I agree with you. I would sooner do it with one command, that’s I why I 
started out as “if all else fails”. Sometimes the declare cursor is the only 
thing that works .

 

   Happy 4th everyone

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of 
javier.valen...@vtgonline.com
Sent: Saturday, July 3, 2021 4:29 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

 

Buddy,

 

I am using SQL statements more often now where I used Cursors before. Using 
your code, you can combine getting the last character and string length to 
create the condition.

 

SET VAR vColLength = (SLEN(.vColValue))

SET VAR vColLastChar = (SGET(.vColValue,1,.vColLength))

 

 

UPDATE johantab SET kalla2 = (kalla2 + '.') WHERE (SGET(kalla2,1, 
(SLEN(kalla2 <>  ‘.’

 

*Might need to check parentheses 😊

 

Having said that, Karen’s solution:

 

UPDATE johantab SET kalla2 = (kalla2 + '.') WHERE kalla2 NOT LIKE '%.'

 

is more elegant/simpler.

 

It would be interesting to see if one runs faster than the other and I guess it 
would depend on the size of column kalla2, but with a one time update of under 
8,000 records, it is really not relevant.

 

I am currently working with a table with 170,000+ records where the process 
requires a number of updates and the process is run multiple time, so execution 
time is definitely a concern.

 

Javier,

 

Javier Valencia, PE

913-915-3137

 

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Buddy Walker
Sent: Saturday, July 3, 2021 1:53 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

 

Bo

 

If all else fails then try looping through table with declare cursor

 

I’m assuming there could be a dot anywhere in the column but you also need one 
at the end.

 

Buddy

 

---Code Starts Here

 

  SET VAR vColValue TEXT

  SET VAR vColLength INTEGER

  SET VAR vDot = ('.')

 

  DECLARE C1 CURSOR FOR SELECT kalla2 +

FROM SomeTable

  OPEN c1

  FETCH c1 INTO +

vColValue INDICATOR iv1

  WHILE SQLCODE <> 100 THEN

SET VAR vColLength = (SLEN(.vColValue))

SET VAR vColLastChar = (SGET(.vColValue,1,.vColLength))

 

IF vColLastChar <> .vDot THEN

  SET VAR vColValue = (.vColValue + .vDot)

  UPDATE SomeTable SET kalla2 = .vColValue WHERE CURRENT OF C1

ENDIF

 

SET VAR vColLength = 0

SET VAR vColLastChar = NULL

SET VAR vColValue = NULL

 

FETCH c1 INTO +

  vColValue INDICATOR iv1

  ENDWHILE

  DROP CURSOR c1

  CLE VAR vColValue

 

  RETURN--Code Ends Here

 

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of Bo 
Franzén
Sent: Saturday, July 3, 2021 10:43 AM
To: R:BASE mailto:rbase-l@googlegroups.com> >
Subject: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

 

Dear R:BASE!

 

I have a price database (Middle Ages) that is going to be printed in due time. 
A column, källa2, with the (often printed) source in a TEXT FORMAT often lacks 
a dot [.] in the end. How to UPDATE all rows that lack a dot? I have tried:

 

R>UPDATE johantab SET källa2 = LAST LIKE '%.' WHERE källa2 LAST NOT LIKE '%.'

-ERROR- Column källa2 must be a valid TEXT. ( 122)

 

Strange, since källa2 is a TEXT column. Operators change over time. Probably 
I'm behind. One way would be to add a dot to all rows in order to SRPL '..' 
with '.' But that did not work either:

 

R>UPDATE johantab SET källa2 = LAST LIKE '%.'

-ERROR- Column källa2 must be a valid TEXT. ( 122)

 

To UPDATE 7733 columns by hand seems like a terrible waste of time. But, as 
said, I am probably behind.

 

Bo Franzén

Department of Economic History

Stockholm University

 

R>COMPUTE ALL tran_id FROM johantab WHERE källa2 LAST NOT LIKE '%.'

tran_idCount =   7733

   Rows =8008

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/28791a1702b0408da38541b47ad63903%40ekohist.su.se
 
<https://groups.google.com/d/msgid/rbase-l/28791a1702b0408da38541b47ad63903%40ekohist.su.se?utm_medium=email&utm_source=footer>
 .

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

RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

[Buddy Walker]

Bo

If all else fails then try looping through table with declare cursor

 

I’m assuming there could be a dot anywhere in the column but you also need one 
at the end.

 

Buddy

 

---Code Starts Here

 

  SET VAR vColValue TEXT

  SET VAR vColLength INTEGER

  SET VAR vDot = ('.')

 

  DECLARE C1 CURSOR FOR SELECT kalla2 +

FROM SomeTable

  OPEN c1

  FETCH c1 INTO +

vColValue INDICATOR iv1

  WHILE SQLCODE <> 100 THEN

SET VAR vColLength = (SLEN(.vColValue))

SET VAR vColLastChar = (SGET(.vColValue,1,.vColLength))

 

IF vColLastChar <> .vDot THEN

  SET VAR vColValue = (.vColValue + .vDot)

  UPDATE SomeTable SET kalla2 = .vColValue WHERE CURRENT OF C1

ENDIF

 

SET VAR vColLength = 0

SET VAR vColLastChar = NULL

SET VAR vColValue = NULL

 

FETCH c1 INTO +

  vColValue INDICATOR iv1

  ENDWHILE

  DROP CURSOR c1

  CLE VAR vColValue

 

  RETURN--Code Ends Here

 

 

 

From: rbase-l@googlegroups.com  On Behalf Of Bo 
Franzén
Sent: Saturday, July 3, 2021 10:43 AM
To: R:BASE 
Subject: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

 

Dear R:BASE!

 

I have a price database (Middle Ages) that is going to be printed in due time. 
A column, källa2, with the (often printed) source in a TEXT FORMAT often lacks 
a dot [.] in the end. How to UPDATE all rows that lack a dot? I have tried:

 

R>UPDATE johantab SET källa2 = LAST LIKE '%.' WHERE källa2 LAST NOT LIKE '%.'

-ERROR- Column källa2 must be a valid TEXT. ( 122)

 

Strange, since källa2 is a TEXT column. Operators change over time. Probably 
I'm behind. One way would be to add a dot to all rows in order to SRPL '..' 
with '.' But that did not work either:

 

R>UPDATE johantab SET källa2 = LAST LIKE '%.'

-ERROR- Column källa2 must be a valid TEXT. ( 122)

 

To UPDATE 7733 columns by hand seems like a terrible waste of time. But, as 
said, I am probably behind.

 

Bo Franzén

Department of Economic History

Stockholm University

 

R>COMPUTE ALL tran_id FROM johantab WHERE källa2 LAST NOT LIKE '%.'

tran_idCount =   7733

   Rows =8008

 

-- 
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/28791a1702b0408da38541b47ad63903%40ekohist.su.se
 

 .

-- 
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/002201d7703c%24a7a228d0%24f6e67a70%24%40comcast.net.

RE: [RBASE-L] - Increment letters

[Buddy Walker]

Dan

  Try this

 

SET VAR vStart TEXT = ('12345C')

SET VAR vGetNumber TEXT = (SKEEPI(.vStart,'1234567890'))

SET VAR vGetLetter TEXT = (SKEEPI(.vStart,'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))

 

SET VAR vIChar = (ICHAR(.vGetLetter))

SET VAR vNxtChar = (.vIChar + 1)

SET VAR vNxtLetter = (CHAR(.vNxtChar))

 

SET VAR vEnd = (LUC((.vGetNumber + .vNxtLetter)))

 

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Monday, May 17, 2021 4:38 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Increment letters

 

Thx it looks like I need to get up to par on char ☺️

Dan Goldberg

MIS Manager

Lance Campers

 

  _  

From: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> > on behalf of A. 
Razzak Memon mailto:raz...@rbase.com> >
Sent: Monday, May 17, 2021 12:48:20 PM
To: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> >
Subject: Re: [RBASE-L] - Increment letters 

 

Dan,

Here's how ...

You can use the ICHAR function to capture the 
ASCII integer value, increment by 1, then use the 
CHAR function to return the letter value.

(ICHAR(arg))
Converts a single character, returning its corresponding ASCII integer value.

In the following example, the integer value of vichar is 65.
SET VAR vIChar = (ICHAR('A'))

(CHAR(integer))
Converts an ASCII integer value to its 
corresponding character. This is not the same as the CHAR data type.

In the following example, the value of vchar1 is 
A and the value of vchar2 is a.
SET VAR vChar1 = (CHAR(65))
SET VAR vChar2 = (CHAR(97))

Have fun!

Very Best R:egards,

Razzak.


At 03:22 PM 5/17/2021, Dan Goldberg wrote:

>I have a number with a letter suffix.
>
>12345C
>
>I need to increment it to the next letter. So it would be:
>
>12345D
>
>Has anyone done this before? I am drawing a blank…
>
>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/0MclnD-1m0XDw2ALJ-00Hwlr%40mrelay.perfora.net.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/SJ0PR17MB44473CFE4EBB78E632384BDAAA2D9%40SJ0PR17MB4447.namprd17.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/003401d74b60%24be26b3b0%243a741b10%24%40comcast.net.

Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid

[Buddy Walker]

Myron

   Maybe I’m missing something but is there a reason you want the format saved 
in the table.  Since it is easy to format in forms and reports. I would store 
the number as integer. This way only numbers would be stored. 

Buddy

Sent from my iPhone

> On Apr 7, 2021, at 12:01 PM, Myron  wrote:
> 
> 
> Tony,
>  
> From the top menu bar select tables (the main menu bar not the form designer 
> one.
> Select display format apply the format to your column
>  
> Tried that too.
> The only format options I have would be to format columns that are ‘date and 
> ‘integer’ not text.
> So, the question becomes: Is there a way to add a text column to the drop 
> down? Then can the column data field be formatted as a phone number?
>  
> Myron
>  
> From: rbase-l@googlegroups.com  On Behalf Of Tony 
> Luck
> Sent: April 6, 2021 6:07 PM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid
>  
> Myron,
>  
> Open your form in the form designed. From the top menu bar select tables (the 
> main menu bar not the form designer one.
> Select display format apply the format to your column
> the format will apply to the  column in the grid when you display data
>  
> On Wed, Apr 7, 2021 at 10:43 AM Bruce Chitiea  wrote:
> Myron:
>  
> Assuming you may have already been to:
>  
> rbase.com/support/rsyntax/rbgx5
>  
> Type "mask" into the search control. The first item throws up "Using Format 
> Masks in Forms."
>  
> You'll find an example within DB Edit Properties. May be a short leap to the 
> Enhanced DB Grid.
>  
> Best, Bruce
>  
> Bruce A. Chitiea | SafeSectors, Inc.
> 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
> rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f
>  
>  
> -- Original Message --
> From: "Myron" 
> To: rbase-l@googlegroups.com
> Sent: 4/6/2021 3:38:15 PM
> Subject: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid
>  
> I am using an Enhanced DB Grid in a form
> One of the columns holds phone numbers in a text format
> So, it looks like 6233226333
> How do I apply a phone number format to the column?
> Something like: !\(999\)\ 000\-;0; or anything that works
> Stumped.
> Thanks.
> Myron Finegold, Arizona
>  
> -- 
> 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/01d72b35%2489718be0%249c54a3a0%24%40gmail.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/emf145d7a9-4527-4ca0-81aa-934ab39cd287%40pathfinder.
> 
>  
> --
> Regards
> Tony
> -- 
> 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/CABnhDASz%3D4eER7SfKxO%2BJ3DNH1rewhQWAWq91D5%2BUDDxhMR4Pw%40mail.gmail.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/00e801d72bc7%243664f030%24a32ed090%24%40gmail.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/B267F3DE-3ED7-419F-8674-EBDB7475743B%40comcast.net.

Re: [RBASE-L] - Date Conversion

[Buddy Walker]

Don’t use the () around the text 

Buddy

Sent from my iPhone

> On Mar 27, 2021, at 5:50 PM, BILL MILYARD  wrote:
> 
> 
> Razzak:
> Thanks for you quick response.  You're going to think I've lost my mind.  I 
> explained it backwards I want to convert a text to a date.  
> 
> vDate is TEXT and
> vServiceDate is DATE
> set var vServiceDate = (.vDate)
> 
> Sorry, Bill
> 
> 
> 
> From: rbase-l@googlegroups.com  on behalf of A. 
> Razzak Memon 
> Sent: Saturday, March 27, 2021 4:45 PM
> To: rbase-l@googlegroups.com 
> Subject: Re: [RBASE-L] - Date Conversion
>  
> Bill,
> 
> Here's how:
> 
> SET VAR vServiceDate TEXT = NULL
> SET VAR vServiceDate = (CTXT(.vDate))
> 
> That's all there is to it!
> 
> Very Best R:egards,
> 
> Razzak
> 
> 
> At 04:30 PM 3/27/2021, bmilyard wrote:
> 
> >This should be easy but for some reason I can't get it to work.  I 
> >need to convert a date variable to a text variable.  In my program 
> >I'm setting a date to a text variable as:
> >
> >set var vServiceDate = (.vDate)
> >vServiceDate is a TEXT type and
> >vDate is a DATE type
> >
> >I've tried several Conversion, Date and String functions but none 
> >work.  I know I've done it in the past but can't hit on a 
> >solution.  What am I doing wrong?
> >Bill
> 
> -- 
> 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/0LfCve-1m1WV7166q-00olZl%40mrelay.perfora.net.
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/BLAPR10MB5345597A4A13CB1E5E84F514CB609%40BLAPR10MB5345.namprd10.prod.outlook.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/32DB3AF0-6E74-4320-94F9-A0808404EF94%40comcast.net.

RE: [RBASE-L] - new to drag and drop

[Buddy Walker]

You should be able to set a variable for the uniqueID row you click on. Then 
right your code as to what you want it to do

 

 

 

From: 'Jim Belisle' via RBASE-L  
Sent: Monday, January 18, 2021 5:42 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - new to drag and drop

 

I have that part, Buddy. I just do not know how (code wise) the row is grabbed. 
Some code has to be able to distinguish one row from the others. That is where 
I am stuck. I do not see a PROPERTY command that helps me identify a specific 
row in the DBGrid.

 

James Belisle

 

Making Information Systems People Friendly Since 1990



 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Buddy Walker
Sent: Monday, January 18, 2021 4:38 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - new to drag and drop

 


CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links 
or opening attachments. 

Jim

   Right click on DBGrid then enable Drag and Drop should be near the bottom. 
You will see Start Drag (EEP) and Drop Drag (EEP) 

Buddy

 

From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, January 18, 2021 5:05 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - new to drag and drop

 

I am new to drag and drop so not sure how to “GRAB” a row from a DBGrid.

The DBGrid is in the row select mode so I can grab a row. 

Also the record count on the left is on so I have the row number.

How does one identify the specific row you want to grab? 

In RDOCS I do not find a PROPERTY command to grab the record number of a row.

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB6821ED4691F176CAAA1B22FDA0A40%40CH2PR02MB6821.namprd02.prod.outlook.com
 
<https://groups.google.com/d/msgid/rbase-l/CH2PR02MB6821ED4691F176CAAA1B22FDA0A40%40CH2PR02MB6821.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB68214D59477F2F7AA282476FA0A40%40CH2PR02MB6821.namprd02.prod.outlook.com
 
<https://groups.google.com/d/msgid/rbase-l/CH2PR02MB68214D59477F2F7AA282476FA0A40%40CH2PR02MB6821.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001201d6edec%249c94a3a0%24d5bdeae0%24%40comcast.net.

RE: [RBASE-L] - new to drag and drop

[Buddy Walker]

Jim

   Right click on DBGrid then enable Drag and Drop should be near the bottom. 
You will see Start Drag (EEP) and Drop Drag (EEP) 

Buddy

 

From: 'Jim Belisle' via RBASE-L  
Sent: Monday, January 18, 2021 5:05 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - new to drag and drop

 

I am new to drag and drop so not sure how to “GRAB” a row from a DBGrid.

The DBGrid is in the row select mode so I can grab a row. 

Also the record count on the left is on so I have the row number.

How does one identify the specific row you want to grab? 

In RDOCS I do not find a PROPERTY command to grab the record number of a row.

 

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/CH2PR02MB6821ED4691F176CAAA1B22FDA0A40%40CH2PR02MB6821.namprd02.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000601d6edea%249c682750%24d53875f0%24%40comcast.net.

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

[Buddy Walker]

Dan

  You could create another column newTimeCol and set it to time 

 

  UPDATE table SET newTimeCol = oldTextCol 

 

   This should work as long as each row has AM or PM in it

 

   You could also just change the column from text to time. This may caused 
problems with reports/forms etc.

 

Buddy

  

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Wednesday, January 13, 2021 9:58 AM
To: 'rbase-l@googlegroups.com' 
Subject: [RBASE-L] - convert text to time data type

 

I have a text field that a user selects from for each hour. 

 

8:00 AM

9:00 AM

10:00 AM

….

 

I need to convert that to a time format so I can use it in calculations. I do 
not see a function to do so. Anyone know how I can convert it?

 

TIA

 

Dan Goldberg

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A21FB%40EXCHANGE10
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000d01d6e9be%24865abd40%24931037c0%24%40comcast.net.

Re: [RBASE-L] - Report output to Excel

[Buddy Walker]

Karen
   What I have done in the past was to open Notepad then highlight the column 
of numbers and cut and paste them into Notepad. Highlight and copy them from 
Notepad paste them back to Excel column. 

Buddy

Sent from my iPhone

> On Dec 29, 2020, at 10:24 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> 
> Tony:  I've seen those green markers before, but in this case (I'll repeat my 
> print-screen here) for some reason there is no green marker on these cells.  
> Yet my =SUM still isn't working.
> 
> 
> 
> 
> Here's my sum below:
> 
> 
> If I type a "2" over one of those 1s, the sum shows 2:
> 
> 
> 
> Karen
> 
> 
> 
> 
> -Original Message-
> From: Tony IJntema 
> To: rbase-l@googlegroups.com
> Sent: Tue, Dec 29, 2020 9:15 am
> Subject: Re: [RBASE-L] - Report output to Excel
> 
> Karen,
> You can do it this way:
> 
> Select all figures you like to convert (the green marker up left is showing 
> that the number is stored as text)
> Select the exclamation mark and then a right mouse click
> You should see the menu as below (sorry in Dutch)
> 
> The second option is convert to number.
> Hope this helps.
> 
> Tony
> 
> 
> 
> Op 29-12-2020 om 15:35 schreef apstock:
>> Karen,
>> Highlight the cell you want to convert to numbers. To the left of the top 
>> most cell there will be an excel symbol which one can select to change the 
>> formatting of the highlighted cell.
>>  
>> 
>> On 12/29/2020 9:19 AM, 'Karen Tellef' via RBASE-L wrote:
>>> Steve:  can you do a print-screen of that?  I've highlighted the numbers 
>>> and cannot find the option box that you're talking about (perhaps we're on 
>>> different versions).  Since the list allows pics now, post the print-screen 
>>> to the list in case someone else can use this very helpful tip!
>>> 
>>> 
>>> Karen
>>> 
>>> 
>>> 
>>> -Original Message-
>>> From: Steve Johnson 
>>> To: rbase-l@googlegroups.com
>>> Sent: Mon, Dec 28, 2020 8:28 pm
>>> Subject: RE: [RBASE-L] - Report output to Excel
>>> 
>>> Karen,
>>>  
>>> You have to convert the column numbers displayed (which are in text format) 
>>> to numbers. Formatting the cells using the format option does not work. 
>>>  
>>> Highlight the range of column cells (not the header) and  to the left of 
>>> the top cell in the option box, (looks like a small diamond with an ! 
>>> point), choose convert to number and it will work.  I have monthly reports 
>>> where I have to do the same thing. 
>>>  
>>> One thing to note, if your spreadsheet is more than one page and the 
>>> columns shift, particularly on a subsequent page, tinker with the report 
>>> object placement for the range of cells that moved.  I also usually have 
>>> blank rows of cells from the page break that have to be trimmed off using 
>>> ‘delete row cells’ in Excel.  Then the columns are contiguous and then I 
>>> convert (or the staff does) the range of cells within a column to a number 
>>> so they can use the =sum formula as needed.
>>>  
>>> Steve Johnson
>>>  
>>> From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] 
>>> Sent: Monday, December 28, 2020 5:45 PM
>>> To: rbase-l@googlegroups.com
>>> Subject: [RBASE-L] - Report output to Excel
>>>  
>>> Haven't played around with this in a while, but someone requested 
>>> instructions.
>>>  
>>> If I have a report to the screen and do a "print to file" picking Excel 
>>> (either 2003 or xlsx), it formats pretty well.  If I bring up Excel and 
>>> want to insert a sum by using the =SUM() it shows up as 0.  If I do 
>>> each individually as a cell (such as:  +A1+A2+A3) then it adds up the 
>>> numbers, but not when I do a =SUM.   Obviously using the + isn't good if I 
>>> want to add up hundreds of lines.  Is this an Excel issue?   I tried a 
>>> couple things:
>>>  
>>> 1.  I left my =SUM in the spreadsheet.  If I type over any of the numbers, 
>>> my sum works (but only on the numbers that I typed over)
>>>  
>>> 2.  If I highlight some of the column of numbers and "format cells" and 
>>> change it, it doesn't work.  For example, I had a column of integers and 
>>> did a "format cells" to change it to a number with 2 decimals, and it 
>>> leaves the column untouched.
>>>  
>>> Other individual calculations work (such as   +B1/A1)   just not the =SUM.
>>>  
>>> Anyone getting that to work?
>>>  
>>>  
>>>  
>>> 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/397078517.3912595.1609195474881%40mail.yahoo.com.
>>> -- 
>>> For group guidelines, visit 
>>> http://www.rbase.com/support/usersgroup_guidelines.php
>>> --- 
>>> You received this message because you are subscri

Re: [RBASE-L] - drag and drop

[Buddy Walker]

Jim
  The the way I look at is you have drag and drop EEPs. When you grab (drag) 
write your rep for that for example delete row from a specific table the when 
you drop code to add to a table. 

Buddy

Sent from my iPhone

> On Dec 23, 2020, at 10:21 AM, 'Jim Belisle' via RBASE-L 
>  wrote:
> 
> 
> I have a couple of questions about drag and drop. I have never used this 
> feature.
> Can you drag and drop between tables if both tables are associated on the 
> same form? Or can you only drag within one table?
> I have read the instructions on Drag and Drop but do not understand what code 
> I would use in each part, On start drag, on drag drop.
>  
> 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/CY4PR0201MB3394F03F2DD0F9187B34B574A0DE0%40CY4PR0201MB3394.namprd02.prod.outlook.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/04441C55-3ADE-46A3-9B2F-02945219DE8F%40comcast.net.

RE: [RBASE-L] - rmail anomaly

[Buddy Walker]

Karen

  I thought about that as well but thought maybe they are using a different one 
for invoices 

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, December 7, 2020 1:50 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - rmail anomaly

 

Buddy:  but if the user/password changed on the server, then all his programs 
would fail, not just this one

 

Jim:  You don't have user/PW hard-coded into the RMail code, do you?  Assume 
you use just the one CFG file?

 

Karen

 

 

-Original Message-----
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Sent: Mon, Dec 7, 2020 12:38 pm
Subject: RE: [RBASE-L] - rmail anomaly

Jim

  I would think the user and/or password you are using to send from your 
applications has changed on the outlook server 

 

Buddy

 

From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 7, 2020 1:08 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - rmail anomaly

 

We use RMAIL X5 and we installed the latest update. 

All has been going well. Then we ran into a glitch on Friday of last week, but 
ONLY for ONE area of my application.

When doing the invoicing and trying to send the invoices out using the RMAIL, I 
got this error.



 

As far as I know, no other area within RBASE have my users had this problem 
when sending emails. 

Only with the invoicing. I have not touched the invoicing code within my app in 
quite some time. 

The pdf files go to the same location outside of RBASE as they have always gone.

 

Anybody have any blues clues for me to check on?

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394024A526D2001C1F0735AA0CE0%40CY4PR0201MB3394.namprd02.prod.outlook.com
 
<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394024A526D2001C1F0735AA0CE0%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d6ccc8%24201d6090%24605821b0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/000401d6ccc8%24201d6090%24605821b0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1874866159.4571820.1607366992898%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/1874866159.4571820.1607366992898%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d6cccb%2430b983e0%24922c8ba0%24%40comcast.net.

RE: [RBASE-L] - rmail anomaly

[Buddy Walker]

Jim

  I would think the user and/or password you are using to send from your 
applications has changed on the outlook server 

 

Buddy

 

From: 'Jim Belisle' via RBASE-L  
Sent: Monday, December 7, 2020 1:08 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - rmail anomaly

 

We use RMAIL X5 and we installed the latest update. 

All has been going well. Then we ran into a glitch on Friday of last week, but 
ONLY for ONE area of my application.

When doing the invoicing and trying to send the invoices out using the RMAIL, I 
got this error.



 

As far as I know, no other area within RBASE have my users had this problem 
when sending emails. 

Only with the invoicing. I have not touched the invoicing code within my app in 
quite some time. 

The pdf files go to the same location outside of RBASE as they have always gone.

 

Anybody have any blues clues for me to check on?

 

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/CY4PR0201MB3394024A526D2001C1F0735AA0CE0%40CY4PR0201MB3394.namprd02.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d6ccc8%24201d6090%24605821b0%24%40comcast.net.

RE: [RBASE-L] - VB: Problem with R>AUTOCHK FULL

[Buddy Walker]

Bo

  Normally a reload does it all it (structure, index and data)

 

  Make a copy of the 

 

   COPY OriginalDataBase.RX? to DataBaseCopy.RX?

 

  Connect to DataBaseCopy

 

   RELOAD DataBaseReloaded

 

   DISCONNECT

 

   CONNECT DataBaseReloaded 

 

   AUTOCHK full

 

   DISCONNECT

 

   If all checks out ok then RENAME OriginalDatabase.RX?  to 
SomethingDataBase.RX? then RENAME DataBaseReloaded.RX? to OriginalDataBase,RX?

 

Buddy

 

 

 

 

From: rbase-l@googlegroups.com  On Behalf Of Bo 
Franzén
Sent: Sunday, November 8, 2020 7:13 AM
To: rbase-l@googlegroups.com
Subject: SV: [RBASE-L] - VB: Problem with R>AUTOCHK FULL

 

Yeas, but I only got the structure of my base, no rows. Have not used the 
RELOAD command for many years.

Y s

Bo Franzén

  _  

Från: rbase-l@googlegroups.com mailto:rbase-l@googlegroups.com> > för Buddy Walker mailto:walker.bu...@comcast.net> >
Skickat: den 7 november 2020 23:11:40
Till: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Ämne: Re: [RBASE-L] - VB: Problem with R>AUTOCHK FULL 

 

Bo

  Have you tried reloading the data base 

Buddy

 

Sent from my iPhone





On Nov 7, 2020, at 2:53 PM, Bo Franzén mailto:bo.fran...@ekohist.su.se> > wrote:

 

 

 


  _  


Från: Bo Franzén
Skickat: den 7 november 2020 20:48
Till: RBASE-L Mailing List
Ämne: Problem with R>AUTOCHK FULL 

 

Dear R:BASE,

 

Hello Pennsylvania, the world has been watching you!

 

Well, I have a database partly started alredy in the mid 1990s. The R>PACK 
command works fine but the R>AUTOCHK FULL does not. After a few seconds there 
are countless error messages concerning a unique primary key in the table HK. 
That table was once created from another base with the help of Gunnar Ekblad 
here in Sweden with the expression (int(Brevnummer)), i.e. that it made an 
INTEGER column from a TEXT column. The error messages never end, so I have to 
go to the the activity manager and stop the program. This is not a big issue 
for me but what would the remedy be?

 

Y s

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/0ae75b34c4b648bc80e812e44b53169d%40ekohist.su.se
 
<https://groups.google.com/d/msgid/rbase-l/0ae75b34c4b648bc80e812e44b53169d%40ekohist.su.se?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/3629-36F6-4A36-BEC0-5A74AE984659%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/3629-36F6-4A36-BEC0-5A74AE984659%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/fe3a18d5788a422381bfe602ded65349%40ekohist.su.se
 
<https://groups.google.com/d/msgid/rbase-l/fe3a18d5788a422381bfe602ded65349%40ekohist.su.se?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000901d6b5ce%24ebe3e5c0%24c3abb140%24%40comcast.net.

Re: [RBASE-L] - VB: Problem with R>AUTOCHK FULL

[Buddy Walker]

Bo
  Have you tried reloading the data base 
Buddy


Sent from my iPhone

> On Nov 7, 2020, at 2:53 PM, Bo Franzén  wrote:
> 
> 
> 
> 
> 
> 
> Från: Bo Franzén
> Skickat: den 7 november 2020 20:48
> Till: RBASE-L Mailing List
> Ämne: Problem with R>AUTOCHK FULL
>  
> Dear R:BASE,
> 
> 
> 
> Hello Pennsylvania, the world has been watching you!
> 
> 
> 
> Well, I have a database partly started alredy in the mid 1990s. The R>PACK 
> command works fine but the R>AUTOCHK FULL does not. After a few seconds there 
> are countless error messages concerning a unique primary key in the table HK. 
> That table was once created from another base with the help of Gunnar Ekblad 
> here in Sweden with the expression (int(Brevnummer)), i.e. that it made an 
> INTEGER column from a TEXT column. The error messages never end, so I have to 
> go to the the activity manager and stop the program. This is not a big issue 
> for me but what would the remedy be?
> 
> 
> 
> Y s
> 
> 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.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/0ae75b34c4b648bc80e812e44b53169d%40ekohist.su.se.

-- 
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/3629-36F6-4A36-BEC0-5A74AE984659%40comcast.net.

RE: [RBASE-L] - PDF form generation problems

[Buddy Walker]

Patti

  Create a form that you could use to update each text field in the table.

 

In your report create variable 

Now in your variables add vTxtField = columnName in report table and make sure 
it is calulcated in detail section

 

Buddy

 

 

From: 'Patti Jakusz' via RBASE-L  
Sent: Monday, October 26, 2020 12:05 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - PDF form generation problems

 

There is only one PDF text field per row in the table.  How would I give it a 
different name for each row in the table?

 

On Sunday, October 25, 2020, 3:02:25 AM EDT, Tony IJntema mailto:t.ijnt...@cio-bv.nl> > wrote: 

 

 

Patti,

It looks like the fields have the fieldsame name.

For instance if a field has the name: Cliuentname and you fill it with the name 
Smith als the fields with the fieldname Clientname will be filled with Smith

Tony

 

Op 25-10-2020 om 00:41 schreef 'Patti Jakusz' via RBASE-L:

No, it is blank, a PDF Text field. It is in the detail section.  Users download 
the PDF report and are supposed to be able to fill in the field.  but when they 
fill it in for one client, it duplicates itself for all the clients.

 

Patti

 

On Saturday, October 24, 2020, 10:20:28 AM EDT, Buddy Walker  
<mailto:walker.bu...@comcast.net>  wrote: 

 

 

Patti

  How is the variable being populated. Look up from another table, column in 
report table.

 

  If it is being looked up in another table make sure it is being done in the 
detail section.

 

Buddy

 

 

From: 'Patti Jakusz' via RBASE-L  <mailto:rbase-l@googlegroups.com> 
 
Sent: Friday, October 23, 2020 3:36 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - PDF form generation problems

 

It's in the Detail band.

 

Patti

 

On Friday, October 23, 2020, 3:27:04 PM EDT, Buddy Walker 
mailto:walker.bu...@comcast.net> > wrote: 

 

 

Patti

   What band is the date in (PH, D etc) and when the variable is being created 
in what band

 

Buddy

 

From: 'Patti Jakusz' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Friday, October 23, 2020 2:09 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> ; RBASE-L 
mailto:rbas...@rbase.com> >
Subject: [RBASE-L] - PDF form generation problems

 

Hello all,

 

We are having a hard time editing PDF reports that were geneated by Rbase.  I 
have a PDF Text Field and a bunch of PDF check box fields.

 

When we type a date in the text field, it duplicates itself across all the rows 
in the report.  The check boxes work just fine.  But my text fields all 
duplicate.  I sent a snip of the report, cutting off the client names.  

 

We sometimes were able to open the reports in Word and got them to work that 
way, some of the reports (like this one) get completely scrambled by Word.   We 
tried opening using Adobe, edge Browser, Chrome browser, Firefox browser and 
Word.

 

Any suggestions to get to be able to use this as write-able document?

 

Thanks, Patti

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1037862288.2082633.1603476516423%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/1037862288.2082633.1603476516423%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001e01d6a972%246c3c37e0%2444b4a7a0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/001e01d6a972%246c3c37e0%2444b4a7a0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/117199760.2112879.1603481742569%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/117199760.2112879.1603481742569%40mail.yahoo.com?utm_medium

RE: [RBASE-L] - PDF form generation problems

[Buddy Walker]

Patti

  How is the variable being populated. Look up from another table, column in 
report table.

 

  If it is being looked up in another table make sure it is being done in the 
detail section.

 

Buddy

 

 

From: 'Patti Jakusz' via RBASE-L  
Sent: Friday, October 23, 2020 3:36 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - PDF form generation problems

 

It's in the Detail band.

 

Patti

 

On Friday, October 23, 2020, 3:27:04 PM EDT, Buddy Walker 
mailto:walker.bu...@comcast.net> > wrote: 

 

 

Patti

   What band is the date in (PH, D etc) and when the variable is being created 
in what band

 

Buddy

 

From: 'Patti Jakusz' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Friday, October 23, 2020 2:09 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> ; RBASE-L 
mailto:rbas...@rbase.com> >
Subject: [RBASE-L] - PDF form generation problems

 

Hello all,

 

We are having a hard time editing PDF reports that were geneated by Rbase.  I 
have a PDF Text Field and a bunch of PDF check box fields.

 

When we type a date in the text field, it duplicates itself across all the rows 
in the report.  The check boxes work just fine.  But my text fields all 
duplicate.  I sent a snip of the report, cutting off the client names.  

 

We sometimes were able to open the reports in Word and got them to work that 
way, some of the reports (like this one) get completely scrambled by Word.   We 
tried opening using Adobe, edge Browser, Chrome browser, Firefox browser and 
Word.

 

Any suggestions to get to be able to use this as write-able document?

 

Thanks, Patti

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1037862288.2082633.1603476516423%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/1037862288.2082633.1603476516423%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001e01d6a972%246c3c37e0%2444b4a7a0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/001e01d6a972%246c3c37e0%2444b4a7a0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/117199760.2112879.1603481742569%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/117199760.2112879.1603481742569%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/003201d6aa10%24cb083640%246118a2c0%24%40comcast.net.

RE: [RBASE-L] - PDF form generation problems

[Buddy Walker]

Patti

   What band is the date in (PH, D etc) and when the variable is being created 
in what band

 

Buddy

 

From: 'Patti Jakusz' via RBASE-L  
Sent: Friday, October 23, 2020 2:09 PM
To: rbase-l@googlegroups.com; RBASE-L 
Subject: [RBASE-L] - PDF form generation problems

 

Hello all,

 

We are having a hard time editing PDF reports that were geneated by Rbase.  I 
have a PDF Text Field and a bunch of PDF check box fields.

 

When we type a date in the text field, it duplicates itself across all the rows 
in the report.  The check boxes work just fine.  But my text fields all 
duplicate.  I sent a snip of the report, cutting off the client names.  

 

We sometimes were able to open the reports in Word and got them to work that 
way, some of the reports (like this one) get completely scrambled by Word.   We 
tried opening using Adobe, edge Browser, Chrome browser, Firefox browser and 
Word.

 

Any suggestions to get to be able to use this as write-able document?

 

Thanks, Patti

-- 
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/1037862288.2082633.1603476516423%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/001e01d6a972%246c3c37e0%2444b4a7a0%24%40comcast.net.

RE: [RBASE-L] - using choose in where clause

[Buddy Walker]

Dan

  I wanted to mention that if your selections contain spaces it may break. If 
possible I would return a unique ID from the choose process.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Buddy 
Walker
Sent: Friday, October 16, 2020 1:20 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using choose in where clause

 

Dan

   I believe what you need to do once selection is made is to enclose the 
vpartprefix open and close paren and then use the & instead of the .

 

  SET VAR vpartprefix = (‘(‘ + .vpartprefix + ‘)’)

EDIT USI FormName WHERE colname IN &vpartprefix

 

Buddy

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of Dan 
Goldberg
Sent: Friday, October 16, 2020 10:49 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - using choose in where clause

 

For some reason I cannot remember on how to do this properly. Maybe Friday 
blanking out for me.

 

I have a choose command that has multiple item selection.

 

I want to use that multiple selection in a where clause

 

My commands are:

 

CHOOSE vpartprefix FROM #VALUES FOR (partprefix&'-'&descript),partprefix +

   FROM masterindex +

   ORDER BY partprefix CHKBOX 10 TITLE 'Pick List' +

   CAPTION 'Select Up to 10 items' LINES 15 FORMATTED OPTION +

   LIST_FONT_SIZE 24 | TITLE_FONT_SIZE 20

 

Edit Using Formname where columnname in (.vpartprefix)

 

 

 

If I select one item it works fine. But if I select more that one item then it 
says no rows exist.

 

Does anyone know what I am doing wrong?

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E62CAD7%40EXCHANGE10
 
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E62CAD7%40EXCHANGE10?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002301d6a3e0%24886ec190%24994c44b0%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/002301d6a3e0%24886ec190%24994c44b0%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002a01d6a3e1%24baf9a3e0%2430eceba0%24%40comcast.net.

RE: [RBASE-L] - using choose in where clause

[Buddy Walker]

Dan

   I believe what you need to do once selection is made is to enclose the 
vpartprefix open and close paren and then use the & instead of the .

 

  SET VAR vpartprefix = (‘(‘ + .vpartprefix + ‘)’)

EDIT USI FormName WHERE colname IN &vpartprefix

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Friday, October 16, 2020 10:49 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - using choose in where clause

 

For some reason I cannot remember on how to do this properly. Maybe Friday 
blanking out for me.

 

I have a choose command that has multiple item selection.

 

I want to use that multiple selection in a where clause

 

My commands are:

 

CHOOSE vpartprefix FROM #VALUES FOR (partprefix&'-'&descript),partprefix +

   FROM masterindex +

   ORDER BY partprefix CHKBOX 10 TITLE 'Pick List' +

   CAPTION 'Select Up to 10 items' LINES 15 FORMATTED OPTION +

   LIST_FONT_SIZE 24 | TITLE_FONT_SIZE 20

 

Edit Using Formname where columnname in (.vpartprefix)

 

 

 

If I select one item it works fine. But if I select more that one item then it 
says no rows exist.

 

Does anyone know what I am doing wrong?

 

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/2E4830CEC16615458329D3D83342F8D0014E62CAD7%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/002301d6a3e0%24886ec190%24994c44b0%24%40comcast.net.

RE: [RBASE-L] - Debug command while in application

[Buddy Walker]

Jim

 

You may want to check before adding parts to the TO location to make sure it 
doesn’t already exist. As to the cause it almost seems like a USER maybe 
exiting R:Base without letting the code to complete or it could be a certain 
work station is losing connection.

 

Buddy 

 

From: 'Jim Belisle' via RBASE-L  
Sent: Thursday, September 10, 2020 8:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Debug command while in application

 

I use the TRACE command quite regularly while in the explorer mode to test my 
EEPs, etc.

I have not used the DEBUG command within an application while an application is 
being used.

 

We have a form that was working fine for years until about five months ago. 

Now it inconsistently does not perform properly. It is a simple part movement 
form that is most of the time a two part system of a FROM and TO.

The user is taking parts FROM a specific location and then putting the parts TO 
a location. 

The code populates what I call the raw movements table but also updates a part 
location table.

 

Here is the problem. 

Every once in a while the FROM or TO part movement will duplicate (I end up 
with two entries in the raw movement table).

PLUS the code that updates the part location table does not fire so no update 
takes place. There seems to be no consistent circumstances I can point to that 
causes this to happen. 

 

No errors come up when this anomaly happens. 

Any blues clues as to if a DEBUG is what I should use in the application to 
figure this out? 

 

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/CY4PR0201MB3394923B6E454E5FD40A8A7BA0240%40CY4PR0201MB3394.namprd02.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001c01d6882e%24212e6490%24638b2db0%24%40comcast.net.

RE: [RBASE-L] - Enhanced Variable calendar

[Buddy Walker]

Karen

 

   Place a radio group on form asking if optional date is needed I would set NO 
as the default selection.

 

  In the After FORM Start EEP you would have

  PROPERTY OptCalEnhCal ENABLED ‘FALSE’

 Or

  PROPERTY OptCalEnhCal VISIBLE ‘FALSE’

 

 

 

You could also use VISIBLE true or false for the optional calendar

 

On Change for radio group check for Yes or No

 

If Yes then ENABLE Optional Calendar else leave ENABLED FALSE

 

 

Buddy 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Saturday, August 29, 2020 1:47 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Enhanced Variable calendar

 

They are two different variables, and they are initialized to null when the 
form comes up

 

Karen

 

 

 

-Original Message-
From: Bruce Chitiea 
To: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> >
Sent: Sat, Aug 29, 2020 12:26 pm
Subject: Re: [RBASE-L] - Enhanced Variable calendar

Unique variables for the two dates? 

 

e.g.

 

vplanningDate_required

vplanningDate_optional

 

Hi there, Bruce

 

Bruce A. Chitiea 

SafeSectors, Inc.

---

112 Harvard Ave #272

Claremont CA 91711-4716

---

rby...@safesectors.com  

---

+011 (909) 238-9012 c

+011 (909) 912-8678 f

 

 

-- Original Message --

From: "'Karen Tellef' via RBASE-L" mailto:rbase-l@googlegroups.com> >

To: "rbase-l@googlegroups.com  " 
mailto:rbase-l@googlegroups.com> >

Sent: 8/29/2020 9:01:24 AM

Subject: [RBASE-L] - Enhanced Variable calendar

 

Am I missing a setting on this control?  I have a form come up where the user 
is required to select one date, but the 2nd date is optional.  "Today" comes up 
highlighted on both calendars, and my users are confused because they think the 
date is "selected" for the optional 2nd date.  They try to click it off and 
can't, and end up inadvertently selecting a 2nd date.

 

Is there a setting so that "today" is not highlighted?



 

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/1365544910.150661.1598716884219%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/em94f4e437-2657-4c03-a780-fd1f5c22b846%40pathfinder
 

 .

-- 
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/1591922185.165120.1598723221452%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/002701d67ec7%24d0612f30%2471238d90%24%40comcast.net.

Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs.

[Buddy Walker]

Instead of using SETFOCUS why not use SKIP TO this would be the same as TAB. I 
would still RECALC VAR before the Skip To


Sent from my iPhone

> On Jul 5, 2020, at 8:12 PM, Bruce Chitiea  wrote:
> 
> 
> Thank you, Buddy. On closer inspection, after I sent my message, I TRACED the 
> variable subset as its values were NULLed just before the SETFOCUS.
> 
> The RECALC VAR has no effect on this:
> 
> What is in fact happening is that the DISPLAY of those variable values is not 
> being cleared from their Variable Edit controls during the rotation.
> 
> But when I Tab away from the first control in the Tab Order [a Variable Radio 
> Group - one of the retained values ], the VE controls for the NULLed 
> variables go blank, as intended.
> 
> So the real question is: How does one blank the display of now-NULLed 
> previous values within their associated controls? 
> 
> Much appreciated!
> 
> Bruce A. Chitiea
> SafeSectors, Inc.
> ---
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> ---
> rby...@safesectors.com
> ---
> +011 (909) 238-9012 c
> +011 (909) 912-8678 f
> 
> 
> -- Original Message --
> From: "Buddy Walker" 
> To: rbase-l@googlegroups.com
> Sent: 7/5/2020 4:43:38 PM
> Subject: Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs.
> 
>> Bruce
>>   Have you tried RECALC VAR after settling them to null and before the 
>> setfocus
>> 
>> Buddy
>> 
>> Sent from my iPhone
>> 
>>>> On Jul 5, 2020, at 6:24 PM, Bruce Chitiea  wrote:
>>>> 
>>> 
>>> RGBX5E Current
>>> 
>>> Fairly new to Forms.
>>> 
>>> A Variable Form provides values to an On Click EEP in a Bit Button. The EEP 
>>> succeeds at its tasks, then returns FOCUS to the first control in the 
>>> Form's Tab Order, as intended.
>>> 
>>> One subset of variable values survive the rotation, as intended. A second 
>>> subset of variable values must be NULLed during the rotation, so that their 
>>> associated controls are blank when the Form reappears.
>>> 
>>> I've failed to clear this latter group of values, variably using CLEAR VAR 
>>> and SET VAR = NULL commands: 
>>> 
>>> (a) ahead of the SETFOCUS  at the tail end of the Bit Button's On Click EEP;
>>> 
>>> (b) in the Bit Button's On Exit EEP;
>>> 
>>> (c) in the On After Start EEP of the form itself.
>>> 
>>> It's gottta be something basic.
>>> 
>>> What is the established procedure for clearing a subset of variable values 
>>> when rotating directly back into a form from a prior instance?
>>> 
>>> Rockets Red Glare, Bruce
>>> 
>>> Bruce A. Chitiea
>>> SafeSectors, Inc.
>>> ---
>>> 112 Harvard Ave #272
>>> Claremont CA 91711-4716
>>> ---
>>> rby...@safesectors.com
>>> ---
>>> +011 (909) 238-9012 c
>>> +011 (909) 912-8678 f
>>> 
>>> 
>>> 
>>> -- 
>>> 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/emefe264b1-e9f3-4ab0-9473-d2851d506e75%40pathfinder.
> 
> -- 
> 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/0664CAAD-6C9D-4CD1-B29B-99260ED49DDE%40comcast.net.
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/em0f0095d9-e3fa-47ce-861b-c31e0f8cfc28%40pathfinder.

-- 
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/773C482E-7FA0-4730-B0E2-B03381AB1EF2%40comcast.net.

Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs.

[Buddy Walker]

Bruce
  Have you tried RECALC VAR after settling them to null and before the setfocus

Buddy

Sent from my iPhone

> On Jul 5, 2020, at 6:24 PM, Bruce Chitiea  wrote:
> 
> 
> RGBX5E Current
> 
> Fairly new to Forms.
> 
> A Variable Form provides values to an On Click EEP in a Bit Button. The EEP 
> succeeds at its tasks, then returns FOCUS to the first control in the Form's 
> Tab Order, as intended.
> 
> One subset of variable values survive the rotation, as intended. A second 
> subset of variable values must be NULLed during the rotation, so that their 
> associated controls are blank when the Form reappears.
> 
> I've failed to clear this latter group of values, variably using CLEAR VAR 
> and SET VAR = NULL commands: 
> 
> (a) ahead of the SETFOCUS  at the tail end of the Bit Button's On Click EEP;
> 
> (b) in the Bit Button's On Exit EEP;
> 
> (c) in the On After Start EEP of the form itself.
> 
> It's gottta be something basic.
> 
> What is the established procedure for clearing a subset of variable values 
> when rotating directly back into a form from a prior instance?
> 
> Rockets Red Glare, Bruce
> 
> Bruce A. Chitiea
> SafeSectors, Inc.
> ---
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> ---
> rby...@safesectors.com
> ---
> +011 (909) 238-9012 c
> +011 (909) 912-8678 f
> 
> 
> 
> -- 
> 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/emefe264b1-e9f3-4ab0-9473-d2851d506e75%40pathfinder.

-- 
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/0664CAAD-6C9D-4CD1-B29B-99260ED49DDE%40comcast.net.

RE: [RBASE-L] - Forms

[Buddy Walker]

Thanks another option forgot about that one 

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Michael 
Byerley
Sent: Saturday, July 4, 2020 10:31 AM
To: RBASE-L 
Subject: Re: [RBASE-L] - Forms

 

 

RHIDE



On Saturday, July 4, 2020 at 10:15:02 AM UTC-4, Buddy Walker wrote:

Karen

  Thanks, I’ll see what I can come up with 

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  > 
Sent: Saturday, July 4, 2020 8:52 AM
To: rba...@googlegroups.com  
Subject: Re: [RBASE-L] - Forms

 

You should find another way of doing this.  There should never be another 
action after a "closewindow", other than following it with a "return".  Makes 
sense if you think of it, it wouldn't be able to do the next line of code 
("edit using myreportsmenu") if the form had actually closed upon your 
closewindow command.

 

Karen

 

 

 

-Original Message-
From: Buddy Walker  >
To: rba...@googlegroups.com  
Sent: Sat, Jul 4, 2020 7:36 am
Subject: [RBASE-L] - Forms

Maybe I'm missing something but forms are not closing when I use CLOSEWINDOW 

 

This happens on RBase forms and External Forms

 

Windows 10 pro

R:Base XE (current version)

 

I'm using a Speed Button on the forms and on click EEP

 

FORMS 

  myMainMenu or myMainMenu.RFF

form has various speedbuttons and the one I started with is call Reports

  myReportsMenu or myReportsMenu.RFF

 

EDIT USI myMainMenu

  Click on Reports speed button

  OnClick EEP

  CLOSEWINDOW (which I would assume closes myMainMenu form

  EDIT USI myReportsMenu

Everything seems to except myMainMenu stays open behind myReportsMenu 

myReportsMenu is the only one active but you can still see the other forms

 

 

This happens on external form as well

HAPPY 4th and be safe.

 

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+unsub...@googlegroups.com.  

To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d651ff%24b848fdf0%2428daf9d0%24%40comcast.net.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rba...@googlegroups.com  .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/dc6a1267-0044-4188-bc8a-182aa43b66efo%40googlegroups.com
 
<https://groups.google.com/d/msgid/rbase-l/dc6a1267-0044-4188-bc8a-182aa43b66efo%40googlegroups.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001801d65213%24643bdf70%242cb39e50%24%40comcast.net.

RE: [RBASE-L] - Forms

[Buddy Walker]

Karen

  Thanks, I’ll see what I can come up with 

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Saturday, July 4, 2020 8:52 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Forms

 

You should find another way of doing this.  There should never be another 
action after a "closewindow", other than following it with a "return".  Makes 
sense if you think of it, it wouldn't be able to do the next line of code 
("edit using myreportsmenu") if the form had actually closed upon your 
closewindow command.

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Sent: Sat, Jul 4, 2020 7:36 am
Subject: [RBASE-L] - Forms

Maybe I'm missing something but forms are not closing when I use CLOSEWINDOW 

 

This happens on RBase forms and External Forms

 

Windows 10 pro

R:Base XE (current version)

 

I'm using a Speed Button on the forms and on click EEP

 

FORMS 

  myMainMenu or myMainMenu.RFF

form has various speedbuttons and the one I started with is call Reports

  myReportsMenu or myReportsMenu.RFF

 

EDIT USI myMainMenu

  Click on Reports speed button

  OnClick EEP

  CLOSEWINDOW (which I would assume closes myMainMenu form

  EDIT USI myReportsMenu

Everything seems to except myMainMenu stays open behind myReportsMenu 

myReportsMenu is the only one active but you can still see the other forms

 

 

This happens on external form as well

HAPPY 4th and be safe.

 

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. <mailto:unsubscr...@googlegroups.com.> 

To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d651ff%24b848fdf0%2428daf9d0%24%40comcast.net.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000d01d6520d%2481551e60%2483ff5b20%24%40comcast.net.

[RBASE-L] - Forms

[Buddy Walker]

Maybe I'm missing something but forms are not closing when I use CLOSEWINDOW 

This happens on RBase forms and External Forms

 Windows 10 pro
 R:Base XE (current version)

 I'm using a Speed Button on the forms and on click EEP

 FORMS 
  myMainMenu or myMainMenu.RFF
 form has various speedbuttons and the one I started with is call Reports
  myReportsMenu or myReportsMenu.RFF

 EDIT USI myMainMenu
   Click on Reports speed button
  OnClick EEP
  CLOSEWINDOW (which I would assume closes myMainMenu form
  EDIT USI myReportsMenu
Everything seems to except myMainMenu stays open behind myReportsMenu 
myReportsMenu is the only one active but you can still see the other forms


This happens on external form as well
HAPPY 4th and be safe.

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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000401d651ff%24b848fdf0%2428daf9d0%24%40comcast.net.

RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field

[Buddy Walker]

Myron

  I believe you need quotes around the variable name in GETPROPERTY.

 

Buddy

 

  SET VAR vwho TEXT = 'Y'

 

  GETPROPERTY dbwho TEXTVALUE 'vWho'

 

IF vWho IS NULL THEN

   RETURN

ENDIF

 

  IF vwho = 'Y' THEN

  PROPERTY dbwho COLOR 'Blue'

ELSE

  PROPERTY dbwho COLOR 'AQUA'

  ENDIF

 

  RETURN

 

From: rbase-l@googlegroups.com  On Behalf Of Myron 
Finegold
Sent: Saturday, June 6, 2020 5:58 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color 
based on the value in the field

 

Jim,

Thanks. A no go.

I am back in the manuals trying to get a better understanding of the Property 
and Get Property commands.

I’ll let you know.

 

Myron

 

From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: June 6, 2020 1:58 PM
To: rbase-l@googlegroups.com  
Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color 
based on the value in the field

 

I would try to change two things.

1.  Create your var vwatch1 in the “on after start” EEP of the form. That 
way you are not creating it each time you enter the field.
2.  Then use the var vwatch1 to make the color change, not the component ID 
name.

 

IF vwatch1 = 'Y' THEN

  PROPERTY cilockbox COLOR 'green'

ELSE

  PROPERTY cilockbox COLOR 'red'

ENDIF

RETURN

 

Try that

 

James Belisle

 

Making Information Systems People Friendly Since 1990



 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Myron Finegold
Sent: Saturday, June 6, 2020 3:26 PM
To: rbase-l@googlegroups.com  
Subject: [RBASE-L] - DB Edit Field - Change the field background color based on 
the value in the field

 

What Object: DB Edit Field

Desire: to the background color change based on the value in the column. This 
will be a ‘Y’ or an ‘N’.

 

The DB Edit field has been given a unique component ID. ciLockBox

 

A custom EEP has been put into the ‘On Enter’ choice

   PROPERTY ciLockBox COLOR 'white'

   RETURN

 

A custom EEP has been put into the ‘On Exit’ choice

   SET VAR vwatch1 TEXT = NULL

   GETPROPERTY cilockbox TEXTVALUE vwatch1

   IF vwatch1 IS NULL THEN

RETURN

   ENDIF

  IF cilockbox = 'Y' THEN

  PROPERTY cilockbox COLOR 'green'

  ELSE

  PROPERTY cilockbox COLOR 'red'

  ENDIF

  RETURN

 

This isn’t working. As they say I have hit the wall. Any suggestions would be 
appreciated.

 

Myron Finegold

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 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339494B4B967F8CF8E613088A0870%40CY4PR0201MB3394.namprd02.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002d01d63c4d%24842da2e0%248c88e8a0%24%40gmail.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/000201d63cc3%24a0aa8f70%24e1ffae50%24%40comcast.net.

Re: [RBASE-L] - Function: Text "Number" to Integer Value

[Buddy Walker]

Bruce
  Did you try

SET VAR vintegervalue INT = .vtextnimbervalue

Buddy



Sent from my iPhone

> On May 17, 2020, at 3:21 PM, Bruce Chitiea  wrote:
> 
> 
> All:
> 
> Is there a single R:BASE function that'll convert a text "number" to an 
> integer value?
> 
> It would replace this:
> 
> SET VAR vIntegerValue = (INT(FLOAT(.vTextNumberValue) ) )
> 
> TIA
> 
> Bruce
> 
> Bruce A. Chitiea
> SafeSectors, Inc.
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> rby...@safesectors.com
> +011 (909) 238-9012 c
> 
> -- 
> 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/em17d8791f-bcbc-4200-8de6-c1a7d78d0784%40pathfinder.

-- 
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/5189DCD4-908D-48AC-9478-DCE12632BC36%40comcast.net.

RE: [RBASE-L] - exporting to Excel with fixed column width

[Buddy Walker]

Mohammed

   You may want to try creating a blank worksheet with column settings (width, 
currency, text, etc.). Once you have this done save the worksheet where 
everyone has access to it. Then before your export, copy the blank worksheet 
with a different name then export to it.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Mohammed 
Sent: Sunday, May 10, 2020 2:24 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - exporting to Excel with fixed column width

 

Hi all

Have been trying to find a way to export data from Rbase to Excel worksheet but 
wanted to be able to control the excel column width while exporting

At the moment the Excel allocates the column width to its own default like for 
Date, Text columns

Any help will be appreciated

 

Mohammed Sattar

Bangladesh

-- 
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/000401d62693%249fff6050%24dffe20f0%24%40utahgroup.net
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000a01d626b8%24d559fa10%24800dee30%24%40comcast.net.

RE: [RBASE-L] - COPY command using SELECT?

[Buddy Walker]

Jim

  I assuming vfilename and vdirectoryfilename has the full path and filename

 

  I would do something like this

 

Buddy

 

---Begin Here

SET VAR vfilename TEXT = NULL

SET VAR vdirectoryfilename TEXT = ('newFolderName')

SET VAR vdocopy TEXT = NULL

 

DECLARE c1 CURSOR FOR SELECT filenamelocationColumn FROM sometable +

WHERE customerid IN (&vcustomerlist)

OPEN c1

FETCH c1 INTO +

vfilename INDICATOR iv1

WHILE SQLCODE <> 100 THEN

 

  IF vfilename IS NULL THEN

GOTO getnextone

  ELSE

SET VAR vdocopy = ('COPY' & .vfilename & .vdirectoryfilename)

&docopy

SET VAR vdocopy = NULL

  ENDIF

 

  LABEL getnextone

  FETCH c1 INTO +

  vfilename INDICATOR iv1

ENDWHILE

DROP CURSOR c1

RETURN

 

--End Here

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
McPherson
Sent: Friday, May 1, 2020 4:49 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - COPY command using SELECT?

 

All,

 

We keep a list of files in our database and I am looking to copy a select few 
to a different location as part of the programming.  I’ve sorted out the SELECT 
statement.  Can that be used as a source file location?  If so, what’s the 
syntax?

 

Here’s what I’m trying:

COPY (SELECT FileNameLocation FROM Table WHERE CustomerID IN &vCustomerList)  
&vDirectoryFileName 

 

I’m also open to any other ways to accomplish the task.

 

Thanks,

 

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/002201d61ff9%24e847ddb0%24b8d79910%24%40jjcalibrations.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000c01d62022%241d4534e0%2457cf9ea0%24%40comcast.net.

RE: [RBASE-L] - UPDATE Anomaly

[Buddy Walker]

Bruce

  Maybe I’m missing something but it appears to me that you are trying to 
update glcodeid but in your where clause you are getting the same thing 

  WHERE t1.glcodeid = t2.glcodeid

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Bruce 
Chitiea
Sent: Wednesday, April 15, 2020 11:52 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - UPDATE Anomaly

 

All:

 

Working with a projected temp table, to preserve live table data until a 
solution is found.

 

Repeated attempts to UPDATE one column value, within 313 records, consistently  
UPDATEs only the same ten (10) records.

 

This behaviour survives an UNLOAD/RELOAD operation, on an AUTOCHK'ed = No 
Errors Found database.

 

Test Code: (Courier New)

 

--RB X.5E 10.5.2.20312

 

SET VAR vglcodenum  TEXT = NULL
SET VAR vtaparentid INT = NULL

SET VAR vglcodenum  = '56222'
SET VAR vtaparentid = 10346

 UPDATE trxaction_tt +
SET glcodeid = t2.glcodeid +
   FROM trxaction_tt t1, +
   glcoa t2 +
  WHERE t1.glcodeid = t2.glcodeid +
AND t2.glcodenum = .vglcodenum +
AND t1.taid IN +
  ( SELECT tasubid FROM tanesting +
WHERE taparentid = .vtaparentid )

RETURN

 

The Sub-Select clause produces the anticipated set of tasubid values, each one 
being represented by multiple t1.taid instances in the trxaction_tt table, 
totaling 313 records.

 

Hence the mystery. Thoughts?

 

Bruce A. Chitiea

SafeSectors, Inc.

112 Harvard Ave #272

Claremont CA 91711-4716

rby...@safesectors.com  

(909) 238-9012 c

 

-- 
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/em28323b6c-6a1f-42d5-970e-8973f87ae547%40pathfinder
 

 .

-- 
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/001701d613f3%24770d0150%24652703f0%24%40comcast.net.

Re: [RBASE-L] - capture just the decimal

[Buddy Walker]

Using the vdouble 
SET VAR vsomething int = (sloc(ctxt(.vdouble)),’.’,0)

If vsomething is not 0 then it found the decimal

I’m doing this from my phone and memory. 

Buddy

Sent from my iPhone

> On Mar 17, 2020, at 10:13 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> 
> Admittedly this is a bit of a kluge, not sure if there's a better way (if 
> someone comes up with something, then it goes into my notes!)
> 
> First I test whether the number has a decimal or not:
> 
> SET VAR vDouble DOUBLE = 10.5
> SET VAR vMod INT = (MOD(.vDouble,1))
> IF vMod = 0 THEN
>-- it has no decimal
> ELSE
> 
> -- it has a decimal.  So do a CTXT of the variable, use SLOC to find the 
> decimal place, then extract characters after the decimal
> 
> ENDIF
> 
> 
> Any better ideas?
> 
> Karen
> 
> 
> -Original Message-
> From: Jim Belisle 
> To: rbase-l@googlegroups.com 
> Sent: Tue, Mar 17, 2020 9:03 am
> Subject: [RBASE-L] - capture just the decimal
> 
> What is the function or combination of functions that will give me just to 
> decimal portion of a numeric number?
> I want to use the decimal portion to determine my next action.
>  
> 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/CH2PR02MB7047ED5091A4C04CE8BE2AF4A0F60%40CH2PR02MB7047.namprd02.prod.outlook.com.
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/2110613929.7028313.1584454387391%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/F67D243A-07E5-4B4B-953B-554623C345FD%40comcast.net.

Re: [RBASE-L] - capture just the decimal

[Buddy Walker]

Have you looked at SLOC

Sent from my iPhone

> On Mar 17, 2020, at 10:03 AM, Jim Belisle  wrote:
> 
> 
> What is the function or combination of functions that will give me just to 
> decimal portion of a numeric number?
> I want to use the decimal portion to determine my next action.
>  
> 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/CH2PR02MB7047ED5091A4C04CE8BE2AF4A0F60%40CH2PR02MB7047.namprd02.prod.outlook.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/A66E266B-8479-4E88-80E7-7364709F4925%40comcast.net.

RE: [RBASE-L] - R:Base & DFS?

[Buddy Walker]

Jim

  Have you looked at the MIRROR setting.

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
McPherson
Sent: Monday, March 2, 2020 4:34 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - R:Base & DFS?

 

All,

 

I’m considering taking our R:Base share and replicating it as part of a 
Microsoft DFS (Distributed File System).  What this entails is the operating 
system handles replicating all data in the directory between two or more 
servers.  If one of the replication partners goes offline, the other is there 
to provide the application and data and, in theory, the end users are none the 
wiser.  When the offline partner comes back on line it synchronizes with the 
online partner(s).  It’s a form of hardening or redundancy.

 

My question:  Do we know if R:Base supports this configuration and/or are there 
limitations (performance or otherwise) that would dictate against this type of 
deployment?  Is there a best practices that I’m missing here?

 

Thanks,

 

Jim McPherson 

 

-- 
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/003701d5f0da%245c2eded0%24148c9c70%24%40jjcalibrations.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002a01d5f21e%24c890c850%2459b258f0%24%40comcast.net.

RE: [RBASE-L] - Sending text messages?

[Buddy Walker]

Doug

  Depending on the cell phone carrier sent an email message to the phone 
number. This list was compiled years back so I’m not sure how current it is. I 
know the Comcast still works but not sure about the others.

 

  The “TO” line would look like412...@vtext.com 
 

 

Buddy

 

***list***

Alltel..: @message.alltel.com

AT&T: @txt.att.net

Comcast.: @vtext.com

Nextel..: @messaging.nextel.com

Sprint..: @messaging.sprintpcs.com

SunCom..: @tms.suncom.com

T-mobile: @tmomail.net

VoiceStream.: @voicestream.net

Verizon.: @vtext.com (text only)

Verizon.: @vzwpix.com (photos and video)

 

***end list**

 

From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Tuesday, February 25, 2020 7:16 AM
To: R:Base List 
Subject: [RBASE-L] - Sending text messages?

 

Is there a way How do I send text messages to a cell phone?

I run a few automatic integrity checks as users process data and want to send 
an alert if there are errors.

Thanks,
Doug
RBX.5E

-- 
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/0283fbf6-9a1d-3f44-7334-14aeafa93df9%40wi.rr.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/001701d5ebd7%24a0ce2c60%24e26a8520%24%40comcast.net.

RE: [RBASE-L] - Long embedded files in RMail

[Buddy Walker]

Karen

  I did find that sometimes the Email client did restrict the size of the body. 
When that happened I just created a report and saved it as PDF and sent that.

 

Buddy

 

From: 'Karen Tellef' via RBASE-L  
Sent: Tuesday, December 17, 2019 9:25 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Ah, I see what you're doing!   Is it your experience that as you keep adding

to a row in the body that there's no limit to the length of that row, before you

have to start another row?   I suppose it's possible for me to set up a cursor 
thru 

every row in the table and write each column one at a time

 

I'm also wondering if it's the email client that's responsible for deciding

where to wrap a row when the user receives the email.

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Tue, Dec 17, 2019 7:46 am
Subject: RE: [RBASE-L] - Long embedded files in RMail

Karen

  This is part of the code I used in the past. This was for R:Mail X

 

Buddy

 

 

SET VAR vcol1 NOTE

SET VAR vcol2 NOTE

 

SET VAR vownerfname = ‘Karen’

SET VAR vgreeting TEXT = ('v1|ADD_TO_MESSAGE_BODY Dear ' + .vownerfname + ',')

 

SELECT Col1 INTO vcol1 FROM ……..

SELECT Col2 INTO vcol2 FROM ……..

 

SET VAR vbody1 TEXT = ('v1|ADD_TO_MESSAGE_BODY  ' + .vcol1 + ',')

SET VAR vbody2 TEXT = ('v1|ADD_TO_MESSAGE_BODY  ' + .vcol2 + ',')

 

 

--Skipped all of the preliminary RMail stuff just showing the body part …

 

PLUGINS rmail .vgreeting

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail .vbody1

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail .vbody2

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY Thank you.'

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  Buddy '

 

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 4:44 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Yeah but the only way to get data from a table into an Rmail body is to output 
it to a text file (as far as I know)

 

So whether you do:

 

output test.txt

select Col1, Col2, Col3... Col10 FROM table

output screen

 

or

 

output test.txt

select NoteColumn FROM table

output screen

 

 

It's still gonna wrap that text file at the same place.  

 

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 2:10 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

Ok, assuming you have 10 columns and each row (100) is a different body.

 

So you would be sending out 100 with 10 columns in each email.

 

I would still create a temporary table with an IdColumn and NoteColumn

INSERT INTO TemporaryTable (IdColumn,NoteColumn) +

  SELECT IdColumn, (Col1 & Col2 & Col3 & Col4….) +

 FROM someTable WHERE …….

 

Then doing your RMail code select information from TemporaryTable.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 2:55 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Sorry just not understanding.  I'm doing a select of 10 columns from a table, 
could have 100 rows.  A select of 10 columns exceeds the 79 characters or so 
that's getting written to one line

 

I'm doing this:  SELECT col1, col2, col3,col10 FROM table WHERE.

 

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:44 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

 

You select the information into a variable then build your body as such

 

So if you have three selects for your body I would do this

 

SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3)

 

Then just use the variable vBody for your body.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 2:23 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

The problem is that this is a 'select' of multiple columns of a table so each 
line really cannot wrap at all.   So if I stick my select result into a 
NoteColumn and it wraps again in the email at 79 characters, it's going to wrap 
in the middle of my select

RE: [RBASE-L] - Long embedded files in RMail

[Buddy Walker]

Karen

  This is part of the code I used in the past. This was for R:Mail X

 

Buddy

 

 

SET VAR vcol1 NOTE

SET VAR vcol2 NOTE

 

SET VAR vownerfname = ‘Karen’

SET VAR vgreeting TEXT = ('v1|ADD_TO_MESSAGE_BODY Dear ' + .vownerfname + ',')

 

SELECT Col1 INTO vcol1 FROM ……..

SELECT Col2 INTO vcol2 FROM ……..

 

SET VAR vbody1 TEXT = ('v1|ADD_TO_MESSAGE_BODY  ' + .vcol1 + ',')

SET VAR vbody2 TEXT = ('v1|ADD_TO_MESSAGE_BODY  ' + .vcol2 + ',')

 

 

--Skipped all of the preliminary RMail stuff just showing the body part …

 

PLUGINS rmail .vgreeting

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail .vbody1

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail .vbody2

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY Thank you.'

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  '

PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY  Buddy '

 

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, December 16, 2019 4:44 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Yeah but the only way to get data from a table into an Rmail body is to output 
it to a text file (as far as I know)

 

So whether you do:

 

output test.txt

select Col1, Col2, Col3... Col10 FROM table

output screen

 

or

 

output test.txt

select NoteColumn FROM table

output screen

 

 

It's still gonna wrap that text file at the same place.  

 

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 2:10 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

Ok, assuming you have 10 columns and each row (100) is a different body.

 

So you would be sending out 100 with 10 columns in each email.

 

I would still create a temporary table with an IdColumn and NoteColumn

INSERT INTO TemporaryTable (IdColumn,NoteColumn) +

  SELECT IdColumn, (Col1 & Col2 & Col3 & Col4….) +

 FROM someTable WHERE …….

 

Then doing your RMail code select information from TemporaryTable.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 2:55 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Sorry just not understanding.  I'm doing a select of 10 columns from a table, 
could have 100 rows.  A select of 10 columns exceeds the 79 characters or so 
that's getting written to one line

 

I'm doing this:  SELECT col1, col2, col3,col10 FROM table WHERE.

 

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:44 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

 

You select the information into a variable then build your body as such

 

So if you have three selects for your body I would do this

 

SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3)

 

Then just use the variable vBody for your body.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 2:23 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

The problem is that this is a 'select' of multiple columns of a table so each 
line really cannot wrap at all.   So if I stick my select result into a 
NoteColumn and it wraps again in the email at 79 characters, it's going to wrap 
in the middle of my select statement.   

 

And if the data is in a temp table, the only way to get it into an email (as 
far as I know) is to write the data to a text file, which is basically what I'm 
doing now.  Or is there another way to get a "select" statement as the body of 
an email?

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:07 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

Karen

   Instead of creating text files I would create a Temporary Table IDcolumn and 
either NoteColumn or VarCharColumn. Depending on size of body data.

   Insert info into Temp table

   Then when you select the body for your email you will select 
NoteColumn/VarCharColumn as your body base on a where clause if necessary. This 
way you shouldn’t have to change the length and when inserted into email it 
should wrap naturally. 

 

   It has been a while since I did this so make sure to test.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, Decem

RE: [RBASE-L] - Long embedded files in RMail

[Buddy Walker]

Ok, assuming you have 10 columns and each row (100) is a different body.

 

So you would be sending out 100 with 10 columns in each email.

 

I would still create a temporary table with an IdColumn and NoteColumn

INSERT INTO TemporaryTable (IdColumn,NoteColumn) +

  SELECT IdColumn, (Col1 & Col2 & Col3 & Col4….) +

 FROM someTable WHERE …….

 

Then doing your RMail code select information from TemporaryTable.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, December 16, 2019 2:55 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

Sorry just not understanding.  I'm doing a select of 10 columns from a table, 
could have 100 rows.  A select of 10 columns exceeds the 79 characters or so 
that's getting written to one line

 

I'm doing this:  SELECT col1, col2, col3,col10 FROM table WHERE.

 

 

Karen

 

 

 

-----Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:44 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

 

You select the information into a variable then build your body as such

 

So if you have three selects for your body I would do this

 

SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3)

 

Then just use the variable vBody for your body.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 2:23 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

The problem is that this is a 'select' of multiple columns of a table so each 
line really cannot wrap at all.   So if I stick my select result into a 
NoteColumn and it wraps again in the email at 79 characters, it's going to wrap 
in the middle of my select statement.   

 

And if the data is in a temp table, the only way to get it into an email (as 
far as I know) is to write the data to a text file, which is basically what I'm 
doing now.  Or is there another way to get a "select" statement as the body of 
an email?

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:07 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

Karen

   Instead of creating text files I would create a Temporary Table IDcolumn and 
either NoteColumn or VarCharColumn. Depending on size of body data.

   Insert info into Temp table

   Then when you select the body for your email you will select 
NoteColumn/VarCharColumn as your body base on a where clause if necessary. This 
way you shouldn’t have to change the length and when inserted into email it 
should wrap naturally. 

 

   It has been a while since I did this so make sure to test.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 12:28 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Long embedded files in RMail

 

We create text files with select statements in them which will be used as the 
body

of an RMail email.  Before doing the select we set the width to 200 and the 
resulting

text file looks perfect.  However, when embedding it as the body (see command 
below)

it wraps at 79 characters.  I added a "set width 200" command right before all 
the

rmail code but that doesn't make a difference.

 

 
V1|LOAD_MESSAGE_BODY_FROM_FILE DashBoardRefresh.txt

 

 

Is there a way I can do this?  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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net
 
<https://groups.google.com/

RE: [RBASE-L] - Long embedded files in RMail

[Buddy Walker]

 

You select the information into a variable then build your body as such

 

So if you have three selects for your body I would do this

 

SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3)

 

Then just use the variable vBody for your body.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, December 16, 2019 2:23 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Long embedded files in RMail

 

The problem is that this is a 'select' of multiple columns of a table so each 
line really cannot wrap at all.   So if I stick my select result into a 
NoteColumn and it wraps again in the email at 79 characters, it's going to wrap 
in the middle of my select statement.   

 

And if the data is in a temp table, the only way to get it into an email (as 
far as I know) is to write the data to a text file, which is basically what I'm 
doing now.  Or is there another way to get a "select" statement as the body of 
an email?

 

Karen

 

 

 

-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Dec 16, 2019 1:07 pm
Subject: RE: [RBASE-L] - Long embedded files in RMail

Karen

   Instead of creating text files I would create a Temporary Table IDcolumn and 
either NoteColumn or VarCharColumn. Depending on size of body data.

   Insert info into Temp table

   Then when you select the body for your email you will select 
NoteColumn/VarCharColumn as your body base on a where clause if necessary. This 
way you shouldn’t have to change the length and when inserted into email it 
should wrap naturally. 

 

   It has been a while since I did this so make sure to test.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Sent: Monday, December 16, 2019 12:28 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Long embedded files in RMail

 

We create text files with select statements in them which will be used as the 
body

of an RMail email.  Before doing the select we set the width to 200 and the 
resulting

text file looks perfect.  However, when embedding it as the body (see command 
below)

it wraps at 79 characters.  I added a "set width 200" command right before all 
the

rmail code but that doesn't make a difference.

 

 
V1|LOAD_MESSAGE_BODY_FROM_FILE DashBoardRefresh.txt

 

 

Is there a way I can do this?  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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net
 
<https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com
 
<https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com?utm_medium=email&utm_source=footer>
 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/003401d5b449%2439f09ca0%24add1d5e0%24%40comcast.net.

RE: [RBASE-L] - Long embedded files in RMail

[Buddy Walker]

Karen

   Instead of creating text files I would create a Temporary Table IDcolumn and 
either NoteColumn or VarCharColumn. Depending on size of body data.

   Insert info into Temp table

   Then when you select the body for your email you will select 
NoteColumn/VarCharColumn as your body base on a where clause if necessary. This 
way you shouldn’t have to change the length and when inserted into email it 
should wrap naturally. 

 

   It has been a while since I did this so make sure to test.

 

Buddy

 

 

From: 'Karen Tellef' via RBASE-L  
Sent: Monday, December 16, 2019 12:28 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Long embedded files in RMail

 

We create text files with select statements in them which will be used as the 
body

of an RMail email.  Before doing the select we set the width to 200 and the 
resulting

text file looks perfect.  However, when embedding it as the body (see command 
below)

it wraps at 79 characters.  I added a "set width 200" command right before all 
the

rmail code but that doesn't make a difference.

 

 
V1|LOAD_MESSAGE_BODY_FROM_FILE DashBoardRefresh.txt

 

 

Is there a way I can do this?  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/1793718183.9281758.1576517295143%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/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net.

RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

[Buddy Walker]

Jim you could use and ampersand before the variable and instead of a dot. This 
will cause the variable to execute.

 

 

 

SET VAR vDoProperty TEXT = NULL

SET VAR vQuotes = (CVAL(‘QUOTES’))

SET VAR MenuPerm TEXT = NULL

 

SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel

PROPERTY MenuItem VISIBLE PropertyTest

SET VAR vDoProperty = (‘PROPERTY MenuItem VISIBLE’ & .vQuotes + .PropertyTest + 
.vQuotes)

&vDoProperty

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of 
jim.mcpher...@jjcalibrations.com
Sent: Thursday, December 5, 2019 6:22 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - PROPERTY Command Using Variable Toggle?

 

Greetings all,

 

I’m new to the group and almost as new to R:Base so I hope my questions are not 
too basic for this group.  Anyway, on to this one…

 

Can you use a variable in the place of ‘TRUE’ or ‘FALSE’ on the PROPERTY 
command?

 

For instance, I have a menu that I would like to remain hidden based on a table 
value.  Here’s what I’m trying:

 

SET VAR MenuPerm TEXT = NULL

SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAccessLevel

PROPERTY MenuItem VISIBLE PropertyTest

 

I’ve vetted the SELECT statement to ensure it’s getting the correct value but 
using the variable as the toggle doesn’t seem to work.

 

Thoughts?

 

Jim McPherson

 

-- 
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/002701d5abc2%24d7545110%2485fcf330%24%40jjcalibrations.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/002d01d5ac36%24a9119190%24fb34b4b0%24%40comcast.net.

RE: [RBASE-L] - error in rpt expression

[Buddy Walker]

Jim

  I seems like you may be defining the variable(s) “before design report” and 
that would also explain why no error when you run your code after designing 
report

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Monday, November 11, 2019 11:28 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - error in rpt expression

 

We use the latest RBASEX5.

I created a report with three sub reports.

When in the design mode, I get no errors in the variables I use in each sub 
report.

However when I use the same exact code outside of the report used to design the 
report, I get a variable error. Actually two errors.  

I know which variable it is since it does not show on the report when it 
prints. 

Here is another aspect of the error.

If I go into the design mode first, then once out run my command file, I get no 
errors.

 

However this variable is pulling from the same view as three other variables 
and they show on the report with no error that I can tell.

As I said, the strange part is no errors in the design mode but two when 
running the report with code.

 

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/DM6PR02MB453951970BCF54F40904BB62A0740%40DM6PR02MB4539.namprd02.prod.outlook.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000a01d598b6%24c8c71de0%245a5559a0%24%40comcast.net.

Re: [RBASE-L] - Ghost form

[Buddy Walker]

Jan
  The first thing I would do is make a copy of the database then reload it to 
see if that clears up the duplicate form. 

Buddy

Sent from my iPhone

> On May 9, 2019, at 9:40 AM, jan johansen  wrote:
> 
> Group,
>  
> Somehow I ended up with 2 forms with the same name.
> I can remove one but not the other.
>  
> Suggestions? I seem remember a way to do this by going
> into SYS_FORMS but wanted to check in here first.
>  
> 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.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/WC20190509134016.1400A3%40jjcalibrations.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/2C365C49-E557-4C8A-8009-C567982FE836%40comcast.net.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - RE: SCRATCH

[Buddy Walker]

Jim

 

Locate the RBEngine*.CFG file. 

 

Make sure the CFG file has SCRATCH C:\TEMP 

  and not  SCRATCH TMP

 

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Thursday, April 25, 2019 2:46 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: SCRATCH

 

I am sorry I am asking what I am sure seems so basic to most of you.

However here is where I get confused. Below is my startup file for when I go 
into the explorer mode.

 

-- clear scratch files

SET ERROR MESSAGE 2077 OFF

CLEAR VAR vChkFile

SET VAR vChkFile INTEGER = NULL

SET VAR vChkFile = (CHKFILE('C:\TEMP'))

IF vChkFile <> 1 THEN

   MD C:\TEMP

ENDIF

SET SCRATCH C:\TEMP

 

So above the scratch files are set to C:\TEMP. At least that is my 
understanding in what I have been told through the years.

When I look at the settings while in the explorer mode, here is what it shows. 
So the default is not C:\TEMP.



 

And when I look in the C:\TEMP folder there are no scratch files. The scratch 
files are in the Default location c:\users\username\appdata\local\temp. 

Is that where they are supposed to be when starting the DB?

Also that is where the scratch files are created when the application is 
started. The startup file for the application uses the same code.

 

Am I missing something or is this exactly how it is supposed to work?

 

James Belisle

 

Making Information Systems People Friendly Since 1990



 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg
Sent: Thursday, April 25, 2019 12:08 PM
To: rbase-l@googlegroups.com  
Subject: [RBASE-L] - RE: SCRATCH

 

You can use any folder as your temp folder. Check with them and see what name 
you can have as an exception.

 

Maybe something like C:\RBTEMP

 

Then in my startup file I would have:

 

--Create scratch folder if it does not exist

IF (CHKFILE('C:\RBTEMP’)) <> 1 THEN

  MKDIR C:\RBTEMP

ENDIF

 

--set scratch file location

SET SCRATCH C:\RBTEMP

 

Dan Goldberg

 

From: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> > On Behalf Of Jim 
Belisle
Sent: Thursday, April 25, 2019 9:39 AM
To: rbase-l@googlegroups.com  
Subject: [RBASE-L] - SCRATCH

 

I have been working on getting the Rmail setup and mentioned yesterday how I 
appreciate the help I got form the list and RBASE support.

 

Our IT people (third party company) do not like the idea of not having the 
virus software scan the C:\TEMP folder. My understanding is scanning slows 
RBASE down.

My question to you folks is, do you not scan the C:\TEMP folder? Am I wrong to 
prevent the scanning?

 

I ask because when I set the SCRATCH files to TMP, the files are now going to 
C:\Users\jim\AppData\Local\Temp. 

When accessing a lot of data for reports etc some SCRATCH files are created in 
the C:\TEMP folder.

 

My speed has not been improved since changing the SCRATCH settings.

 

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

[Buddy Walker]

Jim

  I always kept the folder clean. TEMP or TMP meant just that. I would clean 
the folder up every day. A lot of files could also slow things down. 

 

  Could you ask your IT people to exclude files with $$$ extensions.

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Thursday, April 25, 2019 12:39 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - SCRATCH

 

I have been working on getting the Rmail setup and mentioned yesterday how I 
appreciate the help I got form the list and RBASE support.

 

Our IT people (third party company) do not like the idea of not having the 
virus software scan the C:\TEMP folder. My understanding is scanning slows 
RBASE down.

My question to you folks is, do you not scan the C:\TEMP folder? Am I wrong to 
prevent the scanning?

 

I ask because when I set the SCRATCH files to TMP, the files are now going to 
C:\Users\jim\AppData\Local\Temp. 

When accessing a lot of data for reports etc some SCRATCH files are created in 
the C:\TEMP folder.

 

My speed has not been improved since changing the SCRATCH settings.

 

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_form Print options?

[Buddy Walker]

Karen
  If the form is that large couldn’t you creat a report that looks like the 
form. Just save changes before printing. 

Sent from my iPhone

> On Apr 20, 2019, at 9:15 AM, 'Karen Tellef' via RBASE-L 
>  wrote:
> 
> I want to put a "print this form" button on a very large form to send a 
> print-screen to my printer.  These are the only options I know that I can 
> use, but only a portion of the form will print.  Any other options I don't 
> know about to shrink the picture onto one printer page, or another way to do 
> it?
> 
> 
> PRNSETUP LANDSCAPE
> PROPERTY RBASE_FORM PRINT 'FITTOPAGE'
> PROPERTY RBASE_FORM PRINT 'PRINTER'
> PRNSETUP PORTRAIT
> 
> 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] - The current R:BASE build is incompatible with the database files.

[Buddy Walker]

Make a copy of the database you cannot connect and then try connecting to the 
copy. If you are able to connect then someone or server has the database 
locked. 

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of MD
Sent: Saturday, April 6, 2019 12:11 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - The current R:BASE build is incompatible with the database 
files.

 

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] - when email is not correct

[Buddy Walker]

Jim
  I don’t think that is a RMail issue. Most email servers will not respond to 
bad email addresses. The main reason is this would verify email server exists. 

Buddy





Sent from my iPhone

> On Apr 5, 2019, at 5:41 PM, Jim Belisle  wrote:
> 
> We use Rmail working with the Outlook365 STMP.
> If one sends out an email from within RBASE with the a bad email address, How 
> do we know if it is a bad email address?
>  
> When using Outlook directly, we get an error feedback. Does that happen with 
> Rmail?
> Or is there a code we need to add that would alert us?
>  
> 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] - finding views containing certain tables

[Buddy Walker]

Jim

  What I do is create a RMD file with all the views. Then you can search the 
RMD file for a specific table, plus you have a file with your views just in 
case you have to re-create one or all.

 

  OUT AllMyViews.RMD ; UNLOAD STRUC FOR VIEWS ; OUT TERM

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Monday, March 25, 2019 5:28 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - finding views containing certain tables

 

How do I find the views that use a specific table? 

My understanding is if I add a column to a table that is in a view, then I need 
to recreate the view.

So I want to find the views I will need to recreate if I add columns. 

 

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

[Buddy Walker]

Javier

  You could add them after the semicolon SAMS.mdb;uid=my_user_name;pwd=my_pw:

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of 
javier.valen...@vtgonline.com
Sent: Monday, February 11, 2019 12:59 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Working with external databases

 

Karen,

Where do you include the parameters you mentioned? In the delete or insert 
command string or the actual DELETE/INSERT command line? I don’t have any on 
the SCONNECT or SATTACH commands and the database connects and the table 
attaches correctly.

 

Albert,

You might have something there since the command is passed on to the access 
database (???). I will create a long command line and see if it helps. I always 
try to make my code readable and also, in the back of my mind, have the 80 
character limit which might not even be applicable anymore…old habits die hard.

 

Javier,

 

Javier Valencia, PE

O: 913-829-0888

C: 913-915-3137

 

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Monday, February 11, 2019 11:36 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - Working with external databases

 

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 
mailto:rbase-l@googlegroups.com> > 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 mailto:javier.valen...@vtgonline.com> >
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:  <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com [ 
<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Monday, February 11, 2019 7:50 AM
To:  <mailto:rbase-l@googlegroups.com> 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:  <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com < 
<mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com> On Behalf Of  
<mailto:javier.valen...@vtgonline.com> javier.valen...@vtgonline.com
Sent: Monday, February 11, 2019 1:58 AM
To:  <mailto:rbase-l@googlegroups.com> 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;' + '''')

&vCommandC

 

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:  <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com [ 
<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com] On Behalf Of 
 <mailto:javier.valen...@vtgonline.com> javier.valen...@vtgonline.com
Sent: Thu

RE: [RBASE-L] - Working with external databases

[Buddy Walker]

Javier

   Is it access rights. You may need a  user (uid) and password (psw).

 

Buddy

 

 

From: 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;' + )

&vCommandC

 

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" mailto:j...@jjcalibrations.com> >
To: rbase-l@googlegroups.com  
Date: Tue, 05 Feb 2019 15:41:06 -0800
Subject: [RBASE-L] - SQL tutorial
  

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.

-- 
For group guidelines, visit 
ht

RE: [RBASE-L] - How to add Find Button on button toolbar of Print report.

[Buddy Walker]

Rehan

  Have you  tried printing report directly to a PDF and then the “Ctrl+F” 
should work??

 

Buddy

 

 

From: 'rehan wyne' via RBASE-L  
Sent: Monday, February 4, 2019 4:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - How to add Find Button on button toolbar of Print report.

 

I want to add Find / Search button on Print report button toolbar, to find any 
text in report Print preview window.

I have checked the Print command Option parameters but could not find any such 
parameter to enable \ disable "Find / Search" button.

 

Basically, I want "Ctrl+F" functionality in report preview window. I am using 
R:Base X Enterprise.

 

Any Clue.

 

I will be grateful for any help.

 

 

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

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

[Buddy Walker]

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.

RE: [RBASE-L] - edit using form child table where clause

[Buddy Walker]

Dan

  Have you tried something like this

 

   EDIT using formname where parentNameColumn in (SELECT parentNameColumn FROM 
childTable where childColumn = value)

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Tuesday, September 25, 2018 1:13 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - edit using form child table where clause

 

Is there a way to put in the where clause to filter the child table? I can 
filter the parent table but the only way I think I can filter the child table 
is to use a view.

 

Edit using formname where parentcolumn = value and childcolumn = value

 

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] - problems with forms not saving

[Buddy Walker]

Randy
  I believe that is by design not to save changes when firm is opened in design 
mode

Buddy

Sent from my iPhone

> On Sep 9, 2018, at 11:52 AM, Randy Larsen  wrote:
> 
> I just started having a problem with Forms not saving changes.  When i click 
> on the save icon (disk) nothing happens.  When click the “x” to close the 
> form, i get a prompt asking if i want to save my changes, i click ok the form 
> closes and my changes are not save when i open up the form in the designer.
> 
> Anyone else experiencing this or have experienced this before?
> 
> Cheers,
> -Randy
> 
> 
> 
> 
> 
> 
> If you want to go fast, go alone.  If you want to go far, go together.
>   -African proverb
> 
> 
> 
> 
> -- 
> 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] - Easy Way to Add Conditions to Report?

[Buddy Walker]

Cathy

If  I understand you right why not create a view with your 3 conditions and 
then base the report on the view. This way all you have to do is print report 
without where clause. If you wanted an additional condition like from only from 
specific city you would 

 

  PRINT reportName WHERE City = “SomeWhere” 

 

The 3 main conditions still work and you are filtering for a specific city.

 

Hope this helps

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Cathy 
Grimes
Sent: Saturday, August 18, 2018 4:56 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Easy Way to Add Conditions to Report?

 

One of my reports needs to satisfy 3 conditions.   Is there an easy way to just 
stipulate those same conditions when printing this report – instead of my 
having to repeat them with where clauses every time I print this?  The 
conditions are fairly lengthy using and/or’s so it would be a big help if those 
conditions are easily already specified.

 

I’ve long ago forgotten what little basics I learned about setting up reports, 
and cannot locate answers in the Help menus.  I vaguely remember setting up a 
bunch of variables with conditions, then using those variables in some reports, 
but I’m hoping I can just specify (and/or modify) the conditions I want to 
imbed in that report.

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

[Buddy Walker]

Jim

  As you can see from Dan and Karen’s response there are a number of ways to 
achieve a login.

 

   Whichever way you decide to go if you have any questions just ask.

 

Buddy

 

 

From: karentellef via RBASE-L  
Sent: Monday, August 6, 2018 9:46 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE

 

That's almost all I ever use too, (cval('netuser')).  I've never used cfg files 
for that.

 

I have a couple installations where there is a general windows logon just to 
boot the computer up, and then multiple people will use that machine.  In those 
cases I will institute a log on / password routine within RBase, compared to a 
table that holds the list.

 

Karen

 

 

 

-Original Message-
From: Dan Goldberg mailto:d...@lancecamper.com> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Mon, Aug 6, 2018 8:33 am
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE

I use the cval(‘netuser’) to authenticate and give permissions from there. I 
have a table with the users/windows logon names with their access rights. Based 
on their rights the menu will displayed.

 

Dan Goldberg

 

From: rbase-l@googlegroups.com <mailto:l...@googlegroups.com>  
mailto:l...@googlegroups.com> > On Behalf Of Jim 
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com <mailto:l...@googlegroups.com> 
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE

 

Buddy and Albert,

 

Thanks for the information. I am in meetings the first part of the week so will 
have to wait on this.

I am not sure if I mentioned this to you but I am the only one who has a full 
version of RBASE. 

I create the compiled application and all others use this application and use 
the same CFG file on the server.

That CFG is located on the server in the same folder as the compiled apps and 
any DLLS or other programs needed in RBASE.

 

So as you can see, all this is new to me and I am having trouble “connecting 
the dots”. 

I will read the RBASE pdfs to see if I can get further understanding on setting 
up log ins based on users in a compiled app system.

I have read this in the past but we did not implement. 

 

James Belisle

 

Making Information Systems People Friendly Since 1990



 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE

 

Jim

  Each user will need there own RBENGINEXE.CFG (RBENGINEX.CFG) file. You would 
have to visit each user’s PC once and update the RBENGINEXE.CFG (RBENGINEX.CFG) 
this can be done in couple of different ways:

1.   Start a session of R:Base and then select Settings > Configuration 
Settings > Multi User now in the NAME box type in the users windows/exchange 
name 

2.   The other way is edit the file using Notepad or some other text 
editor. Find the line that starts with NAME and then highlight and replace the 
name that is there.

 

   Now just follow Albert’s example below.

 

Buddy

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Albert Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE

 

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 mailto:j...@kaypark.com> > 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>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10

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

[Buddy Walker]

Jim

  Each user will need there own RBENGINEXE.CFG (RBENGINEX.CFG) file. You would 
have to visit each user’s PC once and update the RBENGINEXE.CFG (RBENGINEX.CFG) 
this can be done in couple of different ways:

1.  Start a session of R:Base and then select Settings > Configuration 
Settings > Multi User now in the NAME box type in the users windows/exchange 
name 
2.  The other way is edit the file using Notepad or some other text editor. 
Find the line that starts with NAME and then highlight and replace the name 
that is there.

 

   Now just follow Albert’s example below.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Albert 
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE

 

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 mailto:j...@kaypark.com> > 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>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com <mailto: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 <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of Jim 
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: rbase-l@googlegroups.com <mailto: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.

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

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

3.  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> 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to  <mailto:rbase-l+unsubscr...@googlegroups.com> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.c

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

[Buddy Walker]

Jim 
I’m on my way to a family picnic when I get back I could write some code for 
you.  

Buddy

Sent from my iPhone

> On Aug 4, 2018, at 11: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] - using user IDs and passwords for RBASE

[Buddy Walker]

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.

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

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

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

Re: [RBASE-L] - Picking and Renaming Windows Files

[Buddy Walker]

Sorry I took it as a file because of the  name. 😀

Sent from my iPhone

> On Aug 1, 2018, at 2:42 PM, Claudine Robbins  wrote:
> 
> I haven’t tried based on the input being in a variable and not a file. 
> 
> I’ll try and report back. 
> 
> Thanks Buddy!
> 
> Sent from my iPhone
> 
> On Aug 1, 2018, at 1:03 PM, Buddy Walker  wrote:
> 
> Claudine
>   Since you have commas in the file I would think you have to load the table 
> instead of insert.
>  
> Buddy
>  
>  
> From: rbase-l@googlegroups.com  On Behalf Of 
> Claudine Robbins
> Sent: Wednesday, August 1, 2018 1:21 PM
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - Picking and Renaming Windows Files
>  
> Hi all,
>  
> I’m trying to capture multiple file names to rename them.  The following code 
> gives me the error: “ERROR-Incorrect number of values for this table (118)”.
>  
> It appears I may need quotes around each value.  Any easy way to do this?
>  
> TIA,
>  
> Claudine
>  
> PLUGINS LoadFileNamePlus vFileName +
> |INITIAL_DIR C:\iex_x\CHRISPREP +
> |TITLE 'Select file' +
> |FULLPATH ON +
> |NO_CHANGE_DIR ON +
> |FILTER PDF Files (*.PDF)#*.PDF +
> |HIDE_READ_ONLY ON +
> |MULTISELECT ON +
> |SHOW_HIDDEN OFF +
> |ENABLE_SIZING ON +
> |VIEW_MODE LIST
>  
> SET VAR vfilename = ( '('+.vfilename+')' )
>  
> SET ERROR MESSAGE 2058 OFF
> DROP TABLE `tFileName` NOCHECK
> SET ERROR MESSAGE 2058 ON
> CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
>  
> R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename
> -ERROR- Incorrect number of values for this table ( 118)
>  
> R>sho v vfilename
> (C:\IEX_X\CHRISPREP\ACME-54572
> 05-BU-0702181107AU.pdf,C:\IEX_
> X\CHRISPREP\ACME-5457205-07021
> 81107AU.pdf,C:\IEX_X\CHRISPREP
> \ACME-5457205-INV-0702181107AU
> .pdf)
> -- 
> 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] - Picking and Renaming Windows Files

[Buddy Walker]

Claudine

  Since you have commas in the file I would think you have to load the table 
instead of insert.

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files

 

Hi all,

 

I’m trying to capture multiple file names to rename them.  The following code 
gives me the error: “ERROR-Incorrect number of values for this table (118)”.

 

It appears I may need quotes around each value.  Any easy way to do this?

 

TIA,

 

Claudine

 

PLUGINS LoadFileNamePlus vFileName +

|INITIAL_DIR C:\iex_x\CHRISPREP +

|TITLE 'Select file' +

|FULLPATH ON +

|NO_CHANGE_DIR ON +

|FILTER PDF Files (*.PDF)#*.PDF +

|HIDE_READ_ONLY ON +

|MULTISELECT ON +

|SHOW_HIDDEN OFF +

|ENABLE_SIZING ON +

|VIEW_MODE LIST

 

SET VAR vfilename = ( '('+.vfilename+')' )

 

SET ERROR MESSAGE 2058 OFF

DROP TABLE `tFileName` NOCHECK

SET ERROR MESSAGE 2058 ON

CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))

 

R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename

-ERROR- Incorrect number of values for this table ( 118)

 

R>sho v vfilename

(C:\IEX_X\CHRISPREP\ACME-54572

05-BU-0702181107AU.pdf,C:\IEX_

X\CHRISPREP\ACME-5457205-07021

81107AU.pdf,C:\IEX_X\CHRISPREP

\ACME-5457205-INV-0702181107AU

.pdf)

-- 
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] - Dropping a default?

[Buddy Walker]

Karen

  ALTER TABLE tblName ALTER colName DROP DEFAULT

 

Buddy

 

 

From: karentellef via RBASE-L  
Sent: Tuesday, May 22, 2018 11:26 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Dropping a default?

 

Is there a way to drop a column's default value in code?We have a routine 
that runs overnight to do structure changes and I want to drop a default value 
for a column.  I know I can drop and recreate the column, but then I have to 
make sure that I've saved a copy of the original values because they might have 
changed them, and then bring in that data.

 

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] - Does Table exist?

[Buddy Walker]

I think doing a COUNT(*) FROM  SYS_TABLES is the best way to check for an 
existing table. With that being said and you truly want to delete/drop a 
TEMPORARY table then recreate it I would just turn the error message off and 
drop the table then turn the error message back on. 

 

  SET ERROR MESSAGE 2038 OFF

DROP myTempTblName

 SET ERR0R MESSAGE 2038 ON

  CREATE TEMPORARY myTempTblName ………

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Lena 
Dammstrom
Sent: Tuesday, May 1, 2018 11:41 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Does Table exist?

 

Doug, I be interested in a more elegant way of checking for the existence of a 
table too!

 

I use the count method:

SET VAR vCount = 0

SELECT COUNT(*) INTO vCount FROM Sys_Tables +

  WHERE Sys_Table_Name = 'TableName' AND LIMIT = 1

 

 

Regards 

Lena 

From: rbase-l@googlegroups.com   
mailto:rbase-l@googlegroups.com> > On Behalf Of Doug 
Hamilton
Sent: Tuesday, May 01, 2018 10:33 AM
To: R:Base List mailto:rbase-l@googlegroups.com> >
Subject: [RBASE-L] - Does Table exist?

 

I'm drawing a blank - is there a command/function (in 9.5) to check for the 
existence of a table?
I want to see if a temp table exists before I try to recreate it.

I could try to count rows and check for error messages if the table isn't there 
but I suspect there's a more elegant method.
'Course, recreating an existing table would also give an error message...

TIA,
Doug
Now to get more coffee

 


 

 

Virus-free.  

 www.avast.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 
 .
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] - IT update and problem

[Buddy Walker]

Jim

  I had the same problem a couple of months ago. It was from a Windows 10 Pro 
Update. Had to keep contacting John as well. It turned out when I did a 
shutdown it would not shutdown it would go through like a restart. When it did 
that I lost the R:Base registration. If I would do an actual restart right 
after shutdown I would get the registration back. Not sure what update fixed 
all that but it is working fine now.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Albert 
Berry
Sent: Thursday, April 26, 2018 9:20 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - IT update and problem

 

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 mailto:j...@kaypark.com> > 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.

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

[Buddy Walker]

Kayza

  Reports > Breaks >
   From the dropdown select the uniqueID and click Add
   Check box for "Start New Page"

 Note: this will sort the report based on the uniqueID 

Buddy 

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Kayza 
Kleinman
Sent: Wednesday, April 25, 2018 10:48 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

This should work for one row. But if I want to print multiple rows, each one 
taking up 2 pages how would you suggest doing that?

Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc www.jccgci.org 
www.nphd.org


-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of A. 
Razzak Memon
Sent: Wednesday, April 25, 2018 11:11 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

You will have to play with the suggested idea and find the perfect setup/layout.

Here is another approach ...

01. Place all contents (objects) for the first page on the "Report Header" band.
02. Place all contents (objects) for the second page on the "Detail" band.
03. Right-click on the "Report Header" band and check the options as follows:
 [x] Static Height
 [x] New Page

This technique will print all contents (objects) placed on "Report Header" as 
the first page of the report, and all contents (objects) placed on the "Detail"
band as second page of the report.

Have fun!

Razzak


At 10:42 AM 4/25/2018, Kayza Kleinman wrote:

>When I put a sub report on the footer, it prints as the footer on that 
>page. What I need is for it to print on the next page.
>
>Kayza Kleinman
>Director of the Nonprofit Helpdesk
>CIO
>Jewish Community Council of Greater Coney Island, Inc www.jccgci.org 
>www.nphd.org
>
>-Original Message-
>From: rbase-l@googlegroups.com  On Behalf Of 
>A. Razzak Memon
>Sent: Wednesday, April 18, 2018 8:38 AM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - 2 page report in Rbase X
>
>At 12:24 AM 4/18/2018, Kayza Kleinman wrote:
>
> >What I can't figure out is if I can have both pages print as one report.
>
>Kayza,
>
>Here's how ...
>
>01. Create a sub-report and place the Sub Report object on Report Page 
>Footer section.
>
>02. Place all necessary and/or relevant columns/fields on this 
>sub-report accordingly.
>
>03. When PRINTing the report, both pages will be printed as one report.
>
>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] - RBase 101

[Buddy Walker]

Claudine

   You could also try this

Make sure your null is set to -0-

 

 TALLY company_name FROM i_companies ORDER BY company_name DESC

 

   If there is null it should up as the 1st one

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: Saturday, April 21, 2018 6:26 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - RBase 101

 

Buddy,

 

Interestingly, I just reloaded the database last night and this still occurs.  

 

Claudine

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, April 21, 2018 2:19 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - RBase 101

 

 

Claudine

It could be index corruption. Any time that has happened to me a reload or 
pack would fix it. 

 

If company_name is indexed you could just try packing the indexes.

 

Buddy

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of 
Claudine Robbins
Sent: Saturday, April 21, 2018 3:16 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - RBase 101

 

And a physical look at the table confirms that there are no rows with a null 
company_name…

 

Citing my ignorance, I tried set eqnull on and zero off with no effect.

 

Claudine

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Saturday, April 21, 2018 1:53 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - RBase 101

 

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 mailto:crobb...@iexgroup.com> > 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> 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to  <mailto:rbase-l+unsubscr...@googlegroups.com> 
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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

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

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

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

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

RE: [RBASE-L] - RBase 101

[Buddy Walker]

 

Claudine

It could be index corruption. Any time that has happened to me a reload or 
pack would fix it. 

 

If company_name is indexed you could just try packing the indexes.

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: Saturday, April 21, 2018 3:16 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - RBase 101

 

And a physical look at the table confirms that there are no rows with a null 
company_name…

 

Citing my ignorance, I tried set eqnull on and zero off with no effect.

 

Claudine

 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Saturday, April 21, 2018 1:53 PM
To: rbase-l@googlegroups.com  
Subject: Re: [RBASE-L] - RBase 101

 

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 mailto:crobb...@iexgroup.com> > 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.

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

[Buddy Walker]

Kayza

  The best way I have found to do this is to use regions and checkbox. The 
regions can be set to expand based on the region before. 

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Kayza 
Kleinman
Sent: Wednesday, April 18, 2018 12:24 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

 

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  

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

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.

-- 
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 export to xlsx

[Buddy Walker]

Dan

   Try changing

  GATEWAY EXPORT XLS Customers_123.xls 

to 

   GATEWAY EXPORT XLSW Customers_123.xlsx

 

 If you want a small file you could trying exporting to CSV then have Excel 
open the csv file.

 

 

Buddy

 

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Thursday, April 5, 2018 5:20 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - gateway export to xlsx

 

I am using a command line export to xls like the sample.

 

GATEWAY EXPORT XLS Customers_123.xls + 

SELECT + 

Company AS `Company Name`, + 

CustID AS `Customer ID`, + 

CustAddress AS `Company Address`, + 

(CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` + 

FROM Customer ORDER by Company + 

OPTION COL_NAMES ON + 

|TAB_NAME Customer List 

 

Is there a way to export to xlsx? The reason being is xlsx is a smaller file 
size.

 

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] - Form DB Table change?

[Buddy Walker]

Randy
   Copy original form to a new form name and select the new table. Be sure all 
fields located on the form are in the new table.
   Once you are satisfied then delete the original form and then rename the 
copied form to the original form name.
Buddy


-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Randy 
Larsen
Sent: Monday, March 5, 2018 10:01 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Form DB Table change?

Hi Folks,

I was wondering if it’s possible to change the base table for a form after it’s 
been created.

Up to know I have had to copy all of the field and past them into a newly 
created form in order to change the table reference.  I was hoping there is an 
easier way to just change the table in the form.

Thank you!

-Randy

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

[Buddy Walker]

Jan

  Check to see if the variable exists first

 

  SET VAR vChkVar = (CHKVAR(' RBTI_FORM_DIRTYVAR '))

 

 --1 = exists  

 --0 = does not exists

 

   IF vChkVar = 1 THEN 

 IF RBTI_FORM_DIRTYVAR = 1 THEN

   SAVEROW

 ENDIF

   ENDIF

   

   CLOSEWINDOW  

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Friday, March 2, 2018 11:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - DIRTYVAR

 

Group,

 

I want to check RBTI_FORM_DIRTYVAR for 1 before exit to ask to save changes.

However if there haven't been any changes, the dirty var wouldn't be set.

Do I initialize it?

 

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

[Buddy Walker]

Claudine

   Are you leaving the output file open?

 

Buddy

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Saturday, February 24, 2018 4:50 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

Buddy,

 

One (small) problem, the variables initialize just fine but only the last 
row/line writes to the file!  I’ve tried OUTPUT vfilename APPEND and WRITE 
.vwritext to .vfilename.

No left or right parens however…

 

Claudine

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Saturday, February 24, 2018 2:29 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Formatting OUTPUT

 


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing <http://aka.ms/LearnAboutSpoofing> 

Feedback <http://aka.ms/SafetyTipsFeedback> 

Thanks Buddy!  Learning exercise too, I don’t think I have ever used SPUT this 
way.

 

Claudine

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, February 24, 2018 12:11 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

Claudine

  I think you are going to have to loop through the table.

  

  See attached file. I didn’t test it but I think it may give you a start.

 

Buddy

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Saturday, February 24, 2018 12:21 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

Thanks Buddy.  I thought my messages were being bounced.

 

Here is my code.  And YES setting EOFCHAR OFF takes care of that right arrow.

 

Claudine

 

--

OUTPUT .vfilename

UNLOAD DATA FOR chrispreptbl USING  +

(CALLIT + (SFIL(' ',(50-(SLEN(CALLIT) & (CTXT(invdate)) + (SFIL(' ',2)) + 
(FORMAT(amount,'[>]999,999.00')) & MARK)+

AS ASCII WHERE edate = .#DATE ORDER BY CARRIER,INVOICE

OUTPUT SCREEN

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Friday, February 23, 2018 10:45 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

 

Claudine

 

  Are you doing an unload data from a table and all of the data is in one 
column. If so it will quote the text with single quote because of the space.

  The character that looks like a right arrow could be the EOFCHAR.

 

  Can you show the code you are using for output either ASCII or CSV or both.

 

  The 

 

Buddy

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, February 23, 2018 10:55 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Formatting OUTPUT

 

Either I output as ASCII or CSV and I still get those extra quotes and return.

 

Any idea how I can suppress those?

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

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

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

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l

RE: [RBASE-L] - Formatting OUTPUT

[Buddy Walker]

Claudine

  I think you are going to have to loop through the table.

  

  See attached file. I didn’t test it but I think it may give you a start.

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Saturday, February 24, 2018 12:21 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

Thanks Buddy.  I thought my messages were being bounced.

 

Here is my code.  And YES setting EOFCHAR OFF takes care of that right arrow.

 

Claudine

 

--

OUTPUT .vfilename

UNLOAD DATA FOR chrispreptbl USING  +

(CALLIT + (SFIL(' ',(50-(SLEN(CALLIT) & (CTXT(invdate)) + (SFIL(' ',2)) + 
(FORMAT(amount,'[>]999,999.00')) & MARK)+

AS ASCII WHERE edate = .#DATE ORDER BY CARRIER,INVOICE

OUTPUT SCREEN

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Friday, February 23, 2018 10:45 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: RE: [RBASE-L] - Formatting OUTPUT

 

 

Claudine

 

  Are you doing an unload data from a table and all of the data is in one 
column. If so it will quote the text with single quote because of the space.

  The character that looks like a right arrow could be the EOFCHAR.

 

  Can you show the code you are using for output either ASCII or CSV or both.

 

  The 

 

Buddy

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, February 23, 2018 10:55 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Formatting OUTPUT

 

Either I output as ASCII or CSV and I still get those extra quotes and return.

 

Any idea how I can suppress those?

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

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

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

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


MyTest.RMD
Description: Binary data

RE: [RBASE-L] - Formatting OUTPUT

[Buddy Walker]

 

Claudine

  Are you doing an unload data from a table and all of the data is in one 
column. If so it will quote the text with single quote because of the space.

  The character that looks like a right arrow could be the EOFCHAR.

 

  Can you show the code you are using for output either ASCII or CSV or both.

 

  The 

 

Buddy

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, February 23, 2018 10:55 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Formatting OUTPUT

 

Either I output as ASCII or CSV and I still get those extra quotes and return.

 

Any idea how I can suppress those?

 

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.

RE: [RBASE-L] - Text file that retains trailing blank space

[Buddy Walker]

James

  I have a file that contains the use of SFIL and SPUT. I used this to provide 
a class listing to a health insurance company. It's about 11 years old but I 
think it should still work.

Buddy

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
James W. Kim, CPA, MBA
Sent: Monday, February 19, 2018 4:26 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Text file that retains trailing blank space

Need some help with creating text file that retains blank spaces at the end of 
each row.

I often need to create text files with fixed row length such as 512 or
750 characters in a row. When there are no data value near the right end of 
each row, the unused spaces need to be filled with blank spaces.

The following is an example of how such text file would be built. The example 
creates a row that has "FLOOR 7" at 274th space in a row that has 512 
characters.  With some previous versions of R:Base, the trailing spaces is 
retained after insertion of data using SPUT function and line feed (CR/LF) 
would show up at 513th position.

However, the current version would remove the trailing space when data is 
inserted using SPUT function and the (CR/LF) moves up to 281st position.

Is there anyway I can force the retention of trailing spaces so that CR/LF 
always shows up at 513th position?

Thanks in advance,

James



-- create text variable with blank spaces SET VAR vRow TEXT = NULL SET VAR vRow 
= (SFIL((CHAR(32)),512))
-- use SPUT function to fill in data
SET VAR vRow = (SPUT(.vRow, 'start', 1)) SET VAR vRow = (SPUT(.vRow, 'Floor 7', 
274))

-- write the variable to a text file
OUTPUT sample.txt append
WRITE .vRow USING
''
OUTPUT SCREEN


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

[Buddy Walker]

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.

RE: [RBASE-L] - File location

[Buddy Walker]

Jan

  I would just elect to use the UNC for everyone, provided the UNC path to the 
home folder is the same (the only difference is the home folder name). The 
other way would be to just create a table with the user name and path to the 
home folder. The other problem would be if you are accessing different 
databases it would be a bear to keep up with the changes so to help with that 
create one CSV or XLS file and keep it updated and copy it to a temp folder. 
Create a TempTable with username and path it load it from the copied file.

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Thursday, February 1, 2018 12:56 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - File location

 

My turn!

 

I need to make sure external documents are placed in the proper directory.

On the surface it's pretty easy.

 

However I have been running into some obstacles.

 

1. UNC/Mapped drive - machines on the network either use a UNC connection or a 
mapped drive make it difficult to figure out the "home" directory

2. It appears (only occasionally) that the (CVAL('CURRDIR')) returns a 
directory other that RBase if you have used the file explorer tool.

 

So I'm kind of looking for a fool proof way of making sure I have the proper 
file location.

 

Suggestions?

 

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: Re[4]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

[Buddy Walker]

Bruce

 

I would say because the “VO” should have been the column name (sourceString) so 
I would say it should have looked like this 

 

UPDATE transx SET trxnum = (SRPL(trxnum,’V0’,’v’,0)) WHERE trxnum LIKE ‘V0%’

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bruce Chitiea
Sent: Sunday, January 14, 2018 4:37 PM
To: rbase-l@googlegroups.com
Subject: Re[4]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Buddy:  Thanks, you are absolutely right. That would have done the job in this 
context. Pays to review the Function list every now and again.

 

Any thoughts, though, on why this:

 

UPDATE transx SET trxnum = (SRPL('V0','V','v',0)) WHERE trxnum LIKE 'V0%'

 

... would replace every selected column value [ V0xx | v0xx ] to 'v0' ? 
 My understanding of SRPL is that only the 'V' character value would be 
affected.

 

Thanks

 

Bruce

 

-- Original Message --

From: "Buddy Walker" mailto:walker.bu...@comcast.net> >

To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 

Sent: 1/14/2018 1:30:08 PM

Subject: RE: Re[2]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Bruce

  Maybe I’m missing something but you could have used the function ULC if “V” 
was the only alpha character in the field

 

UPDATE tableNameHere SET columnName = (ULC(columnName)) WHERE if you need it.

 

Buddy

 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> ] On Behalf 
Of Bruce Chitiea
Sent: Sunday, January 14, 2018 4:12 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re[2]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Karen:

 

All my error.

 

That's EXACTLY what I wanted to do (per the WHERE clause. )

 

I had run your syntax earlier, and failed. Then ran my fatal syntax without 
understanding WHY it failed.

 

I reviewed the command history only after I posted. My syntax failed because I 
muffed the WHERE clause in that first run. Instead of 

 

[ WHERE trxnum LIKE 'V0%' ] 

 

... I had typed 

 

[ WHERE trxnum = 'V0' ]

 

... a stand-alone value which does not exist in the column.

 

But that leaves the question: "Why would it replace the entire string [ 
V00xx | v00xx ] with 'v0' ?"

 

Thanks again, Karen

 

Bruce

 

 

-- Original Message --

From: "karentellef via RBASE-L" mailto:rbase-l@googlegroups.com> >

To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 

Sent: 1/14/2018 12:06:38 PM

Subject: Re: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Maybe I'm reading your statement wrong, but no I don't think that's what you 
wanted to do.  Did you want to do this?

UPDATE transx SET trxnum = (SRPL(trxnum, 'V0', 'v0', 0))

 

 

Karen

 

 

-Original Message-
From: Bruce Chitiea mailto:rby...@safesectors.com> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Sun, Jan 14, 2018 12:11 pm
Subject: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

Happy New Year to all! 

 

Might this be the correct SRPL syntax for replacing a substring within a text 
column? If not, what?

 

SET VAR vTargetColumn TEXT = NULL

SET VAR vTargetColumn = 'ColumnNAME'

UPDATE TableNAME SET &vTargetColumn = 
(SRPL(&vTargetColumn,'SearchString','ReplaceString',0))

 

I ask because I attempted a SRPL on a column using a literal string in place of 
'&vTargetColumn', with an ugly result (Fortunately I had a backup. )

 

Target column 'transx' contained several thousand values [ V00xx | 
v00xx ] where 'x' might be any digit. For visual clarity-in-reporting's 
sake, I decided to replace the legacy capital 'V' with lower case 'v'.

 

UPDATE transx SET trxnum = (SRPL('V0','V','v',0)) WHERE trxnum LIKE 'V0%'

 

This produced a uniform value of 'v0'. No trailing digits. Disaster. Restore 
from backup.

 

???

 

Thanks very much,

 

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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To 

RE: Re[2]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

[Buddy Walker]

Bruce

  Maybe I’m missing something but you could have used the function ULC if “V” 
was the only alpha character in the field

 

UPDATE tableNameHere SET columnName = (ULC(columnName)) WHERE if you need it.

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bruce Chitiea
Sent: Sunday, January 14, 2018 4:12 PM
To: rbase-l@googlegroups.com
Subject: Re[2]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Karen:

 

All my error.

 

That's EXACTLY what I wanted to do (per the WHERE clause. )

 

I had run your syntax earlier, and failed. Then ran my fatal syntax without 
understanding WHY it failed.

 

I reviewed the command history only after I posted. My syntax failed because I 
muffed the WHERE clause in that first run. Instead of 

 

[ WHERE trxnum LIKE 'V0%' ] 

 

... I had typed 

 

[ WHERE trxnum = 'V0' ]

 

... a stand-alone value which does not exist in the column.

 

But that leaves the question: "Why would it replace the entire string [ 
V00xx | v00xx ] with 'v0' ?"

 

Thanks again, Karen

 

Bruce

 

 

-- Original Message --

From: "karentellef via RBASE-L" mailto:rbase-l@googlegroups.com> >

To: rbase-l@googlegroups.com  

Sent: 1/14/2018 12:06:38 PM

Subject: Re: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

 

Maybe I'm reading your statement wrong, but no I don't think that's what you 
wanted to do.  Did you want to do this?

UPDATE transx SET trxnum = (SRPL(trxnum, 'V0', 'v0', 0))

 

 

Karen

 

 

-Original Message-
From: Bruce Chitiea mailto:rby...@safesectors.com> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Sun, Jan 14, 2018 12:11 pm
Subject: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

Happy New Year to all! 

 

Might this be the correct SRPL syntax for replacing a substring within a text 
column? If not, what?

 

SET VAR vTargetColumn TEXT = NULL

SET VAR vTargetColumn = 'ColumnNAME'

UPDATE TableNAME SET &vTargetColumn = 
(SRPL(&vTargetColumn,'SearchString','ReplaceString',0))

 

I ask because I attempted a SRPL on a column using a literal string in place of 
'&vTargetColumn', with an ugly result (Fortunately I had a backup. )

 

Target column 'transx' contained several thousand values [ V00xx | 
v00xx ] where 'x' might be any digit. For visual clarity-in-reporting's 
sake, I decided to replace the legacy capital 'V' with lower case 'v'.

 

UPDATE transx SET trxnum = (SRPL('V0','V','v',0)) WHERE trxnum LIKE 'V0%'

 

This produced a uniform value of 'v0'. No trailing digits. Disaster. Restore 
from backup.

 

???

 

Thanks very much,

 

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.

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

[Buddy Walker]

David
  You could give this code a try. I'm allowing that check in and check out 
could be different days.

Buddy

*Code Starts Here*
  CLEAR ALL VAR

  SET TIME FORMAT 'HH:MM'

  SET VAR vchkin DATETIME = '01/12/2018 21:25'
  SET VAR vchkout DATETIME = '01/13/2018 01:45'

  --SET VAR vchkout DATETIME = '01/12/2018 23:45'

  SET VAR vchkindate DATE = (DEXTRACT(.vchkin))
  SET VAR vchkoutdate DATE = (DEXTRACT(.vchkout))

  SET VAR vchkintime1 TIME = (TEXTRACT(.vchkin))
  SET VAR vchkouttime1 TIME = (TEXTRACT(.vchkout))

  SET VAR vmidnight TIME = 23:59

  IF vchkindate = .vchkoutdate THEN
SET VAR velapsedtime1 TIME = (RTIME(0,0,.vchkouttime1 - .vchkintime1))
  ELSE
SET VAR vminspstmidn INTEGER = (INT(SGET(CTXT(.vchkouttime1),2,4)))
SET VAR vhrsspstmidn INTEGER = (INT(SGET(CTXT(.vchkouttime1),2,1)))
SET VAR velapsedtime1 TIME = (RTIME(0,0,.vmidnight - .vchkintime1))

IF vhrsspstmidn <> 0 THEN
  SET VAR velapsedtime1 = (ADDHR(.velapsedtime1,.vhrsspstmidn))
ENDIF

IF vminspstmidn <> 0 THEN
  SET VAR velapsedtime1 = (ADDMIN(.velapsedtime1,.vminspstmidn))
ENDIF
  ENDIF

  SET VAR vmsg = ('Total Elapsed Time (HH:MM) =' & (CTXT(.velapsedtime1)))

  PAUSE 2 USING .vmsg ICON INFO

  RETURN
*Code Ends Here**

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
dkfowler6179
Sent: Friday, January 12, 2018 9:10 PM
To: RBASE-L 
Subject: [RBASE-L] - Elapsed time in HH:MM format

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

[Buddy Walker]

Jim

  You could also look into Visual Studio (version 2013 through 2017 work). I 
have used them with Oterro was also able to tie into PayPal.

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Thursday, January 4, 2018 4:45 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - 

 

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.

 

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.

[RBASE-L] - Phishing

[Buddy Walker]

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 

1.   delivered to my in box instead of my R:Base folder. 
2.  Missing from address “On Behalf Of” …
3.  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.