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…

Question “How do I search the available dataviews created in DADE for a specific one?” Solution Use the TppDataView.Description property to find the name of each dataview and locate the one you need.  Start by accessing the datamodule using the daGetDataModule routine.  Next loop through each dataview in the TppDataModule.DataViews list to find the desired  Full Article…