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 -R directory.
>
> But the
"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 SQLITE_UPDATE call. But the
"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
> ... )
No. Create a temporar
Guillaume Schub
wrote:
> sqlite3_create_function(m_pDB, "ScorePosition", "ScorePosition", 8,
> SQLITE_ANY, NULL, &ScorePosition, NULL, NULL);
>
> class MyClass
> {
> ...
> static void ScorePosition(sqlite3_context *pContext,int argc,
> sqlite3_value** argv);
> ...
> };
>
> No the problem is that t
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
> transaction seems to work if I
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
SQLite version 3.6.7
Enter ".help" for instructions
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, b
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 4:16
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 the
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-use
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' sta
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
sqlite3_status(SQLITE_STATUS_MEMOR
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 =
r
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 selection, so it doesn't come
>> from some othe
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 d
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 that Sqlite busy crashes a
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 itsel
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
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
19 matches
Mail list logo