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")