Re: [sqlite] Database handle(sqlite3_stmt)

2009-04-07 Thread Joanne Pham
, 2009 8:10:58 PM Subject: Re: [sqlite] Database handle(sqlite3_stmt) "Joanne Pham" wrote in message news:677762.12434...@web90302.mail.mud.yahoo.com > Can we use one statement handle for both insert and select? Of course not. When you call sqlite3_prepare, you pass the query text and

Re: [sqlite] Database handle(sqlite3_stmt)

2009-04-06 Thread Igor Tandetnik
"Joanne Pham" wrote in message news:677762.12434...@web90302.mail.mud.yahoo.com > Can we use one statement handle for both insert and select? Of course not. When you call sqlite3_prepare, you pass the query text and get back the statement handle. The query can't begin both with SELECT and with

Re: [sqlite] Database handle(sqlite3_stmt)

2009-04-06 Thread Joanne Pham
: [sqlite] Database handle(sqlite3_stmt) Joanne Pham wrote: > Is sqlite allowing to use the same datbase handle(sqlite3_stmt) for > both read and insert operation. Are you talking about database handle (sqlite3*) or statement handle (sqlite3_stmt*)? Your question is confusing. Yes, y

Re: [sqlite] Database handle(sqlite3_stmt)

2009-04-06 Thread Igor Tandetnik
Joanne Pham wrote: > Is sqlite allowing to use the same datbase handle(sqlite3_stmt) for > both read and insert operation. Are you talking about database handle (sqlite3*) or statement handle (sqlite3_stmt*)? Your question is confusing. Yes, you can issue both SELECT and INSERT statements over

[sqlite] Database handle(sqlite3_stmt)

2009-04-06 Thread Joanne Pham
Hi All, Is sqlite allowing to use the same datbase handle(sqlite3_stmt) for both read and insert operation. Basislly onehandle(sqlite3_stmt) is inside the transaction which hasn't commited yet and the same handle is used for the read of the same database. Is this ok to use one handle for both op