Re: [sqlite] problem about sqlite3_sql

yes,that is the problem. thank you! On Wed, Feb 11, 2009 at 5:08 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > roamer wrote: > > the sqllite3.so did not contian sqlite3_sql or I have done something > wrong? > > Your application is probably

Re: [sqlite] How do I optimize a query in this situation?

"He Shiming" wrote in message news:9bcdad5eb1464353a7ab4142edd91...@wheelerlab >> Consider replacing this query with a programmatic loop using blob >> API: >> >> http://sqlite.org/c3ref/blob_open.html >> >> or simply running a query like this: >> >> SELECT bin_content FROM

Re: [sqlite] How do I optimize a query in this situation?

> > Consider replacing this query with a programmatic loop using blob API: > > http://sqlite.org/c3ref/blob_open.html > > or simply running a query like this: > > SELECT bin_content FROM FILE_CONTENT WHERE id = ?; > > with a new Id on every loop iteration. > > Igor Tandetnik > Thank you for the

[sqlite] sqlite3_finalize() vs sqlite3_reset()

Hi All, sqlite3_reset()  function is called to reset a prepared statement object back to its initial state, ready to be re-executed. So if the sqlite3_step is return back SQL_BUSY we need to retry the execution again do I need to call sqlite3_reset() before retry to execute again.   And after

Re: [sqlite] Full Table Read

On Fri, 13 Feb 2009 16:33:38 -0500, Nathan Biggs wrote in General Discussion of SQLite Database : >Is there a faster way to read an entire table other then: > >select * from table; It is the fastest SQL way. >Not that is is slow, just curious. The

[sqlite] Full Table Read

Is there a faster way to read an entire table other then: select * from table Not that is is slow, just curious. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] open/close db's across threads

On Fri, 13 Feb 2009 09:22:42 -0800, ed wrote in General Discussion of SQLite Database : >any help on this would be appreciated. >thanks, >ed Perhaps your question is too general to react upon. >-- Forwarded message -- > >Hello,I have

Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

Thanks Dan! I think I shouldn't call finalizeStmHandle(pReadStmt); before closeReportDB() Here is the codes: finalizeStmHandle(pReadStmt);   closeReportDB() ; (this function call closeDb(). Part of Stack trace: #0sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204 #1 

[sqlite] open/close db's across threads

any help on this would be appreciated. thanks, ed -- Forwarded message -- Hello,I have an application that is calling sqlite3_open() in one thread and sqlite3_close() in a different thread. The db's can potentially be opened and closed many times during execution of my app.

Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

On Feb 13, 2009, at 11:24 PM, Joanne Pham wrote: > Thanks for the respond! > So how can we find out the pStmt is valid or not. I did check to see > if it is not NULL before passing this sqlite3_finalize (pStmt=0x28). > To find out the valid handle is touch because the problem couldn't >

Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

Thanks for the respond! So how can we find out the pStmt is valid or not. I did check to see if it is not NULL before passing this sqlite3_finalize (pStmt=0x28). To find out the valid handle is touch because the problem couldn't duplicate all the time. Your response is greatly appreciated. JP

Re: [sqlite] SQLite Encryption Extension: Datatype misalignmenterror on WM 5.0

Thanks, It worked. Ulric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: February 13, 2009 10:49 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite Encryption Extension: Datatype

Re: [sqlite] SQLite Encryption Extension: Datatype misalignment error on WM 5.0

On Feb 13, 2009, at 10:31 AM, Ulric Auger wrote: > Hi > > I'm trying to use SQLite Encryption Extension on Windows Mobile 5.0 > but I'm > getting a "Datatype misalignment" error inside rijndaelKeySetupEnc256 > function. > > The Datatype misalignment occurs on the line: > rk[0] =

[sqlite] SQLite Encryption Extension: Datatype misalignment error on WM 5.0

Hi I'm trying to use SQLite Encryption Extension on Windows Mobile 5.0 but I'm getting a "Datatype misalignment" error inside rijndaelKeySetupEnc256 function. The Datatype misalignment occurs on the line: rk[0] = GETU32(cipherKey ); I'm using sqlite 3.6.10 with see.h Here is the complete

Re: [sqlite] How do I optimize a query in this situation?

"He Shiming" wrote in message news:c4118a5d0902130623g48e19a64pa4fea079ea7dc...@mail.gmail.com > I'm working on this project. It puts a lot of files into a single > sqlite database (including the actual file content, the program is > designed to store the actual content) for

Re: [sqlite] How do I optimize a query in this situation?

On Fri, Feb 13, 2009 at 8:23 AM, He Shiming wrote: > Hi, > > I'm working on this project. It puts a lot of files into a single sqlite > database (including the actual file content, the program is designed to > store the actual content) for search. When a search command is

[sqlite] How do I optimize a query in this situation?

Hi, I'm working on this project. It puts a lot of files into a single sqlite database (including the actual file content, the program is designed to store the actual content) for search. When a search command is issued, I run a SELECT command on the FILE_INFO table to get stuff like file name,

Re: [sqlite] using sqlite for searching

On Fri, 13 Feb 2009 16:06:42 +0530, aalap shah wrote in General Discussion of SQLite Database : >Hi, > >I am using sqlite3 for my search application and i want an optimized >way for retrieving values from table. I need a way in which I can >query

Re: [sqlite] using sqlite for searching

On Fri, Feb 13, 2009 at 4:36 AM, aalap shah wrote: > Hi, > > I am using sqlite3 for my search application and i want an optimized > way for retrieving values from table. I need a way in which I can > query records from the result of previous query based on next search >

Re: [sqlite] SQLite- Memory heap usage query

On Thu, 12 Feb 2009 19:14:44 -0800 (PST), jaya_kumar wrote in General Discussion of SQLite Database : > >I am trying to find the peak heap usage for creating a table with few entries >and when calculated the peak heap usage increases

[sqlite] using sqlite for searching

Hi, I am using sqlite3 for my search application and i want an optimized way for retrieving values from table. I need a way in which I can query records from the result of previous query based on next search character. so for example If i search for words starting with "a" then if user enters "b"