Hi list:
Using SQLite 3.9.1, suppose a C++ application using FTS3/4 modules with this
pseudocode:
1a In config.h
#define SQLITE_ENABLE_FTS3 1
#define SQLITE_ENABLE_FTS3_PARENTHESIS 1
2a.- Delete the previous table if exist
DROP TABLE IF EXISTS ftsm
3a.- Then create the table
Is there something wrong or is there something missing from this sequence
of SQLite actions?
Note that all the return values are checked and are fine:
sqlite3_open_v2
sqlite3_create_function
sqlite3_prepare16_v2
run in loop till SQLITE_DONE:
sqlite3_step(lStatementHandle)
sqlite3_step will run t
Yes, I didn't think there was a bug in SQLite here, but just wanted some
confirmation. Thanks for that.
I suppose the only way to get to the bottom of this is to run sqlite3.dll,
compiled with SQLITE_DEBUG
and SQLITE_MEMDEBUG enabled and look at the log/trace.
RBS
On Wed, Nov 4, 2015 at 7:42 PM,
Been trying to get to the bottom of this, but no success.
Note that with one UDF in the statement all runs perfectly fine.
Could somebody confirm that they can run 2 UDF's (I have mainly tried with
the 2 the same UDF's) in the same SQL and that all
runs as how it should? Just to make sure there is
On 11/4/15, ajm at zator.com wrote:
> The question: do is there any method to delete the old table without
> including the FTS3/4 modules to those users "in the field"?
>
Here is a hack.
Let the name of your FTS3 table be "xyzzy"
(1) Invoke "PRAGMA writable_schema=ON". (Read the documentation
On 11/4/15, Bart Smissaert wrote:
> Been trying to get to the bottom of this, but no success.
> Note that with one UDF in the statement all runs perfectly fine.
> Could somebody confirm that they can run 2 UDF's (I have mainly tried with
> the 2 the same UDF's) in the same SQL and that all
> runs
Jim Morris wrote:
>
> at line 37428:
> while( cnt-->0 && (res = winLockFile(&pFile->h, SQLITE_LOCKFILE_FLAGS,
> PENDING_BYTE, 0, 1, 0))==0 ){
>
Are you using version 3.9.2 or some other version?
>
> cnt = 2
> locktype = 1//SHARED_LOCK
> lastErrno =
Problem is trying to get a shared lock in sqlite.c, "static int
winLock(sqlite3_file *id, int locktype)"
at line 37428:
while( cnt-->0 && (res = winLockFile(&pFile->h, SQLITE_LOCKFILE_FLAGS,
PENDING_BYTE, 0, 1, 0))==0 ){
cnt = 2
locktype = 1//SHARED_LO
Thanks you both.
I'm already using a timeout of 1 minute.
My "Database is locked" errors only happen in the following situation :
- I run an import thread, which does a lot of write
- this thread uses a transaction : BEGIN at import start, COMMIT/ROLLBACK at
import end
- during the import (whic
On 4 Nov 2015, at 8:00am, ALBERT Aur?lien
wrote:
> - this thread uses a transaction : BEGIN at import start, COMMIT/ROLLBACK at
> import end
> - during the import (which is very long to execute, sometimes several hours),
> another thread execute reads on the same database (different connectio
No. The app works, however when I scroll the list there are may
requests to get records from the DB and it seems to interact with the
background thread to produce this error.
On 11/3/2015 7:02 PM, Joe Mistachkin wrote:
> Jim Morris wrote:
>> Is there a graceful work around?
>>
>>
>>(38
11 matches
Mail list logo
