Thank you!
From: [email protected] <[email protected]> On Behalf Of Razzak Memon Sent: Monday, January 22, 2024 4:18 PM To: [email protected] Subject: RE: [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. Kayza, 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]<mailto:[email protected]> but not [email protected]<mailto:[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]<mailto:[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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Razzak Memon Sent: Thursday, January 11, 2024 11:00 AM To: [email protected]<mailto:[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! https://www.rbase.com 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1832068399.40876.1704988823620%40email.ionos.com<https://groups.google.com/d/msgid/rbase-l/1832068399.40876.1704988823620%40email.ionos.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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA3PR15MB5678CB71EA63814D52BFCC77C5762%40SA3PR15MB5678.namprd15.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/SA3PR15MB5678CB71EA63814D52BFCC77C5762%40SA3PR15MB5678.namprd15.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 [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/965579312.1337253.1705958288670%40email.ionos.com<https://groups.google.com/d/msgid/rbase-l/965579312.1337253.1705958288670%40email.ionos.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA3PR15MB56788CD980C7905128B62752C57B2%40SA3PR15MB5678.namprd15.prod.outlook.com.
