Article Details
Id: | 11760 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 2.00.04 |
Opened: | 20/02/2014 |
Closed: | 14/03/2014 |
Released: | 25/03/2014 |
Job: | J012877 |
Page Sets; DBComboBox with a Data Source Type of 'Database Query' is now fully supported
On the DBComboBox page of the Page Object wizard, selecting a Data Source Type of 'Database Query' now allows you to specify the following:
- Id Field
- Desc Field
- SQL Query
The Id Field is the name of the field in the SQL Query that is to appear in the textbox area of the DBComboBox. The Desc Field (Description Field) is the name of the field that is to appear in the caption to the right of the textbox area.
A new RefreshDatabaseQuery method is available from Script code to bind the DBComboBox from code, e.g.:
cboTest.RefreshDatabaseQuery("Select AccountId,Name,Description From Account Order By AccountId", "AccountId", "Description")