Editors: Populating a List from a SQL Query

[Beta Spark]

Static data is easily populated in a List control Editor using the 'user defined settings' to store the options for a field. If the data in the List control needs to be populated from a SQL table, however, the values to display in the List need to be fetched from the server before you can show them. This can be done when the server-side onDialogInitialize event is executed. The data fetched from the SQL table can be cached client-side. The List control can then be populated with the cached data when the Editor's set value event is executed.

Watch the video below to learn more.

List Control Editor - Dynamically Populate with SQL Data



Video Link: http://www.alphasoftware.com/video-library/?v=4942

Prerequisite Knowledge Base

See these other great videos on using List controls as an editor:

• Editors: Cascading List Control: Discover how to use a List control as a cascading editor - choices for a city field are filtered based on the value in a state field.

[Selwyn Rabins]

Please note: The technique shown in this video is now obsolete. It is now much easier to dynamically populate a list control editor using a client-side data cache and the configuration genie for the editor in the FormView editor.