www.webdeveloper.com
Results 1 to 3 of 3

Thread: SQLite version 2

  1. #1
    Join Date
    Jan 2009
    Location
    Insanity
    Posts
    1,131

    SQLite version 2

    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.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    18,933
    Don't know if you've seen this already, but at the bottom of the SQLite.org Documentation page there is an "Old Documents" section with some version 2 stuff.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Jan 2009
    Location
    Insanity
    Posts
    1,131
    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...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles