[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Add-on Products

[A. Razzak Memon]

Tuesday, March 26, 2019

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE X.5
and R:BASE X.5 Enterprise (Version 10.5):

https://www.rbaseupdates.com

Build: 10.5.1.30326 - Update 1

. Oterro X.5 and Oterro X.5 Enterprise
. R:WEB Reports X.5 and R:WEB Reports X.5 Enterprise
. R:WEB Gateway X.5 and R:WEB Gateway X.5 Enterprise
. R:BASE Editor X.5
. R:Docs X.5
. R:PDF Works X.5
. R:Biometric X.5

This is a FREE update for all registered users who are within one year of
their purchase or are active R:SAP subscribers for their licensed product.

Very Best R:egards,

Razzak.

https://www.rbase.com
www.facebook.com/rbase
--
36 years of continuous innovation!
20 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--


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

To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 1

[A. Razzak Memon]

Tuesday, March 26, 2019

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) 
are now available.


https://www.rbaseupdates.com

Build: 10.5.1.30326 - Update 1

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 1, Build: 10.5.1.30326, includes a total of 67 enhancements and 68
reported bug fixes.

Refer to WhatsNewInRBASE_X5_Update01.pdf for complete details.

This is a FREE update for all registered users of R:BASE X5/XE5 who are within
one year of their purchase or are active R:SAP subscribers.

Very Best R:egards,

Razzak.

https://www.rbase.com
www.facebook.com/rbase
--
36 years of continuous innovation!
20 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--


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

To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RE: expanding note field

[Claudine Robbins]

I should have added: “In a DBGrid.  I’m assuming it’s the same for a scrolling 
region.”

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Monday, March 25, 2019 7:15 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - expanding note field

I am using a DBmemo on a field. Here is what I want to do.
The DBmemo is in a scrolling region.
I want to have the field a certain size but if the user adds more information 
in the field, rather than hiding the info in the previous lines, I want the 
memo to expand beyond the region so the user can see all they have entered.

SO do I need to have a small form just for that field? Or can I create a note 
form on the fly so to speak? I want the notes to be a part of the existing 
table not a separate table with just notes.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

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

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

[RBASE-L] - RE: expanding note field

[Claudine Robbins]

James,

DBL-CLKing on the field will automatically open the Blob Editor.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Monday, March 25, 2019 7:15 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - expanding note field

I am using a DBmemo on a field. Here is what I want to do.
The DBmemo is in a scrolling region.
I want to have the field a certain size but if the user adds more information 
in the field, rather than hiding the info in the previous lines, I want the 
memo to expand beyond the region so the user can see all they have entered.

SO do I need to have a small form just for that field? Or can I create a note 
form on the fly so to speak? I want the notes to be a part of the existing 
table not a separate table with just notes.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

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

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

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

[Myron Finegold]

Albert and Karen,

Thank you.

I will try both and report back.

 

Myron

 

From: rbase-l@googlegroups.com  On Behalf Of Albert 
Berry
Sent: March 25, 2019 7:02 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Telephone Number Stored as Text Value in a Table

 

R>SET VAR vPhone TEXT = '(250) 464-5864'

R>set var vDigits TEXT = (SKEEP(.vPhone,'1234567890'))

R>SET VAR vShowPhone TEXT = (FORMAT(.vDigits,'999-999-'))

 

R>SHOW v v%

Variable = ValueType

   --   ---

vPhone   = (250) 464-5864   TEXT

vDigits  = 2504645864   TEXT

vShowPhone   = 250-464-5864 TEXT

 

 

On Mar 24, 2019, at 8:46 AM, Myron Finegold mailto:myron.fineg...@gmail.com> > wrote:

 

Background: I have a table that stores a telephone number as a text value.

Challenge: How do display the telephone number in a form formatted as 
555-698-4567 (or something close)?

I’ve used the input format mask as shown below.

 

I’ve tried the format mask (000) 000_;1;_ in a DB Edit ‘Input Format Mask’ 
field – no joy.

And I’ve tried !\(999\)\ 000\-;0; - again – no joy.

 



 

 

And is there a way to format the number is an ‘Enhanced BD Grid Properties’ 
column field?

 

Then of course the question that begs to be asked is; should I change the table 
data to reflect the output I need?

If so, what is the best way to accomplish this?

 

Myron Finegold

 

 

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

 

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

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and 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] - expanding note field

[Jim Belisle]

I am using a DBmemo on a field. Here is what I want to do.
The DBmemo is in a scrolling region.
I want to have the field a certain size but if the user adds more information 
in the field, rather than hiding the info in the previous lines, I want the 
memo to expand beyond the region so the user can see all they have entered.

SO do I need to have a small form just for that field? Or can I create a note 
form on the fly so to speak? I want the notes to be a part of the existing 
table not a separate table with just notes.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

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

[Jim Belisle]

Thanks, Buddy.
I can see where that would be useful if you have a real problem or if you are 
doing what I am trying to do.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Monday, March 25, 2019 4:46 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - finding views containing certain tables

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
[cid:image001.jpg@01CD8CE2.FB048F50]

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and 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] - finding views containing certain tables

