Additional properties

Top

Additional properties for the "Table" element.

Data Source Provider – selecting the way to access data. Two variants are possible: ADO and BDE.

Connection string – the string for connecting to the database.

If "ADO dataset" is selected, the connection string must be of the ADO format. Click the button to the right of the field to use the system constructor of a connection string.

If "BDE dataset" is selected, you should enter the alias registered in BDE into this field. Click the button to the right of the field to select an alias from the list of those registered.

SQL Query – the query text for generating a list. A query can contain a macro with a link to another dialog element. As a rule, macros are used in the "WHERE" section of a query. A simple macro constructor will help you correctly write a macro in the query text. Use the "Test SQL" button to test if a macro is written correctly.

Important note: If there is a macro in the query text, it is not expanded during the test and there may occur an error while testing.

Text Field – a query field associated with the "Text" field of the dialog element. The name of the field can be entered manually or selected from the drop-down list.

Value Field – a query field associated with the "Value" field of the dialog element. The name of the field can be entered manually or selected from the drop-down list.

"Unselected" text – the text of the dialog element (the "Text" field) corresponding to the «Unselected» value.

"Unselected" value – the value of the dialog element (the "Value" field) corresponding to the «Unselected» value.

The «Unselected» value can be useful when some particular value or the values «Any» and «All» can be selected while choosing the filter.


Additional parameters for the "List" element.

You should create a list of strings to select from in the "List" element. These strings will be displayed in the drop-down list. The "Text" field of the element will correspond to the selected string while the "Value" field will correspond to the number of this string beginning from '0'.