Hi,
Its fairly straight forward to do with sql statements (assuming you have designed your sql tables properly and have created the right indexes with your primary key and whatever sort order you are wanting to go through the database - you need an ability to uniquely identify each row, that is the big gotcha). I've seen it done on other database engines - as everything I've read about sqllite's sql implementation there is no reason to suggest that it won't work in that engine either - like I said a bit of code to make it happen.
Cheers.
M
|