How to modify the DatabaseName stored with a DADE Query Currently when DADE is used to create dataviews, the DatabaseName is stored as part of the query definition. (This is consistent with Delphi’s approach to specifying a database connection for a Query object). In some cases, you may decide that the DatabaseName needs to be  Full Article…

TECH TIP: Limitations of using TdaSQL.SQLText The TdaSQL object can contain either an object based description of the SQL (SelectTables[], SelectFields[], etc.) that it uses to generate SQLText OR it contain a SQLText string. If you specify the SQLText string then TdaSQL will not generate any SQLText. Therefore the built-in AutoSearch and Linking features can no  Full Article…

TECH TIP: SQL Expression for SubString SQL Expressions can be entered via the Calc page of RB’s Query Designer. Select a field and then select Expression as the function type. Type in the desired expression. Most database engines support built-in SQL expressions for functions such as SubString. Consult the database product’s documentation for a full  Full Article…