Does anyone know a good SQLITE 2 site, the SQLITE database I am using is a SQLITE 2 type and all the information I have found so far is talking in terms of SQLITE 3 which I do not want.
I have a couple of fields of information that need triggers for INSERT and UPDATE actions on the database. The one column will need adding up and that total inserted in to another table and same for the other which will be a value based on the last rowid in the current table.
So any useful resources on SQLite 2 would be helpful or if you know how to set the query triggers up I'd appreciate the tutorial.
Yeah, I have poked around that site but I am looking for someone who has done more with it as I would like to take advantage of its portability and for what I am about to attempt, it needs two internal triggers and the ability to either run an internal function to do the work or already have a built in feature.
Like most things technical, someone somewhere has the golden nugget tucked away on a book shelf...