Codes Bank Opton
| [Previous] [Main] [Next] |
Codes Bank Option
· | Checkboxes (for columns other than boolean - if available). Your company might want to use a check box for Char(1) fields and store a "Y" and "N" or "T" and "F" or a numeric column and store 1 and 0 for true and false.
|
· | ComboBoxes - A field might have a limited number of options that you want users to forced to choose between. The list of options and what should be stored in the SQL table to correspond to each option must be obtained from somewhere.
|
· | Editable ComboBoxes - this is similar to the ComboBox above except that the user can add options.
|
· | Radio buttons. - the number of buttons, what each should say and what should be stored in the SQL table to correspond to each button are stored in the Codes Bank.
|
· | Multiple Select ComboBox (JList). In this case a number of options are presented to the user in one scrolling list. They pick as many as they want. JGuiGen assumes that each option is stored in its own field. The Codes Bank is used to indicate the fields, the value to be stored if an option is selected, the value to selected if an option is not selected and the prompt the user sees in the scrolling list.
|
· | Checkboxes - Check boxes can have an associated text to the right or you can use JGuiGen standard label on the left side of each column for the text. Fill in the Visual Value if you want the text to the right of the checkbox. Leave it blank if you do not want the text. You need two records and they should have different Sort Numbers. The lowest one will have the "Selected" value in the DatabaseValue field (i.e. Y if you want your table to contain a Y if your checkbox is selected.) The seoond record will have the value to be stored in your table if the item is NOT selected. (i.e. N if you want your table to contain an N if your checkbox is NOT selected.)
|
· | ComboBoxes - You will have one record in the Codes Bank for each option to appear in your drop down combobox. The Visual Value is what the user sees and the Database Value is what is stored in your table. Leave the Database Value empty if you want to store the Visual Value in your table. For example your combox box might contain "Married", "Single" and "Divorced" You could put "M", "S", and "D" in the database Value fields or your could leave these fields blank and your table will contain the words "Married", "Single" and "Divorced".
|
· | Editable ComboBoxes - this is similar to the ComboBox above except that the DataBase Values must be blank. Since the user can add a new value and there will be no corresponding value of the table for that entry, there cannot be a database Value for any of the entries.
|
· | Radio buttons. - You will have one entry for each button. Place the name to appear in the button in the Visual Value Field and the value to be saved in your table when the button is pressed inthe Database Value field.
|
· | Multiple Select ComboBox (JList). This is the most complex of the components.
|