They are no additional data types in R:BASE 11, at this time.
Here is a tip from the Father of R:BASE, Wayne Erickson (Head of the R:BASE Development Team), which validates an email address in R:BASE.
Wayne's Corner: Validating an email address in R:BASE
For example, assume you have a table called "Person," and it has a column called "Email" for storing email addresses. You want to check some things to ensure the values in this column meet some basic things an email address should have. Here is the rule definition code:
RULES 'Improper Email Address' FOR Person SUCCEED +
WHERE +
(SLOC(SMOVE(`Email`,(SLOC(`Email`,'@')+1), +
SLEN(`Email`)-(SLOC(`Email`,'@')),' ',1),'.')) > 1 +
AND +
((SLEN(SMOVE(`Email`,(SLOC(`Email`,'@')+1), +
(SLEN(`Email`)-SLOC(`Email`,'@')),' ',1)))- +
(SLOC(SMOVE(`Email`,(SLOC(`Email`,'@')+1), +
(SLEN(`Email`)-SLOC(`Email`,'@')),' ',1),'.'))) >= 2 +
AND +
(SLOC(STRIM(LJS(`Email`,40)),'@')) > 2
This particular rule checks three things:
1. Are there at least 2 characters before an "@" character? The below handles that part of the rule.
(SLOC(STRIM(LJS(`Email`,40)),'@')) > 2
2. Is there a "." after the "@", and is there at least one character between the "@" and the "."? The below handles that part of the rule.
(SLOC(SMOVE(`Email`,(SLOC(`Email`,'@')+1), +
SLEN(`Email`)-(SLOC(`Email`,'@')),' ',1),'.')) > 1
3. Are there at least 2 characters after the "." which follows the "@" character? This would allow something like [email protected] but not [email protected]. The below handles that part of the rule.
((SLEN(SMOVE(`Email`,(SLOC(`Email`,'@')+1),+
(SLEN(`Email`)-SLOC(`Email`,'@')),' ',1)))- +
(SLOC(SMOVE(`Email`,(SLOC(`Email`,'@')+1), +
(SLEN(`Email`)-SLOC(`Email`,'@')),' ',1),'.'))) >= 2
Have fun implementing this cool code in your R:BASE applications!
Very Best R:egards,
Razzak
--On 01/21/2024 1:24 PM EST Kayza Kleinman <[email protected]> wrote:I love what I’m seeing.
I may have missed it, but are there any new data types and / or “standard” formats for field entry? Specifically, I’m looking for some way to make sure that people put valid email addresses into email fields. So, to make sure that you have <something>@<something>.<tld>
Obviously no filter is going to catch everything, but I’d love something that would catch something like myname@gmail (missing .com) or mynam.gmail.com (has a dot rather than @ after “myname”)
From: [email protected] <[email protected]> On Behalf Of Razzak Memon
Sent: Thursday, January 11, 2024 11:00 AM
To: [email protected]
Subject: [RBASE-L] - R:BASE 11 Released!
CAUTION: This email originated from outside Jewish Community Council Of GCI. Exercise caution when opening attachments or clicking links, unless you recognize the sender and know the content is safe.
Thursday, January 11, 2024 11:00 AM EST
Dear R:BASE Community,
The official release of R:BASE 11 is now available!
After years of work with modern development environments and components, R:BASE 11 is the new major release from R:BASE Technologies, showcasing the latest advances for your databases and applications.
The development team has meticulously honed R:BASE 11 to combine pure performance and high-tech features with a practical interface for users of all levels. The robust and true-relational R:BASE has further evolved to meet today's ever-changing demands of SQL-compliant databases and to manage mission-critical applications for businesses worldwide.
R:BASE 11 users can achieve peak productivity to overachieve, outperform, and over-deliver on data management goals!
Below are just a few of the highly anticipated features:
. Database stored static variables
. Table Wizard, with 32 available templates (Business/Personal)
. Trace Debugger T> Prompt toolbar to execute commands
. EXCEPT clause support: SELECT, PROJECT, EDIT, BROWSE
. Partial indexes for NOT NULL column values
. Edit EEP options within right-click menus for Form Designer objects
. OpenDocument format support GATEWAY IMPORT ODS/EXPORT ODT
. New Aztec Code 2-Dimensional barcode
. New statistical functions: FISHER, RANKAVG, RANKEQ
. Database Explorer Find in List Filter
. Redesigned Data Dictionary utility
. Support for local variables within MDI forms
. Directly edit a View/Stored Procedure source code
. EXPLAIN command to provide optimizer selections for queries
. Redesigned Font Editor and Color Editor utilities
. Stored last "structure" and "data" database modification date/time
. DBCONN command for application connection tracking
. Undo for variable definitions in _expression_ Builder
. Database stored comments
. Report Outline within the Print to Screen window
Please review the list of R:BASE 11 features:
https://www.rbase.com/rbg11
What's New in R:BASE 11 for Windows:
https://www.rbase.com/rbg11/WhatsNewIn_RBASE_11_forWindows.pdf
R:BASE 11 Feature Highlights:
https://www.rbase.com/rbg11/RBASE_11_FeatureHighlights.pdf
Frequently Asked Questions:
https://www.rbase.com/rbg11/RBASE_11_FrequentlyAskedQuestions.pdf
R:BASE 11 is an upgrade option for R:BASE 10.5 (and below) users and is available as a software purchase.
With the new Website, R:BASE Technologies has simplified the Version 11 product price list into two categories: Initial Purchase and Upgrade.
Please stay tuned for many exciting Version 11 posts and announcements!
We value your continued trust in our company and will do our best to exceed your expectations.
Very Best R:egards,
Razzak
A. Razzak Memon
Founder, President & CEO
R:BASE Technologies, Inc.
https://www.rbase.com--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1832068399.40876.1704988823620%40email.ionos.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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA3PR15MB5678CB71EA63814D52BFCC77C5762%40SA3PR15MB5678.namprd15.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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/965579312.1337253.1705958288670%40email.ionos.com.
