I'm monitoring a commonly used washroom and have written a C++ (it's what I know) app to do the crunching and generate a report. I have been exporting the SQLite ecm1.db3 database to a csv and reading the csv to generate the reports. Is there a way to directly read the SQLite database so I don't have to go through the export process? I've done a lot of programming using C++ and Access, and I would think it would be similar to that, but I just need to be pointed in the right direction for the tools to use with my app.
Thanks
reading ECM database
-
- Posts: 8
- Joined: Tue Jan 15, 2013 2:06 pm
-
- Site Admin
- Posts: 4266
- Joined: Fri Jun 04, 2010 9:39 am
Re: reading ECM database
I suggest downloading SQLiteMan (http://sqliteman.com/) or similar program and become familiar with the database structure.
Once familiar take a look at the following link: http://www.sqlite.org/cintro.html.
The export program was written in C#, I could provide the source if interested, send me an email ben(at)brultech.com.
Once familiar take a look at the following link: http://www.sqlite.org/cintro.html.
The export program was written in C#, I could provide the source if interested, send me an email ben(at)brultech.com.
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com