KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Automatic List Box column creation with SQL
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: November 14, 2007
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Suppose you run a query using a SQL SELECT statement. It is possible to store the results in a List Box. When doing so, 4D v11 SQL automatically creates (or removes) List Box columns.

For example, a query that returns the results from 1 field will display 1 column in the list box; a query that returns 5 fields will display 5 columns. This is done automatically without having to change the list box's properties in the form editor.