Dropdown Tool not responding to database query

Barrie Smith

My dropdown list does not show any items from my database query.

My grid and list tools are OK

 

I have tried using a calculation (using a connection) and an sql statement in the "list options" property, but my dropdown is disabled at run time.

 

Any suggestions please?

McGaw_Phil

Hi Barrie,

 

Try associating a business object variable or local form varibale with the dropdown list, and making sure the "default action behaviour" is set to either "Optional" or "Required".  In additon, make sure that on the action that the form is associated with also has the dropdown object as either "Optional" or "Required".

 

I'm sure your SELECT statement is fine, but if you want to just test the activation/enabling of the dropdown list with options, you might be tempted to throw a few hardcoded values in to the list options first, then add the SelectSql statement once you are happy with the form behaviour.

 

Hope that helps.

 

Phil