R:BASE

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

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 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.