I've now setup a daily task on my computer to run a "correct" daily report, and output that to HTML. If anyone else wants to try this, the attached ZIP file contains the following files:
1. sqlite3.exe - command line interface for SQLite databases, from
http://www.sqlite.org/2. sql.bat - a windows batch file to run the SQL
3. sql.txt - SQL statements to run the report
To use this, extract the zip file, and put the 3 files in your Radarbox folder (normally C:\Program FIles\Airnav Systems\AirNav RadarBox 2009
Then run the sql.bat file. A file called report.htm will be created, that you can view in your internet browser. You can also use Windows Task Scheduler to schedule sql.bat to run just after midnight each day.
Some explanation of the contents of each file:
1. sql.bat contains
sqlite3 "Data\MyLog.db3" ".read sql.txt"The first argument is the location of your MyLog database. The second argument is a pointer to the file that contains your SQL statements.
2. sql.txt contains a series of statements to generate a daily report in HTML format. A full explanation of all the statements that can be used is at
http://www.sqlite.org/sqlite.html