R:BASE The Industrial-Strength True-Relational Database Management System Many added R:BASE features bring forth powerful means to further streamline data management.

R:BASE X.5 (Version 10.5) is the sleek new relational database environment intended to offer next-generation development and connectivity to database administrators. R:BASE X.5 also takes a big and very fundamental step of extended character support, geared towards even more versatile world-wide use. The clean and sophisticated styling of R:BASE X.5, paired with the built-in database engine that h

as paved the foundation of stability and reliable convenience, provides a brand-new value to R:BASE's database and application adaptive content development. No database software exemplifies better excellence in meeting the demands of our consumers, with R:BASE X.5 playing the latest key function in making database and application development more productive. One of the most important aspects in business growth is your company data, and no one else has more invested in your success than R:BASE Technologies. Invest forward with R:BASE!

06/16/2026

R:BASE has been enhanced to improve the handling of variables when working with multiple ODBC connections. Previously, variables defined within one ODBC connection session were not always available to queries executed through another connection, requiring duplicate variable definitions or additional programming logic to maintain consistency.

With this enhancement, the set of variables currently defined for each ODBC connection is automatically passed along with the SQL queries being executed. This allows variable values to be recognized and resolved correctly across multiple ODBC connections, providing a more seamless and consistent ex*****on environment.

This new capability, introduced in the June 11th release, complements several other ODBC-related changes, including improvements to the PASSTHROUGH setting, more reliable variable calculations within reports, and expanded support with WHERE clause restrictions.

R:BASE users can utilize ODBC to connect to foreign data sources, simplifying the process of accessing and integrating data from other database systems. Through ODBC, R:BASE can access tables from multiple database products simultaneously, enabling applications to work with data stored across different ODBC-compliant platforms. This flexibility allows organizations to leverage existing data investments while using R:BASE as a centralized application and reporting environment.

For additional information on working with foreign data sources, please review the "Using SQL Data Sources in R:BASE 11" technical document.

From The Edge: http://www.razzak.com/fte

Chapters include the following topics:

1. Foreign Data Sources and ODBC
2. ODBC Compliance
3. Commands
. SCONNECT
. SATTACH
. SET PASSTHROUGH
. SET QUALCOLS
. SSQL
. SDETACH
. SDISCONNECT
4. Setting Up Data Sources
5. Connecting Data Sources and Tables
6. Working with Data Sources
7. Disconnecting Data Sources and Tables
8. ODBC System Variables

06/15/2026

A new IQTR date function has been implemented to return the fiscal quarter number for a date, based upon a provided fiscal year beginning date.

Syntax:

(IQTR(date,fydate))

Where:

. date specifies the date whose quarter you wish to discover
. fydate specifies the first day of the fiscal year

The function returns the fiscal quarter number (1,2,3,4).

Example:

SET VAR vDate DATE = 06/22/2013
SET VAR vFirstOfFiscalYear DATE = 07/01/2012
SET VAR vIQTR INTEGER = (IQTR(.vDate,.vFirstOfFiscalYear))

The value assigned to vIQTR is 4.

The new index creation process has been enhanced, where a default value is provided consisting of the table name and col...
06/12/2026

The new index creation process has been enhanced, where a default value is provided consisting of the table name and column name(s).

The proper use of indexing can greatly increase the speed of your applications. The suggestions for using indexes may provide you with a significant performance boost, though incorrect indexing can adversely affect the speed of your applications.

The "Indexing Explained in R:BASE 11" PDF document is available to explain the following topics:

. Index Introduction
. Choosing the Columns to Index
. Assigning and Removing an Index
. Optimizing Indexes
. Indexing Long TEXT Values
. Using WHERE Clauses with Indexes
. Using ORDER BY with Indexes
. Indexing Computed Columns
. Index Efficiency
. Summary

From The Edge: http://www.razzak.com/fte/

06/11/2026

A new REVLIST string manipulation function has been implemented to reverse the order of items within a delimited list of values.

Syntax:

(REVLIST(text,delimiter))

Where:

text specifies the list of values to be reversed.
delimiter specifies the character used to separate the list items.

The function returns the list with the items in reverse order while preserving the specified delimiter.

The delimiter argument allows the use of custom list separators, similar to the functionality provided by the SSUBCD function.

Example:

SET VAR vRevList TEXT = +
(REVLIST('One,Two,Three,Four,Five',(CHAR(044))))

The value assigned to vReverseList will be:

Five,Four,Three,Two,One

The REVLIST function differs from the REVERSE function, which reverses the order of individual characters within a text string. Instead, REVLIST operates on a list of delimited values, reversing the order of the list items while maintaining the integrity of each item.

The New/Edit Stored Procedure dialog has been enhanced with a larger default window size, improving visibility of the ar...
04/21/2026

The New/Edit Stored Procedure dialog has been enhanced with a larger default window size, improving visibility of the argument list.

When creating a stored procedure, users define arguments including name, data type, and comments. These definitions are significant, as the number and data types of arguments provided during ex*****on must match those specified at creation.

The enhanced dialog allows for full visibility of all defined arguments and their associated comments. Additionally, user-adjusted window sizing is preserved between sessions, further improving usability and efficiency when managing stored procedures.

