Data selection

There is a tool, that creates a GUI out of a SQL-file having some additional commands in. Read here how this works

CheckBoxPanel is a GUI element, where one can select fields from. It has this structure:

 

#checkbox(Unique-tab-Title;filename)

 

To create such a panel, do something like this:

 

select distinct #checkbox(Attributes;employee-list.display) from garage, person, function, employe

The file 'employee-list.display' looks like this:


garage.name;Name of the Garage;Garage
garage.street;Street of the Garage;Street
garage.zip;Postalcode of the Garage;ZIP
garage.city;City of the garage;City
garage.email;E-Mail of the Garage;E-Mail
garage.phone;Phone of the Garage;Phone
person.firstname;Firstname of Employee;Firstname
person.lastname;Lastname of Employee;Lastname
person.phone;Employee direct Phone;Direct
function.function;Function;Function

Where each line contains three (3) items:

  1. the columname
  2. the text displayed within the gui
  3. the title displayed within the SQL-resultset

 

This will create a SQL-query like this:

 

select distinct
garage.name "Garage ",
garage.city "City ",
garage.phone "Phone ",
person.firstname "Firstname ",
person.lastname "Lastname ",
person.phone "Direct "
from   garage, person, function, employe