R:BASE

08/16/2026

Powered by R:BASE 11 and Oterro 11

For as long as I can remember, I've been obsessed with flying widebodies. Over the years, I've spent countless hours studying, analyzing, and sharing American Airlines' widebody schedule with anyone willing to listen! Finally, I found the time to combine our R:BASE 11 database, Oterro 11, and analytical tools with my unwavering passion for American Airlines to create something I believe will be genuinely valuable to the entire AAdvantage community—especially those who love widebody flying as much as I do.

Thanks to our incredible team for deploying my passion project on the cloud.

Here is a showcase of our products, tools, and in-house talent.

https://www.AAWidebody.com
https://www.AAWidebody.com/insights.html

Enjoy!

--Razzak

The AAdvantage community's free monthly widebody schedule resource. Interactive routes, aircraft types, and operating dates — August 2026 through March 2027.

06/17/2026

A new JOINPATH string manipulation function has been implemented to construct a proper system path regardless of trailing/leading slashes in the path subcomponents.

Syntax:

(JOINPATH(root,subdirectory))

Where:

root - specifies the directory root
subdirectory - specifies the sub-directory path

JOINPATH is supported with mapped drive letters and UNC paths.

Example:

SET VAR vRoot TEXT = 'C:'
SET VAR vSubDirectory TEXT = 'RBTI\RBG11\'
SET VAR vPath TEXT = (JOINPATH(.vRoot,.vSubDirectory))

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.

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.

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.

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

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

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.