Re: [sqlite] Re: Oddball query required

2007-06-30 Thread Lucas (a.k.a T-Bird or bsdfan3)
Thank you very much Igor. This will do exactly what I need. Igor Tandetnik wrote: Lucas (a.k.a T-Bird or bsdfan3) <[EMAIL PROTECTED]> wrote: I am using SQLite in an application within a game where I have a table of player nicknames and cumulative player scores (among other things). Ho

[sqlite] Oddball query required

2007-06-30 Thread Lucas (a.k.a T-Bird or bsdfan3)
I am using SQLite in an application within a game where I have a table of player nicknames and cumulative player scores (among other things). How do I figure out at what (numeric) one of these records would be at if the table were sorted, say, by the cumulative scores column? Or should I

Re: [sqlite] Why do you use SQLite? Comments for an article needed

2007-06-09 Thread Lucas (a.k.a T-Bird or bsdfan3)
I personally like it for embedded (in other applications) jobs because of its small code footprint compared to a RDBMS. Tim Anderson wrote: Many thanks to those who have commented (more are welcome of course; though I won't be able to use all of them). I'll post a link to the piece when it

[sqlite] [Fwd: rummage bin of C API questions]

2007-01-25 Thread Lucas (a.k.a T-Bird or bsdfan3)
Please bear with me here, as this list may seem rather long. 1) Which of the C API routines allocate memory that my code must free? 2) Can COMMIT TRANSACTION and ROLLBACK TRANSACTION fail? 3) Which of the C API routines cannot fail? 4) C API routines with pointer return values return NULL