LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Example_Combobox_Listfield.odb
File actual save date2018-06-26 17:10:26
Scanning done on2018-08-21 16:59:36
Documentation generated on2018-08-21 16:59:47
Table of contents
Example_Combobox_Listfield
List of modules
Location Library Module name Module type Number of code lines Procedures by module Declaratives
Document Standard Comboboxes Standard 373 ColumnSize
GenerateRecordAction
ShowText
String_to_SQL
TextSelectionSaveValue
REM  *****  BASIC  *****
REM The Modul "Comboboxen" changes combofields, where you could select or input new values, to
REM listfields with the possibility to enter new values. The foreignkeys for the listfield are saved in
REM the table, which is datasorce of the form. This keys were read out when form is loaded and every time a new row is entered.
REM The comboboxes are set to the value correlating to this key. This is only necessary if the datasource of the table
REM isn't created by a query, special a correlating subquery as shown in this database.

REM Before saving the whole row of the form the content of the listboxes would be saved, if it has been changed.
REM The key will be detected and written down in teh field for the foreignkey.
REM There wouldn't be recognized any action of a field, which isn't connected to the datasource. "GenerateRecordAction" will
REM generate this action. So the form recognize it when the content of the comboboxes would be changed.
REM Also this is only necessary if the datasource of the table
REM isn't created by a query, special a correlating subquery as shown in this database.