A new Data Browser setting has been added to display the connected database name and path in the Data Browser title bar....
04/20/2026

A new Data Browser setting has been added to display the connected database name and path in the Data Browser title bar.

This option is especially beneficial for users who connect to multiple database instances that contain identical or similar table names, making it easier to distinguish between environments.

Note: The Database in Title Bar setting applies only to R:BASE sessions. Applications running under Runtime for R:BASE or R:Compiler for R:BASE will not display database information in the Data Browser title bar.

The following outlines what each General Option setting provides, allowing you to customize the appearance of the Data Browser to suit your preferences:
https://www.rbase.com/support/rsyntax/general_options.html

The Enhanced DB Grid control now includes a new Indicator Width property, allowing the pointer column width to be adjust...
04/17/2026

The Enhanced DB Grid control now includes a new Indicator Width property, allowing the pointer column width to be adjusted as needed.

The indicator is the small pointer displayed in the first column of the grid that identifies the currently selected row. Its visibility is controlled by the Indicator option on the Properties tab.

With the addition of the Indicator Width property, the width of the indicator column can be customized to suit display preferences.

The following example demonstrates how to enable the indicator and adjust its width within a form EEP:

PROPERTY SHOWINDICATOR 'TRUE'
PROPERTY WIDTHOFINDICATOR 20

The Keys/Indexes area of the Data Designer has been enhanced to display Column(s) by default within the list, making it ...
04/16/2026

The Keys/Indexes area of the Data Designer has been enhanced to display Column(s) by default within the list, making it easier to quickly identify indexed columns.

The Column(s) field shows the column name associated with each key or index. For multi-column indexes, the columns are displayed as a comma-separated list. The Column(s) panel remains available on the right side of the list, providing additional details such as column sort direction and size.

Sorting capabilities have also been added to the list, allowing column names to be located alphabetically. This enhancement is particularly useful when reviewing the Duplicate Factor list (sorted in descending order) to identify inefficient index definitions, where unnecessary or poorly defined indexes may be candidates for removal.

While this enhancement may appear minor, it significantly improves usability when working with tables that contain many keys or indexes. The benefit is especially noticeable when dealing with unnamed or multi-column indexes. Previously, users were required to manually select each index, review its column definitions, and remember or document the details.

04/15/2026

New column-level PROPERTY command parameters have been introduced to support loading BLOB data from a file and saving BLOB data to a file.

New Parameters:

. LOADFROMFILE
. SAVETOFILE

Syntax:

PROPERTY TABLE_COLUMN [TableName->ColumnName] LOADFROMFILE 'Value'

PROPERTY TABLE_COLUMN [TableName->ColumnName] SAVETOFILE 'Value'

Parameters:

. TABLE_COLUMN [TableName->ColumnName]
Specifies the table and column to modify.
. Value
Specifies the file name used for the load or save operation.

These new parameters enable developers to programmatically load file contents into a BLOB field or save BLOB data from the in-memory dataset to an external file.

Additional Column-Level Parameters:

. TEXTVALUE - Updates the field value
. SETTONULL - Sets the field value to NULL
. SHOWEDITOR - Launches the BLOB Editor for the column

Examples:

Example 01 – Load a BLOB from a file:
PROPERTY TABLE_COLUMN [Contact->ContPhoto] LOADFROMFILE 'NewPhoto.jpg'

Example 02 – Save BLOB data to a file:
PROPERTY TABLE_COLUMN [Contact->ContPhoto] SAVETOFILE 'CurrentPhoto.jpg'

Documentation Update
The "Managing BLOBs" technical document in the From The Edge series has been updated to reflect the enhanced PROPERTY command.

From The Edge:
https://www.razzak.com/fte/

"Managing BLOBs" Table of Contents:

. Part I: Introduction
. Part II: The Data Types
. Part III: R:BASE BLOB Editor
. Part IV: Displaying BLOBs in Forms
. Part V: Displaying BLOBs in Reports/Labels
. Part VI: Using Commands with BLOBs
. Part VII: Managing Database Stored Files
. Part VIII: BLOB Editor Settings
. Part IX: Sample Use of BLOBs

The Data Browser has been enhanced to display extended field definition details in the status bar for the currently focu...
04/14/2026

The Data Browser has been enhanced to display extended field definition details in the status bar for the currently focused column.

The enhanced status bar pane may include one or more of the following field attributes:

. Primary Key
. Referenced Key indicator
. Foreign Key
. Index with sort direction
. AUTONUM with Next and Increment values
. Not NULL constraint

These additions complement the existing status bar information, which includes:

. Table Name
. Field Name
. Datatype and Length
. Computed and Expression details
. Comment/Description

This extended field information provides immediate context while browsing tables and tabbing through columns, improving efficiency when analyzing and understanding column data.

Address

Murrysville, PA

Opening Hours

Monday 9am - 6pm
Tuesday 9am - 6pm
Wednesday 9am - 6pm
Thursday 9am - 6pm
Friday 9am - 6pm

Telephone

+17247330053

Alerts

Be the first to know and let us send you an email when R:BASE posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to R:BASE:

Share