[Jim Belisle]

Thanks, Karen. I think that is what I need.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, March 25, 2019 4:33 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - finding views containing certain tables

Ever since version 7.0, you no longer need to recreate views when you add 
columns.  You can now create a view like this:
   as select t1.*, t2.* from table1 t1, table2 t2 where .

and it doesn't matter if you add columns.

But if you want to search views for existence of columns or tables, I do:  
browse all from sys_views where #2 contains 'whatever' or #3 contains 'whatever'

You then have to look up the view name in the sys_tables  table

Karen




-Original Message-
From: Jim Belisle 
To: rbase-l@googlegroups.com 
Sent: Mon, Mar 25, 2019 4:28 pm
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
[cid:image001.jpg@01CD8CE2.FB048F50]

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and 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] - finding views containing certain tables

['Karen Tellef' via RBASE-L]

Ever since version 7.0, you no longer need to recreate views when you add 
columns.  You can now create a view like this:   as select t1.*, t2.* from 
table1 t1, table2 t2 where .
and it doesn't matter if you add columns.
But if you want to search views for existence of columns or tables, I do:  
browse all from sys_views where #2 contains 'whatever' or #3 contains 'whatever'

You then have to look up the view name in the sys_tables  table

Karen
   
 
 
 
-Original Message-
From: Jim Belisle 
To: rbase-l@googlegroups.com 
Sent: Mon, Mar 25, 2019 4:28 pm
Subject: [RBASE-L] - finding views containing certain tables

 !-- #yiv6948934467 _filtered #yiv6948934467 {font-family:"Cambria 
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6948934467 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6948934467 
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv6948934467 
#yiv6948934467 p.yiv6948934467MsoNormal, #yiv6948934467 
li.yiv6948934467MsoNormal, #yiv6948934467 div.yiv6948934467MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", 
"sans-serif";} #yiv6948934467 a:link, #yiv6948934467 
span.yiv6948934467MsoHyperlink {color:blue;text-decoration:underline;} 
#yiv6948934467 a:visited, #yiv6948934467 span.yiv6948934467MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;} #yiv6948934467 
p.yiv6948934467MsoAcetate, #yiv6948934467 li.yiv6948934467MsoAcetate, 
#yiv6948934467 div.yiv6948934467MsoAcetate 
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", 
"sans-serif";} #yiv6948934467 span.yiv6948934467EmailStyle17 
{font-family:"Calibri", "sans-serif";color:windowtext;} #yiv6948934467 
span.yiv6948934467BalloonTextChar {font-family:"Tahoma", "sans-serif";} 
#yiv6948934467 .yiv6948934467MsoChpDefault {} _filtered #yiv6948934467 
{margin:1.0in 1.0in 1.0in 1.0in;} #yiv6948934467 div.yiv6948934467WordSection1 
{} --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.

[RBASE-L] - RE: finding views containing certain tables

[Dan Goldberg]

I search in the sys_views table. then find the table name by matching up the 
table id.

Dan Goldberg

From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Monday, March 25, 2019 2: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
[cid:image001.jpg@01CD8CE2.FB048F50]

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and 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] - finding views containing certain tables

[Jim Belisle]

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
[cid:image001.jpg@01CD8CE2.FB048F50]

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and 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] - Scrolling Regions

[John Docherty]

Hi Tony,

Thanks very much for that. I have changed the setting as you suggested.  My 
'problem' is now solved. I appreciate your help. 

Regards

John Docherty


On Tuesday, March 26, 2019 at 1:30:32 AM UTC+13, Tony IJntema wrote:
>
> John,
>
>  
>
> Take a look at the table relations in the form.
>
>  
>
>  
>
> I think the setting of Many to Many is the one you have  to choose to 
> achiev the result you want
>
>  
>
> Tony  
>
> *Van:* rba...@googlegroups.com   > *Namens *John Docherty
> *Verzonden:* maandag 25 maart 2019 13:16
> *Aan:* RBASE-L >
> *Onderwerp:* [RBASE-L] - Scrolling Regions
>
>  
>
> Hi,
>
>  
>
> I have a form with three scrolling regions and three tables - master and 
> two slaves. There are common columns which link the data, which represents 
> data in three tables, SECTIONS, SUB_SECTIONS & SUB_SUB_SECTIONS. 
>
>  
>
> While when I scroll through the SECTIONS region only the rows for the 
> matching SUB_SECTION & SUB_SUB_SECTION are displayed. However when I scroll 
> through the SUB_SECTION region, all of the rows that match the SECTION 
> number appear in the SUB_SUB_SECTION region. However all I want to appear 
> are the rows that match the SECTION NUMBER and the SUB_SECTION NUMBER. I 
> thought that this used to happen, but maybe my memory has failed in regard 
> to that.
>
>  
>
> The attached screenshot hopefully shows what is happening. The cursor is 
> on a row with a subsectn no of 6, for which there are no rows in the 
> SUB_SUB_SECTION table, however rows from that table are displayed. 
>
>  
>
> Any suggestions as to what should happen and what I have wrong would be 
> much appreciated. (I am using X.5 10.5.1.30214.)
>
>  
>
> Thank you.
>
>  
>
> Regards
>
>  
>
> John Docherty
>
>  
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.
>

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

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

