On 24/03/2011, at 2:50 AM, Shalom Elkin wrote: > I appreciate the input. Some of the advice comes obviously from very good > and talented people who find a challenge at doing things WITHOUT reverting > to code writing.
Doing as much (or most often, all) of the logic in SQL (instead of application code) removes a level of complexity, but is also generally faster and internally consistent. > I did a small program. Current show -stopper : > > what is the API equivalent of > > PRAGMA foreign_keys = ON; You can just send each of the SQL commands, including the pragma statement, in sqlite_exec (or you can get fancy with sqlite_prepare etc where it makes sense). Tom BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
