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
Controls by form
Form name Control name Control type Caption X,Y Width,Height Root form Data source Events by control Required Format
name com_postcode Combo box   37,204 310,30 MainForm 
SELECT 
	"postcode"."postcode" || ' ' || "town"."town" 
FROM 
	"postcode", 
	"town" 
WHERE 
	"postcode"."town_ID" = "town"."ID" 
ORDER BY 
	"postcode"."postcode" ASC
 OnTextChanged ✔  
  com_street Combo box   37,147 310,30 MainForm 
SELECT 
	"street" 
FROM 
	"street" 
ORDER BY 
	"street" ASC
 OnTextChanged ✔  
  combofields Hidden control       MainForm        
  fmtID Formatted   37,40 85,30 MainForm ID   ✔ Standard
  lblfirstname Fixed firstname 37,74 73,18 MainForm        
  lblID Fixed ID 37,21 73,18 MainForm        
  lbllastname Fixed lastname 362,74 73,18 MainForm        
  lblnumber Fixed number 362,128 73,18 MainForm        
  lblpostcode_ID Fixed postcode > town 37,186 127,19 MainForm        
  lblstreet_ID Fixed street 37,128 73,18 MainForm        
  txtfirstname Text   38,91 308,29 MainForm firstname   ✔  
  txtlastname Text   362,91 308,29 MainForm lastname   ✔  
  txtnumber Text   364,147 56,30 MainForm number   ✔  
name_correlated_subquery com_postcode Combo box   37,204 310,30 MainForm 
SELECT 
	"postcode"."postcode" || ' ' || "town"."town" 
FROM 
	"postcode", 
	"town" 
WHERE 
	"postcode"."town_ID" = "town"."ID" 
ORDER BY 
	"postcode"."postcode" ASC
   ✔  
  com_street Combo box   37,147 310,30 MainForm 
SELECT 
	"street" 
FROM 
	"street" 
ORDER BY 
	"street" ASC
   ✔  
  combofields Hidden control       MainForm        
  fmtID Formatted   37,40 85,30 MainForm ID   ✔ Standard
  lblfirstname Fixed firstname 37,74 73,18 MainForm        
  lblID Fixed ID 37,21 73,18 MainForm        
  lbllastname Fixed lastname 362,74 73,18 MainForm        
  lblnumber Fixed number 362,128 73,18 MainForm        
  lblpostcode_ID Fixed postcode and town 37,186 127,19 MainForm        
  lblstreet_ID Fixed street 37,128 73,18 MainForm        
  txtfirstname Text   38,91 308,29 MainForm firstname   ✔  
  txtlastname Text   362,91 308,29 MainForm lastname   ✔  
  txtnumber Text   364,147 56,30 MainForm number   ✔  
name_tablecontrol combofields Hidden control       MainForm        
  tablecontrol Gridcontrol   37,37 726,379 MainForm        
  … com_postcode Combo box postcode and town     MainForm 
SELECT 
	"postcode"."postcode" || ' ' || "town"."town" 
FROM 
	"postcode", 
	"town" 
WHERE 
	"postcode"."town_ID" = "town"."ID" 
ORDER BY 
	"postcode"."postcode" || ' ' || "town"."town" ASC
      
  … com_street Combo box street     MainForm 
SELECT 
	"street" 
FROM 
	"street" 
ORDER BY 
	"street" ASC
      
  … firstname Text firstname     MainForm firstname   ✔  
  … ID Formatted ID     MainForm ID   ✔ Standard
  … lastname Text lastname     MainForm lastname   ✔  
  … number Text number     MainForm number   ✔