RE: [sqlite] Re: Update current record

al Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 5:50 PM To: SQLite Subject: [sqlite] Re: Update current record Tom Parke <[EMAIL PROTECTED]> wrote: > Using sqlite3_prepare and then sqlite3_step() ing through the records, > is there a wa

[sqlite] Update current record

Using sqlite3_prepare and then sqlite3_step() ing through the records, is there a way to update or replace the current record in a table while sqlite3_step() is on that record without a reselecting that record and sqlite3_exec() update table where? Something like a dynamic cursor in MS SQL?

[sqlite] sqlite3_exec() and callback

>From what I think I have learned so far, if I call sqlite3_exec() giving it a call back function and a select * from tbl, I do not have any direct access to the column values other that the text representation in the values char array from within the callback()? This leads me to the question,

RE: [sqlite] How to get number of records in record set

Thanks, that makes sense. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 7:50 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to get number of records in record set "Tom Parke" <[EMAIL PROTECTED]&g

[sqlite] How to get number of records in record set

If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n: How do I find out how many records were selected before calling step()? Tom

[sqlite] Another novice question

I created a table with column 1 as primary key. So where are the index records? I thought I would find them in the sqlite_stat1 table but after inserting records in my table, there are no records in the sqlite_stat1 table. And, do primary keys need to be the first consecutive n fields? I

[sqlite] How to get record count

How can I get a count of the number of records in a table? Sqlite3_get_table() might work, but I only need the count, not the record set. Thanks, Tom

[sqlite] sample code

Where can I find some sample C code for stepping thru a result set and for binding variables to columns? I am just beginning to experiment with Sqlite3 and I am having a hard time getting aquainted. Thanks, Tom