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