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 longer be used – because these require that special SQLText be generated.

If you want to use AutoSearch with a SQLText, you will need to handle this in your custom dataview code. For an example see RBuilder\Demos\AutoSearch and see the TdaQueryDataView.CreateAutoSearchFields and TdaQueryDataView.ReportGetAutoSearchValuesEvent methods in daQueryDataView.pas.