Re: [sqlite] RESOLVED: unable to open database file/Disc I/O error

No, I didn't explain correctly. My application is not open overnight, only the computer. So I do not have any database connections open at all, they are not going stale. In the morning, I start the application, and it opens some databases in readwrite mode and executes statements without errors.

Re: [sqlite] ODBC Driver

On Sat, 06 Nov 2010 15:36:46 +1100, "Len(c-sharplizards)" wrote: > I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? You don't give

Re: [sqlite] RESOLVED: unable to open database file/Disc I/O error

#1 What version of Sqlite and Windows client/server are you using? #2 What language is your application written in? #3 Are all your databases on the same share mount point? #4 Is your share mounted as a drive letter? Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop

Re: [sqlite] RESOLVED: unable to open database file/Disc I/O error

Also... Can you write a small example program to duplicate the problem and post it? That's the best way for us to help. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems From:

[sqlite] WAL hash collisions

In wal.c, it reads "8 or 10 comparisons (on average) suffice to either locate a frame in the WAL or to establish that the frame does not exist in the WAL". I'm wondering -- how often does it occur that only a small subset of pages is written to again and again, in sequence, such that the WAL

[sqlite] To close or not to close

I am fairly new to the SQLite world, and have a quick question: I have an application that migrates files form a windows environment to a solaris environment, and it can be run multi-threaded. I have seen several articles that show apps opening and closing the connection with each Query or

[sqlite] To close or not to close

I am fairly new to the SQLite world, and have a quick question: I have an application that migrates files form a windows environment to a solaris environment, and it can be run multi-threaded. I have seen several articles that show apps opening and closing the connection with each Query or

Re: [sqlite] ODBC Driver

> I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? The SQLite ODBC driver allows only one SQL statement per SQLExecDirect() and SQLPrepare(). When using

[sqlite] sqlite/fts3 feature request: select snippet() from fts3 where docid=1

Hello Do I understand correctly that fts3 snippet function does only work with match queries like select snippet(text) from text where text match 'foo' I would be interested to have: select snippet(text) from text where docid=1 In sqlite 3.7.2 this statement is valid but returns an empty

Re: [sqlite] To close or not to close

On Fri, Nov 5, 2010 at 2:47 PM, Chris Vernor wrote: > I am fairly new to the SQLite world, and have a quick question: > > > > I have an application that migrates files form a windows environment to > a solaris environment, and it can be run multi-threaded. I have seen >

Re: [sqlite] sqlite/fts3 feature request: select snippet() from fts3 where docid=1

On Sat, Nov 6, 2010 at 7:45 AM, Simon Hefti wrote: > Hello > > Do I understand correctly that fts3 snippet function does only work > with match queries like > select snippet(text) from text where text match 'foo' > > I would be interested to have: > select snippet(text)

[sqlite] re SQLite ODBC Driver,

Thanks Kees, Christian, SQLSetConnectAttrW(q->hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, 0); this is what I already had and I think you have answered the question with "The SQLite ODBC driver allows only one SQL statement per SQLExecDirect()", this is the conclusion that I

[sqlite] Question about manifest typing/data affinity

Hello, I have a question about manifest typing/data affinity. Assume I have created this table: CREATE TABLE foo (ROWID INTEGER PRIMARY KEY, key TEXT, attr TEXT, value NONE); I was reading the Using SQLite book and came across page #38 (#60 on the PDF version) where it states: "None: A

Re: [sqlite] Question about manifest typing/data affinity

Tito Ciuro wrote: > My main question has to do with binding values to precompiled statements. For > the value column, should I: > > a) use sqlite3_bind_value()? No, except in certain special cases. You would normally have no way to obtain sqlite_value pointer, anyway. > b)

Re: [sqlite] Question about manifest typing/data affinity

On 6 Nov 2010, at 11:35pm, Tito Ciuro wrote: > My main question has to do with binding values to precompiled statements. For > the value column, should I: > > a) use sqlite3_bind_value()? > b) store it as a string using sqlite3_bind_text()? Will sqlite3_bind_text() > allow SQLite to choose

Re: [sqlite] Question about manifest typing/data affinity

Quoth Tito Ciuro , on 2010-11-06 20:35:10 -0300: > "None: A column with a none affinity has no preference over storage > class. Each value is stored as the type provided, with no attempt to > convert anything." Note that type affinities are not usually specified as column types

Re: [sqlite] Question about manifest typing/data affinity

On Sat, Nov 06, 2010 at 08:35:10PM -0300, Tito Ciuro scratched on the wall: > Hello, > > I have a question about manifest typing/data affinity. Assume I have > created this table: > > CREATE TABLE foo (ROWID INTEGER PRIMARY KEY, key TEXT, attr TEXT, value NONE); > > I was reading the Using

[sqlite] sqlite3_step to select and update the same table

Hello, I am trying to select some columns from a table and use that to update another column in the same table using prepare/step/reset/finalize methods. However, when I use the update statement while stepping it is executing the flow 2 times. In order to clarify, I am pasting some pseudo