[sqlite] sqlite3_step()

Using sqlite 3.6.22.  Here's my sql SELECT sno, lname, fname FROM addressbook where sno? Suppose your stepping through a 100 row result set.  I'm calling sqlite3_step(), getting my values all good.  If I were to call sqlite3_bind_int() function with a new value for my where clause at row 50,

[sqlite] SQLITE_BUSY

I have two threads in a Linux process using sqlite 3.6.12 in shared cache mode. One thread opens the database file in read only mode (sqlite3_open_v2()), sets to read uncommitted and only ever performs selects from the database. The other thread inserts, updates and deletes rows from the

[sqlite] database filename

Given a sqlite3 * database handle, is there a way to retrieve the filename used to open the database? TIA __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] database filename

: [sqlite] database filename To: sqlite-users@sqlite.org Date: Saturday, October 18, 2008, 3:56 PM Mike Johnston [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Given a sqlite3 * database handle, is there a way to retrieve the filename used to open the database? Run this statement on your

Re: [sqlite] fetching and updating

connection but different thread (assuming sqlite compiled with multi-thread option turned on). Many thanks Igor Tandetnik [EMAIL PROTECTED] wrote: Mike Johnston wrote in message news:[EMAIL PROTECTED] I'm in a loop processing the result set using sqlite3_step. I need to insert/update the same

Re: [sqlite] fetching and updating

the sqlite3_step finishes and I do the release on the prepared statement? Is this correct? Igor Tandetnik [EMAIL PROTECTED] wrote: Mike Johnston wrote in message news:[EMAIL PROTECTED] I'm running the 3.5.7 version now. My understanding was that if I have a prepared statement and currently using

[sqlite] fetching and updating in Ruby

Hi, Does anyone on the list use the sqlite3 gem with Ruby? Is this list ok to post sqlite/ruby questions? Many thanks in advance Mike - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[sqlite] last_insert_rowid

Hi, So I'm using the last_insert_rowid() with no issue. The note at http://www.sqlite.org/c3ref/last_insert_rowid.html states that the function returns unpredictable results should a separate thread do a new insert. Does that apply to a separate process as well? I have two processes

Re: [sqlite] Proposed incompatible change to SQLite

Game on!! We'd love to see this happen. [EMAIL PROTECTED] wrote: We are considering a change to the SQLite API which is technically not backwards compatible. On the other hand, it is difficult to imagine a situation where the change would cause anyone any serious hardship. We suspect that most

Re: [sqlite] Views

Figueiredo wrote: On 7/6/07, Joe Wilson wrote: --- Mike Johnston wrote: I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. As long as your VIEW

[sqlite] Views

I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. Also, is it quicker to have sqlite do joins on primary keys between tables instead of doing three separate single

[sqlite] Views

n Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. Also, is it quicker to have sqlite do joins on primary

[sqlite] sqlite3_column_xxx question

While using sqlite3_step(), is there a clean easy way to retrieve the data by column name instead of by ordinal? I know I can convert an ordinal to a column name but not the other way around. TIA, Mike - Take the Internet to Go: Yahoo!Go puts the

Re: [sqlite] Re: sqlite3_column_xxx question

Absolutely but it seems like duplicate effort if sqlite already has the info. Any guess if this is a big deal to put into the source? Igor Tandetnik [EMAIL PROTECTED] wrote: Mike Johnston wrote: While using sqlite3_step(), is there a clean easy way to retrieve the data by column name

[sqlite] Column order in resultset

When doing a select * from foo and using sqlite3_step() with the associated sqlite3_column_xx funcs, is the order of the columns in the resultset deterministic? What is the rule that defines what the order? it seems to be the order of the create table statement but I can't seem to find where

[sqlite] Select columns performance

Are there any significant performance benefits by limiting the number of columns in a single table select statement? Does joining (5 tables) make a significant difference to that answer? TIA - TV dinner still cooling? Check out Tonight's Picks on

[sqlite] in memory databases

Hi, Is it possible to have memory databases located at a specific memory address? I have a battery backed memory I'd like to store specific information apart from the main database. Thanks, Mike - No need to miss a message. Get email on-the-go with Yahoo!