Tuesday, June 16, 2026
Tip of the Day: Enhanced Variable Handling for Multiple ODBC Connections
Product: R:BASE 11
Build: 11.0.3.20611 or higher
Section: ODBC
Keywords: Variables, Query, Connections, SQL
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 execution 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
The Support Team
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 visit
https://groups.google.com/d/msgid/rbase-l/8ea83b43-1d66-77f9-0297-fb77fdc68f34%40rbase.com.
