Searchable Browser Fields

  • Edit

This article explains how to solve searching problems for Browser Form columns.

The SQL query in the Panels_Start of the form's AutoScript must be defined in a way that there is no conflict between the field names (or the combination table_name.field_name)

Provide not only the "Data" property but also the "Table" property of the "List" component of the Properties Window (at Design Time) in order to achieve unique pair of table/field name.

It is possible to define aliases like:

SELECT CUSTOMER.NAME AS [CUSTOMER.NAME] some SQL dialects in order to achieve unique field name.