11.2.4. dbCombobox

Last page update: November 09, 2011

Note

dbCombobox features:

• Type: Genro form widget

• Common attributes: you can check:

  • the widget common attributes section
  • the dbSelect and dbCombobox common attributes section

• Definition and Description
• Examples

11.2.4.1. Definition and Description

pane.dbcombobox([**kwargs])

The Genro dbCombobox is a ComboBox that conducts research on specific columns in a database table. While user write in the dbCombobox, partially matched values will be shown in a pop-up menu below the input text box. The dbCombobox has got the same parameters of the dbSelect, and allows to choose from values situated in the database AND from values that aren’t in the database. These “new” values aren’t added in the database but they have being placed in the datastore, so they can be handled from Genropy. [1]

To specify the table related to the dbCombobox you have to use the mandatory dbtable attribute.

11.2.4.2. Examples

Let’s see a code example:

class GnrCustomWebPage(object):
    def main(self,root,**kwargs):
        fb=root.formbuilder(datapath='test1')
        fb.div("""In a "dbCombobox" you can draw record values from a database (not the ID!).
                  The difference with the "dbSelect" is the possibility to add NEW records.""")
        fb.div('For example, try to draw an actor from the first "dbCombobox"...')
        fb.dbCombobox(dbtable='showcase.person',value='^.person',lbl='Star')
        fb.div('... and then write a film not in the database.')
        fb.dbCombobox(dbtable='showcase.movie',value='^.movie',lbl='Movie')
        fb.div('After that, check in the datasource your saved records')

Footnotes

[1]	We remember to you that dbCombobox supports only the values (not the keys!); so the main dbCombobox feature is that it permits to enter values in the datastore, but they won’t be stored in the database.