[Albert Berry]

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


> On Mar 24, 2019, at 8:46 AM, Myron Finegold  wrote:
> 
> Background: I have a table that stores a telephone number as a text value.
> Challenge: How do display the telephone number in a form formatted as 
> 555-698-4567 (or something close)?
> I’ve used the input format mask as shown below.
>  
> I’ve tried the format mask (000) 000_;1;_ in a DB Edit ‘Input Format 
> Mask’ field – no joy.
> And I’ve tried !\(999\)\ 000\-;0; - again – no joy.
>  
> 
>  
>  
> And is there a way to format the number is an ‘Enhanced BD Grid Properties’ 
> column field?
>  
> Then of course the question that begs to be asked is; should I change the 
> table data to reflect the output I need?
> If so, what is the best way to accomplish this?
>  
> Myron Finegold
>  
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com 
> .
> For more options, visit https://groups.google.com/d/optout 
> .

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

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

['Karen Tellef' via RBASE-L]

Rather than using format masks in the field property itself, I've switched to 
using the menu option Tables / Display Format.  Have you tried that?
Karen
 
 
 
-Original Message-
From: Myron Finegold 
To: rbase-l 
Sent: Sun, Mar 24, 2019 9:46 am
Subject: [RBASE-L] - Telephone Number Stored as Text Value in a Table

!-- #yiv1432737460 _filtered #yiv1432737460 {font-family:"Cambria 
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1432737460 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv1432737460 
#yiv1432737460 p.yiv1432737460MsoNormal, #yiv1432737460 
li.yiv1432737460MsoNormal, #yiv1432737460 div.yiv1432737460MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", 
sans-serif;} #yiv1432737460 a:link, #yiv1432737460 
span.yiv1432737460MsoHyperlink {color:#0563C1;text-decoration:underline;} 
#yiv1432737460 a:visited, #yiv1432737460 span.yiv1432737460MsoHyperlinkFollowed 
{color:#954F72;text-decoration:underline;} #yiv1432737460 
span.yiv1432737460EmailStyle17 {font-family:"Calibri", 
sans-serif;color:windowtext;font-weight:normal;font-style:normal;text-decoration:none
 none;} #yiv1432737460 .yiv1432737460MsoChpDefault {font-family:"Calibri", 
sans-serif;} _filtered #yiv1432737460 {margin:1.0in 1.0in 1.0in 1.0in;} 
#yiv1432737460 div.yiv1432737460WordSection1 {} --Background: I have a 
table that stores a telephone number as a text value.Challenge: How do display 
the telephone number in a form formatted as 555-698-4567 (or something 
close)?I’ve used the input format mask as shown below.  I’ve tried the format 
mask (000) 000_;1;_ in a DB Edit ‘Input Format Mask’ field – no joy.And 
I’ve tried !\(999\)\ 000\-;0; - again – no joy.      And is there a way to 
format the number is an ‘Enhanced BD Grid Properties’ column field?  Then of 
course the question that begs to be asked is; should I change the table data to 
reflect the output I need?If so, what is the best way to accomplish this?  
Myron Finegold   -- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

RE: [RBASE-L] - Scrolling Regions

[Tony IJntema]

John,

 

Take a look at the table relations in the form.

 



 

I think the setting of Many to Many is the one you have  to choose to achiev 
the result you want

 

Tony  

Van: rbase-l@googlegroups.com  Namens John Docherty
Verzonden: maandag 25 maart 2019 13:16
Aan: RBASE-L 
Onderwerp: [RBASE-L] - Scrolling Regions

 

Hi,

 

I have a form with three scrolling regions and three tables - master and two 
slaves. There are common columns which link the data, which represents data in 
three tables, SECTIONS, SUB_SECTIONS & SUB_SUB_SECTIONS. 

 

While when I scroll through the SECTIONS region only the rows for the matching 
SUB_SECTION & SUB_SUB_SECTION are displayed. However when I scroll through the 
SUB_SECTION region, all of the rows that match the SECTION number appear in the 
SUB_SUB_SECTION region. However all I want to appear are the rows that match 
the SECTION NUMBER and the SUB_SECTION NUMBER. I thought that this used to 
happen, but maybe my memory has failed in regard to that.

 

The attached screenshot hopefully shows what is happening. The cursor is on a 
row with a subsectn no of 6, for which there are no rows in the SUB_SUB_SECTION 
table, however rows from that table are displayed. 

 

Any suggestions as to what should happen and what I have wrong would be much 
appreciated. (I am using X.5 10.5.1.30214.)

 

Thank you.

 

Regards

 

John Docherty

 

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