schede

09 giugno 2010

SQL syntax for Money Manager EX



MMEX Support Forum


SQL syntax
by jaworski_m on Sun May 31, 2009 4:29 am
Hello,
Where can I find table names etc and other detail how to build SQL queries in MMEX?
Thank you.

by DickyP on Sun May 31, 2009 7:27 am
The easy way is to download and use a tool such as the standalone 'SQLiteMan' from http://sqliteman.com/ or the Web based addon for Firefox, 'SQLiteManager' from http://www.sqlitemanager.org/ - I use the former normally but both work equally well to investigate the structure of the MMEX SQLite database.
For details of the SQLite flavour of SQL go to http://www.sqlite.org/lang.html.