LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Example_serial_Number_Year.odb
File actual save date2018-06-27 14:04:54
Scanning done on2018-08-21 17:40:52
Documentation generated on2018-08-21 17:41:03
Table of contents
Example_serial_Number_Year
List of queries
Query name Query type List of fields SQL
new_ID_current_year SELECT Details
SELECT 
MAX("ID") "max_ID",
MAX("ID") + 1 "new_ID",
"year"
FROM
"orders"
WHERE
"year" = YEAR(
NOW())
GROUP BY
"year"