Re: [sqlite] [perl] unable to open database file

see if you can open the sqlite file from the command line with sqlite3 On Wed, Dec 17, 2008 at 11:30 PM, LUKE wrote: > DBD::SQLite::st execute failed: unable to open database file(14) at dbdimp.c > line > 423 > 1. I use root to run the program. > 2. I try to chmod 777

Re: [sqlite] Find out difference before and after update with cb

"Daniel Schnell" wrote in message news:494a68d0.8000...@marel.com > is there a possibility to find out the difference before and after an > update of a table through the update callback ? > > I know that I can register a callback to a table for getting the rowid > of an

Re: [sqlite] IN expression performance

"Sander Jansen" wrote in message news:2d51e2b10812180940s7df743e7lf8dcd2d82c5df...@mail.gmail.com > Is there a way to use a prepared statement and bind a (variable) array > of integers? > > Like in: > SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 > ... )

Re: [sqlite] sqlite3_create_function callback problem

Guillaume Schub wrote: > sqlite3_create_function(m_pDB, "ScorePosition", "ScorePosition", 8, > SQLITE_ANY, NULL, , NULL, NULL); > > class MyClass > { > ... > static void ScorePosition(sqlite3_context *pContext,int argc, > sqlite3_value** argv); > ... > }; > > No the problem

Re: [sqlite] cannot commit transaction - SQL statements in progress

Pankaj Gupta wrote: > I'm using SQLite 3.6.3 with C++ and Qt. > > My problem is that when a use a select statement in a transaction > containing insert statements, I get an error: "cannot commit > transaction - SQL statements in progress - Unable to fetch row". The >

Re: [sqlite] how to load in file and outfile

On Wed, 17 Dec 2008 06:38:29 -0800 (PST), Rachmat Febfauza wrote in General Discussion of SQLite Database : >how to do load infile and into outfile like mysql does in sqlite? == Export == C:\yourdir> sqlite3 yourdatabase

Re: [sqlite] IN expression performance

Regarding: Is there a way to use a prepared statement and bind a (variable) array of integers? Like in: SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 ... ) Becomes: SELECT FROM table WHERE someinteger IN ( ? ) I don't know that you can bind these,

Re: [sqlite] IN expression performance

One more question though, Is there a way to use a prepared statement and bind a (variable) array of integers? Like in: SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 ... ) Becomes: SELECT FROM table WHERE someinteger IN ( ? ) Thanks, Sander On Mon, Dec 15, 2008 at

[sqlite] Find out difference before and after update with cb

Hi, is there a possibility to find out the difference before and after an update of a table through the update callback ? I know that I can register a callback to a table for getting the rowid of an SQLITE_UPDATE call. But the documentation doesn't state, if the callback can still retrieve

[sqlite] [perl] unable to open database file

DBD::SQLite::st execute failed: unable to open database file(14) at dbdimp.c line 423 1. I use root to run the program. 2. I try to chmod 777 -R directory. But the error is still exist. How to debug the program? ___ sqlite-users mailing list

[sqlite] cannot commit transaction - SQL statements in progress

Hi! I'm using SQLite 3.6.3 with C++ and Qt. My problem is that when a use a select statement in a transaction containing insert statements, I get an error: "cannot commit transaction - SQL statements in progress - Unable to fetch row". The transaction seems to work if I remove the 'select'

[sqlite] memory usage

Hello,My application has several sqlite db's open simultaneously, in memory using the :memory: keyword, disk based db's and at times, tmpfs based db's. Is there a way to view each individual database's memory usage? I found the functions sqlite3_memory_used() and

Re: [sqlite] sqlite3_create_function callback problem

Guillaume, This is my callback function. As Martin suggested, it's defined outside of any class. It looks to me like you're not passing the correct parameters tothe create function. static void sqlite3_regexp(sqlite3_context *pDB, int argc, sqlite3_value **argv) { CDBSqLite3* pThis =

Re: [sqlite] IN expression performance

thanks! On Mon, Dec 15, 2008 at 4:16 PM, Igor Tandetnik wrote: > Sander Jansen wrote: >> Suppose I have query that does: >> >> SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 >> ); >> >> The list of numbers comes from a user

[sqlite] sqlite memory usage

Hello,My first mail attempt appears not to have gotten through yesterday due to the spam storm. My multi-threaded application has various sqlite db's open simultaneously, in memory using the :memory: keyword, disk based db's and at times, tmpfs based db's. Is there a way to view each individual

Re: [sqlite] TCL Sqlite busy errorcode

pretty vague question. I recommend you supply more details like: what "other website" What version of SQLite are they referring to. What Platform was it running on. On Wed, Dec 17, 2008 at 6:48 PM, Denise Johnson wrote: > I was reading another site that mentioned

[sqlite] SQLite.org servers overwhelmed by spam email

Yesterday (2008-12-17) some spammer someplace started an email promotion of an "enhancement" product. The forged sender addresses on the spam emails all use the "sqlite.org" domain. The emails then bounce back to our servers - overwhelming them. Be assured that the sqlite.org server is not

[sqlite] TCL Sqlite busy errorcode

I was reading another site that mentioned that Sqlite busy crashes a TCL proc instead of returning an error code of 5. Is this true? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] TCL Sqlite busy errorcode

I was reading another site that mentioned that Sqlite busy crashes a TCL proc instead of returning an error code of 5. Is this true? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users