The script will use SQLite3.dll or SQLite3_圆4.dll if compiled as a 圆4 App. If anyone knows, I would be pleased to get some help on this.Īll the other functions, including the double click in the ListView do work. When compiled as 64bit, double click does not function in the main menu, I don't know why but I cannot get this fixed. Read the section for more details about dynamic parameters. The drawback is that the SQL is not easy to read or to maintain, but look at the example ' Invoice with details' where I join 8 tables. The SQL scripts are stored in the ini file, where 3 sections ‘Titles, SQL and Parameters’ contain all the elements required for a report.įor simplicity, I decided to store the SQL script in the ini file as a single line. Of course you have to know SQL but I guess that everyone who programs SQLite will, right? SQL that do not deliver data (no rows, no columns) will display a popup message instead (for example using the VACUUM command).Fast, even with several thousands of rows (see Track report).Double click on a row and a new Window will display the row vertically, usefull for rows with many columns.
Multi-line fields will display in a separate Window when you click on the cell containing multiline data (which cannot be displayed in a listview, if you click on a normal cell, the window will disapear.Up to 2 dynamic Parameters via input dialog box per report.I created 20 different reports, from which 4 are system reports and one is not linked to any table. You can download the zipfile in the link hereunder. All required files are contained in the zip file.
I provide a full functional example using the Chinook Demo Database ( ), so everyone can test it. Single Date, period, string or number input are possible The script supports up to two dynamic parameters per report, see the 'SQLite Reports.ini' file for more details. This is a Report Generator for SQLite Database.
0 kommentar(er)
