Installation Manual

Chapter 4. Design 111
© 2018 Bodno
SELECT column_name(s)
FROM table_name
Lets consider the example below, from our internal database, where we
select the position, extension and salary fields, from the employee database.
This is the first step, the second is to set a condition, only consider the records
with the field salary with a value lower than 35000.
Now the selection is made and the condition is set.
User Column - Here you define what column will be listed on the combo
box, as a reference to the Data Column.
Data Column - Define to wish column belong the data that will be shown on
the database list object.
Limit Rows - Setup the maximum rows to be listed on the combo box, to a
maximum of 99.
After we define the User Column as 0 and the Data Column as 1, we define
the column to be listed as the first (the count starts from zero) and the Data
Column as the second and the result will be as shown below.