A set of sample databases has been created by Robert Großkopf to accompany the "Base Handbook".
You can find them HERE :
• Example_Sport.odb (Chapter 1, "Introduction to Base")
• Example_jump_Cursor_Subform_Mainform.odb (Chapter 4, "Forms")
• Example_Report_Bill.odb (Chapter 6, "Reports")
• Example_Autotext_Searchmark_Spelling.odb (Chapter 8, "Database tasks")
• Example_Documents_Import_Export.odb (Chapter 8, "Database tasks")
• Example_Search_and_Filter.odb (Chapter 9, "Macros")
• Example_direct_Calculation_Form.odb (Chapter 9, "Macros")
• Example_Combobox_Listfield.odb (Chapter 9, "Macros")
• Example_serial_Number_Year.odb (Chapter 9, "Macros")
• Example_Mail_File_activate.odb (Chapter 9, "Macros")
• Example_Dialogs.odb (Chapter 9, "Macros")
Additional files:
• Media_with_Macros.odb
• Media_without_Macros.odb |
RDBMS
HSQL Database Engine 1.8.0
File location
/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Example_Search_and_Filter.odb
Connection string
sdbc:embedded:hsqldb
Connection by user
SA
Quoting character for table & field names
"
Field types [* max. length]
TINYINT
BIGINT
LONGVARBINARY * 2147483647
VARBINARY * 2147483647
BINARY * 2147483647
LONGVARCHAR * 2147483647
CHAR * 2147483647
NUMERIC
DECIMAL
INTEGER
SMALLINT
FLOAT
REAL
DOUBLE
VARCHAR * 2147483647
VARCHAR_IGNORECASE * 2147483647
BOOLEAN
DATE
TIME
TIMESTAMP
OTHER
|
Options used for documentation generation :
✔ Scan tables
✔ Collect data samples
✔ Collect data statistics
✔ Scan queries
✔ Parse and beautify SQL code
✔ Scan forms
✔ Include form screenshots in output pages
✔ Scan dialogs
✔ Include dialog screenshots in output pages
✖ Include dialogs stored in preloaded libraries
✖ Scan toolbar buttons
✔ Scan modules
✔ Parse Basic procedures
✖ Include modules stored in preloaded Basic libraries
Dependencies between items are identified when :
✔ a table or a query name is used as a literal in a Basic procedure
✔ a table or a query is the record source of a form or a subform
✔ a table or a query is the data source of a list- or combobox
✔ a table or a query is referenced in a SQL statement
✔ a form name is used as a literal in a Basic procedure
✔ a dialog name is used as a literal in a Basic procedure
✔ a procedure is referenced in a document event
✔ a procedure is referenced in a form event
✔ a procedure is referenced in a dialog event
✔ a procedure is referenced in a (form or dialog) control event
✖ a procedure is referenced by a toolbar button
✔ a procedure is called by another procedure
|
