Re: [sqlite] to joe mistachkin - Ticket 4bbf851fa5
Simon Hucksley wrote:
>
> since weeks I'm not able to edit the ticket as anonymous.
> the edit button is missing on the menu.
>
Unfortunately, the ability to edit tickets anonymously had to be disabled.
>
> to ticket 4bbf851fa5
>
> It's the same old story:
> after updating some hundred records
> the DBConcurrencyException occurs.
>
> After updating the DateTime column
> update t set dt = 2455926.6
>
> life goes on for some hundred updates.
>
As I said in the ticket, I've done quite a bit of careful analysis and
troubleshooting on several issues that fall into this general area.
The conclusion I came to was that the .NET Framework makes certain
assumptions
about ADO.NET providers (and their supported data types in particular) that
do
not always map correctly to how System.Data.SQLite handles its data types.
Unfortunately, without breaking backward compatibility with previous
versions,
it is almost impossible to "fix" this issue from the System.Data.SQLite
side.
The best that can currently be done is to figure out exactly which of SQL
queries generated by the .NET Framework are problematic and why (i.e. which
use
of the equality operator is causing the issue, given the parameter data
types).
As of release 1.0.80.0, This can be done by using the "Flags" connection
string
property, set to a value of "LogAll" (the important flags are "LogPrepare",
"LogPreBind", and "LogBind"); however, "LogAll" is typically easier to
specify.
Here is an example:
//
// In order to actually see the output generated by these diagnostic
flags,
// you'll need to add a TraceListener of some kind to the TRACE listeners
// collection (and the TRACE define constant must be present in your
project
// build configuration as well). For non-console applications, you'll
want
// to use the DefaultTraceListener instead (it will write output to the VS
// output window when the application is running inside the debugger -OR-
// you can use Sysinternals DebugView tool to see it when the application
is
// not running inside the debugger).
//
System.Diagnostics.Trace.Listeners.Add(new ConsoleTraceListener());
using (SQLiteConnection connection = new SQLiteConnection(
"Data Source=somefile.db;Flags=LogAll;"))
{
connection.Open();
// code to execute query here...
}
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] to joe mistachkin - Ticket 4bbf851fa5
Joe, since weeks I'm not able to edit the ticket as anonymous. the edit button is missing on the menu. to ticket 4bbf851fa5 It's the same old story: after updating some hundred records the DBConcurrencyException occurs. After updating the DateTime column update t set dt = 2455926.6 life goes on for some hundred updates. regards, simon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Exception 14
FLOWERDAY John wrote: > > If I run either table by itself, it works. However, if I run one table after the > other, the first table copies find and then the second table gives me the exception > 14. It does not matter in what order I run the two tables, the first one works, the > second one throws an exeption. Here is the code for the insertion: > Several things about your example are unclear. First, the SQLiteConnection class does not have a constructor that takes a file path; instead, it takes a connection string with syntax like "Data Source=;...". Second, the SQLiteConnection class does not have an "Insert" method. My guess is that you are using a different data access library from the "standard" System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Suggestion about hard-coded time string format YYYY-MM-DD
2012/4/2 Jay A. Kreibich
> It would make more sense to just implement a strptime() SQL function
> to compliment the existing strftime() function. That would allow
> SQLite to understand and convert any incoming date-time format
> without depending on specific build parameters.
>
>
But may strptime() function returns datetime in format '%Y-%m-%d
%H:%M:%S'?.. It's produce some overhead by expensive (string parsing)
operations.
select strptime('%d.%m.%Y %H:%M:%S', '12.11.2001 18:31:01');
2001-11-12 18:31:01
select strftime('%s', strptime('%d.%m.%Y %H:%M:%S', '12.11.2001 18:31:01'));
1005589861
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using multiple versions of sqlite on the same system
On Thu, Apr 12, 2012 at 2:21 PM, Kyle Jordan wrote: > Our organization has been using Sqlite for a while. We are currently > building an embedded platform, which uses a Debian Linux distribution. By > default, this system has Sqlite v3.7.3 installed. We have a pre-existing > application that has Sqlite v3.3.7 compiled in as a static library. Is it > safe to use the two different versions of Sqlite on the same system on the > same database? > Yes. > > Thanks, > > Kyle Jordan > Senior Software Engineer > > L.B. Foster Company - Salient Systems > 4393-K Tuller Rd > Dublin, OH 43017-5008 > phone: (614) 792-5800 EX 4637 > fax: (614) 792-5888 > email: kjor...@salientsystems.com > > website: www.lbfoster.com > NASDAQ Ticker Symbol: FSTR > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLite's TCL module
2012/4/12, Alexey Pechnikov :
> May be used "onecolumn" function instead of "eval". The "eval" function
> returns empty value of single record and so the result is "{}".
"Empty list", I suppose?
--
regards,
Zbigniew
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLite's TCL module
2012/4/12, Richard Hipp :
> On Thu, Apr 12, 2012 at 2:06 PM, Zbigniew wrote:
>
>> At the attempt to get a non-existing value, for example:
>>
>> set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>>
>
> The correct way to do this would be one or other other of the following:
>
>set x [lindex [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>
>set x [dbcomm onecolumn eval {SELECT max(somecolumn) FROM sometable}]
>
> In the second example, it is traditional to abbreviate "onecolumn" to
> simply "one".
Thanks, "onecolumn" work for me. Do you mean, that "eval" will always
return a list, although my SELECT clause wants just single value?
--
regards,
Zbigniew
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Using multiple versions of sqlite on the same system
Our organization has been using Sqlite for a while. We are currently building an embedded platform, which uses a Debian Linux distribution. By default, this system has Sqlite v3.7.3 installed. We have a pre-existing application that has Sqlite v3.3.7 compiled in as a static library. Is it safe to use the two different versions of Sqlite on the same system on the same database? Thanks, Kyle Jordan Senior Software Engineer L.B. Foster Company - Salient Systems 4393-K Tuller Rd Dublin, OH 43017-5008 phone: (614) 792-5800 EX 4637 fax: (614) 792-5888 email: kjor...@salientsystems.com website: www.lbfoster.com NASDAQ Ticker Symbol: FSTR ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLite's TCL module
On Thu, Apr 12, 2012 at 2:15 PM, Richard Hipp wrote:
>
>
> On Thu, Apr 12, 2012 at 2:06 PM, Zbigniew wrote:
>
>> At the attempt to get a non-existing value, for example:
>>
>> set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>>
>
> The correct way to do this would be one or other other of the following:
>
>set x [lindex [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>
Oops. Omitted the " 0]" from the end of the previous line -^
>
>set x [dbcomm onecolumn eval {SELECT max(somecolumn) FROM sometable}]
>
> In the second example, it is traditional to abbreviate "onecolumn" to
> simply "one".
>
>
>>
>> The returned value of $x will be {} - and no, not "empty", but exactly
>> these two characters.
>>
>> Easy to reproduce.
>> --
>> Zbigniew
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
>
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLite's TCL module
On Thu, Apr 12, 2012 at 2:06 PM, Zbigniew wrote:
> At the attempt to get a non-existing value, for example:
>
> set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>
The correct way to do this would be one or other other of the following:
set x [lindex [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
set x [dbcomm onecolumn eval {SELECT max(somecolumn) FROM sometable}]
In the second example, it is traditional to abbreviate "onecolumn" to
simply "one".
>
> The returned value of $x will be {} - and no, not "empty", but exactly
> these two characters.
>
> Easy to reproduce.
> --
> Zbigniew
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bug in SQLite's TCL module
May be used "onecolumn" function instead of "eval". The "eval" function
returns empty value of single record and so the result is "{}".
2012/4/12 Zbigniew
> At the attempt to get a non-existing value, for example:
>
> set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
>
> The returned value of $x will be {} - and no, not "empty", but exactly
> these two characters.
>
> Easy to reproduce.
> --
> Zbigniew
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Bug in SQLite's TCL module
At the attempt to get a non-existing value, for example:
set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}]
The returned value of $x will be {} - and no, not "empty", but exactly
these two characters.
Easy to reproduce.
--
Zbigniew
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Ow! I'm stupid it's sqlite3 not sqlite
Thank you to all for your help
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Robert Myers
Envoyé : jeudi 12 avril 2012 18:15
À : sqlite-users@sqlite.org
Objet : Re: [sqlite] error compilation with Sqlite in C program
On 4/12/2012 11:07 AM, Sako Youssouf wrote:
> Here my step and the result.
>
> # gcc -c sqlite3.c
> # ar -rvs libsqlite3.a sqlite3.o
> ar: creating libsqlite3.a
> a - sqlite3.o
>
> # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
Here's your problem. You want -lsqlite3
> /tmp/ccfdSnPR.o: In function `main':
> compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
> compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
> compil.c:(.text+0x101): undefined reference to `sqlite3_close'
> compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
> compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
> compil.c:(.text+0x179): undefined reference to `sqlite3_close'
> collect2: ld a retourné 1 code d'état d'exécution
>
> compil.c :
>
> 01 #include
> 02 #include
> 03
> 04 static int callback(void *NotUsed, int argc, char **argv, char
> **azColName){
> 05int i;
> 06for(i=0; i 07 printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
> 08}
> 09printf("\n");
> 10return 0;
> 11 }
> 12
> 13 int main(int argc, char **argv){
> 14sqlite3 *db;
> 15char *zErrMsg = 0;
> 16int rc;
> 17
> 18if( argc!=3 ){
> 19 fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
> 20 return(1);
> 21}
> 22rc = sqlite3_open(argv[1],&db);
> 23if( rc ){
> 24 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
> 25 sqlite3_close(db);
> 26 return(1);
> 27}
> 28rc = sqlite3_exec(db, argv[2], callback, 0,&zErrMsg);
> 29if( rc!=SQLITE_OK ){
> 30 fprintf(stderr, "SQL error: %s\n", zErrMsg);
> 31 sqlite3_free(zErrMsg);
> 32}
> 33sqlite3_close(db);
> 34return 0;
> 35 }
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 6:07 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > # ar -rvs libsqlite3.a sqlite3.o > # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c > You're back to the first problem you had: linking against /usr/lib/libsqlite.* -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On 4/12/2012 11:07 AM, Sako Youssouf wrote:
Here my step and the result.
# gcc -c sqlite3.c
# ar -rvs libsqlite3.a sqlite3.o
ar: creating libsqlite3.a
a - sqlite3.o
# gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
Here's your problem. You want -lsqlite3
/tmp/ccfdSnPR.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
compil.c :
01 #include
02 #include
03
04 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
05int i;
06for(i=0; ihttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Here my step and the result.
# gcc -c sqlite3.c
# ar -rvs libsqlite3.a sqlite3.o
ar: creating libsqlite3.a
a - sqlite3.o
# gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
/tmp/ccfdSnPR.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
compil.c :
01 #include
02 #include
03
04 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
05int i;
06for(i=0; ihttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
I just tested this and at least on RedHat 5 the index on the library (ranlib or
"s") doesn't make a difference.
You must be doing something wrong so please show your complete steps.
This works for me:
cc -c sqlite3.o
ar rvs libsqlite3.a sqlite3.o
cc -o mytest mytest.c -L. -lsqlite3 -lpthread -ldl
mytest.c:
#include
#include
#include
#include "sqlite3.h"
int main()
{
sqlite3 *db;
sqlite3_stmt *stmt;
int status;
char *create = "create table test(a integer);";
status=sqlite3_open_v2("test.db",&db,SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE,NULL);
if (status != SQLITE_OK) {
printf("open error:%s\n",sqlite3_errmsg(db));
exit(1);
}
sqlite3_exec(db,create,NULL,NULL,NULL);
return 0;
}
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Sako Youssouf [youssouf.s...@renault-trucks.com]
Sent: Thursday, April 12, 2012 10:31 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program
Michael I rebuild library and after I done the "ranlib" step but the same error
occur!
Stephan I tried the change that you propose but the same error occur!
Others ideas?
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Black, Michael (IS)
Envoyé : jeudi 12 avril 2012 17:17
À : General Discussion of SQLite Database
Objet : Re: [sqlite] error compilation with Sqlite in C program
You're missing a step in your library build.
ranlib libsqlite.a
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Sako Youssouf [youssouf.s...@renault-trucks.com]
Sent: Thursday, April 12, 2012 10:10 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program
Yes that what I tried but as you can see below when I do that, the first error
reappear.
root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv
libsqlite.a sqlite3.o
ar: creating libsqlite.a
a - sqlite3.o
root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc
-L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl
-lpthread -o compil compil.c
/tmp/cc7IDdvz.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Stephan Beal
Envoyé : jeudi 12 avril 2012 17:06
À : General Discussion of SQLite Database
Objet : Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf <
youssouf.s...@renault-trucks.com> wrote:
> compil.c:(.text+0x6f): multiple definition of `main'
>
Remove shell.o from your libsqlite.a.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Same error with -s argument with or without the shell.o in the archive. there have it other way to use Sqlite in a C program ? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:33 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:31 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > Others ideas? > Can you paste in the last thing (or two) you tried? You might also try passing -s to ar (it's equivalent to calling ranlib, from what i understand). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using "attach database" to work around DB locking
On 12 Apr 2012, at 3:30pm, Gabriel Corneanu wrote: > Using WAL mode and lots of optimizations I am able to write >15 records/s > (one table with ~20 fields) and at the same time reading(processing) >30 > records/s. > > There are lots of tricks/variables (number of fields, page size, cache size, > wal checkpoint size...) to achieve this. Or you can do your immediate writing to a database in memory, and have another process dump memory to disk in the background. Depending on how recent you need reading you can read the one in memory or the one on disk. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:31 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > Others ideas? > Can you paste in the last thing (or two) you tried? You might also try passing -s to ar (it's equivalent to calling ranlib, from what i understand). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Michael I rebuild library and after I done the "ranlib" step but the same error occur! Stephan I tried the change that you propose but the same error occur! Others ideas? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Black, Michael (IS) Envoyé : jeudi 12 avril 2012 17:17 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program You're missing a step in your library build. ranlib libsqlite.a Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sako Youssouf [youssouf.s...@renault-trucks.com] Sent: Thursday, April 12, 2012 10:10 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:10 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ > -ldl -lpthread -o compil compil.c > what happens if you replace -l... -L... with sqlite3.o? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
You're missing a step in your library build. ranlib libsqlite.a Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sako Youssouf [youssouf.s...@renault-trucks.com] Sent: Thursday, April 12, 2012 10:10 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Thank you for your answer Stephan I tried to adding -L command apparently it solved the problem but another error occur. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cccbS6DV.o: In function `main': compil.c:(.text+0x6f): multiple definition of `main' /home/y_sako/Documents/sqlite-amalgamation-3071100//libsqlite.a(shell.o):shell.c:(.text+0x7515): first defined here collect2: ld a retourné 1 code d'état d'exécution I tried to add just the sqlite.c file in the library and recompile and there the first problem is comeback. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution do you see what I have to changed? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 16:18 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 4:14 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -lsqlite -o compil compil.c > Are you sure your -lsqlite isn't picking up an sqlite2 under /usr/lib? Could you try adding -L. to your compile command? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Exception 14
If I run either table by itself, it works. However, if I run one table after
the other, the first table copies find and then the second table gives me the
exception 14. It does not matter in what order I run the two tables, the first
one works, the second one throws an exeption. Here is the code for the
insertion:
public class LookupRepository : ILookupRepository
{
private LookupDatabaseHelper _helper;
public LookupRepository(Context context)
{
_helper = new LookupDatabaseHelper(context);
}
public long insertCountry(string Country_Code, string Country_NCES,
string County_Name, string StartDate, string EndDate)
{
using (var database = new
SQLiteConnection(_helper.WritableDatabase.Path))
{
return database.Insert(new Country
{
CntryCd = Country_Code,
CntryNCESCd = Country_NCES,
CntryName = County_Name,
StrtDt = StartDate,
EndDt = EndDate
});
}
}
public long insertActivityCode(string ActivityTypeID, string
Description, string January, string February, string March, string April,
string May, string June, string July, string August, string September, string
October, string November, string December, string SeasonalFg, string
TemporaryFg, string CreateDate, string EndDate)
{
using (var databaseActivityCode = new
SQLiteConnection(_helperActionCode.WritableDatabase.Path))
{
return databaseActivityCode.Insert(new ActivityAction
{
ActivityType_ID = ActivityTypeID,
Descr = Description,
January = January,
February = February,
March = March,
April = April,
May = May,
June = June,
July = July,
August = August,
September = September,
October = October,
November = November,
December = December,
SeasnlFg = SeasonalFg,
TmpryFg = TemporaryFg,
CrtDt = CreateDate,
EndDt = EndDate
});
}
}
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Stephan Beal
Sent: Thursday, April 12, 2012 7:26 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite Exception 14
On Thu, Apr 12, 2012 at 4:22 PM, FLOWERDAY John
wrote:
> right after the first table, I get an SQLiteException 14. I have
> searched the web and have found zero answers to this. I also cannot
> find an answer on the SQLite site. Any suggestions?
>
[stephan@host:~/cvs/fossil]$ grep -w 14 /usr/include/sqlite3.h
#define SQLITE_CANTOPEN14 /* Unable to open the database file */
#define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14<<8))
#define SQLITE_CONFIG_PCACHE 14 /* sqlite3_pcache_methods* */
#define SQLITE_DROP_TEMP_TRIGGER14 /* Trigger NameTable Name
*/
#define SQLITE_TESTCTRL_RESERVE 14
sounds like the first one.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using "attach database" to work around DB locking
Hi, I have a similar problem; I need to reach writing 10 records/s and parallel reading without blocking the writer. While previously it was not possible (I was considering HDF5 for this), now I decided to go back to sqlite. Using WAL mode and lots of optimizations I am able to write >15 records/s (one table with ~20 fields) and at the same time reading(processing) >30 records/s. There are lots of tricks/variables (number of fields, page size, cache size, wal checkpoint size...) to achieve this. Regards, Gabriel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Exception 14
On Thu, Apr 12, 2012 at 4:22 PM, FLOWERDAY John wrote: > right after the first table, I get an SQLiteException 14. I have searched > the web and have found zero answers to this. I also cannot find an answer > on the SQLite site. Any suggestions? > [stephan@host:~/cvs/fossil]$ grep -w 14 /usr/include/sqlite3.h #define SQLITE_CANTOPEN14 /* Unable to open the database file */ #define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14<<8)) #define SQLITE_CONFIG_PCACHE 14 /* sqlite3_pcache_methods* */ #define SQLITE_DROP_TEMP_TRIGGER14 /* Trigger NameTable Name */ #define SQLITE_TESTCTRL_RESERVE 14 sounds like the first one. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Exception 14
I am using SQLite in C#. I am attempting to transfer two tables from a Microsoft SQL database to an Android tablet using a webservice. My insert routine is below. If I transfer only one table everything works find. If I attempt to transfer a second table right after the first table, I get an SQLiteException 14. I have searched the web and have found zero answers to this. I also cannot find an answer on the SQLite site. Any suggestions? John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 4:14 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -lsqlite -o compil compil.c > Are you sure your -lsqlite isn't picking up an sqlite2 under /usr/lib? Could you try adding -L. to your compile command? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error compilation with Sqlite in C program
Hi, I'm a new user of sqlite, i want to test utilization of sqlite in a C program. So I generated a static lib of sqlite (using the amalgamation files) and I try to use it in my C program. But I get some error. Below my compilation code and the return error. The program that I wanted test is the C program on this page : http://www.sqlite.org/quickstart.html root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -c shell.c root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -c sqlite3.c root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a shell.o sqlite3.o ar: creating libsqlite.a a - shell.o a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -lsqlite -o compil compil.c /tmp/ccBIvSMw.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution can someone explain me what is the problem ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_stricmp
The sqlite3_stricmp() function is used only once in FTS3 extension and I did fix the problem by replacing it to sqlite3_strnicmp() http://sqlite.mobigroup.ru/fdiff?v1=111626ce72b0df93&v2=29b395d2169466ab 2012/4/9 Alexey Pechnikov > As I find is missed sqlite3_stricmp reference in file loadext.c > > > -- > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] malloc_usable_size code in 3.7.10 causes free(): invalid pointer
[my previous message to list didn't get approved? trying again...] Hi, Since sqlite 3.7.10, a Debian software package (bogofilter-sqlite) began to see (always reproducible) failures during its test suite, but only on 64-bit platforms: https://buildd.debian.org/status/logs.php?pkg=bogofilter&ver=1.2.2%2Bdfsg1-1%2Bb1 I've found that new code in mem1.c enabled by HAVE_MALLOC_USABLE_SIZE was causing this regression, and disabling the malloc_usable_size test in configure.ac produces a sqlite library that doesn't exhibit this problem. Below is a gdb backtrace of the problem occurring. This comes from a core dump generated during bogofilter-sqlite's test suite; I wasn't able to reproduce it when running bogofilter directly under gdb: > Core was generated by `../bogofilter -C -D -n -B ./maildir.20120409/good'. > Program terminated with signal 6, Aborted. > #0 0x7f15b0db01b5 in *__GI_raise (sig=) at > ../nptl/sysdeps/unix/sysv/linux/raise.c:64 > 64../nptl/sysdeps/unix/sysv/linux/raise.c: No such file or directory. > in ../nptl/sysdeps/unix/sysv/linux/raise.c > (gdb) bt > #0 0x7f15b0db01b5 in *__GI_raise (sig=) at > ../nptl/sysdeps/unix/sysv/linux/raise.c:64 > #1 0x7f15b0db2fc0 in *__GI_abort () at abort.c:92 > #2 0x7f15b0defc00 in malloc_printerr (action=2, str=0x7f15b0ea4555 > "free(): invalid pointer", ptr=0x6854) at malloc.c:6272 > #3 0x7f15b19c580e in sqlite3_free (p=0x1697cb0) at sqlite3.c:19059 > #4 0x7f15b1a1cd5d in sqlite3NestedParse (pParse=0x16995c0, > zFormat=) at sqlite3.c:81448 > #5 0x7f15b1a2ee50 in sqlite3CreateIndex (pParse=0x16995c0, pName1= optimized out>, pName2=, pTblName=, > pList=0x1697ba0, > onError=99, pStart=0x0, pEnd=0x0, sortOrder=0, ifNotExist=0) at > sqlite3.c:84080 > #6 0x7f15b1a2f197 in sqlite3AddPrimaryKey (pParse=0x16995c0, pList=0x0, > onError=, autoInc=0, sortOrder=) at > sqlite3.c:82382 > #7 0x7f15b1a1a23f in yy_reduce (yyp=0x1699860, yymajor= out>, yyminor=..., pParse=) at sqlite3.c:110062 > #8 sqlite3Parser (yyp=0x1699860, yymajor=, yyminor=..., > pParse=) at sqlite3.c:45631 > #9 0x7f15b1a1c491 in sqlite3RunParser (pParse=0x16995c0, > zSql=0x42c9c8 "CREATE TABLE bogofilter ( key BLOB PRIMARY KEY, > value BLOB);CREATE INDEX bfidx ON bogofilter(key,value);", pzErrMsg= optimized out>) > at sqlite3.c:111992 > #10 0x7f15b1a1ea1a in sqlite3Prepare (db=0x1685f50, zSql= out>, nBytes=-1, saveSqlFlag=, pReprepare=0x0, > ppStmt=, > pzTail=0x7fff650edd28) at sqlite3.c:94249 > #11 0x7f15b1a1eb49 in sqlite3LockAndPrepare (db=0x1685f50, zSql= optimized out>, nBytes=-1, saveSqlFlag=0, pOld=0x0, ppStmt=0x7fff650edd20, > pzTail=0x7fff650edd28) > at sqlite3.c:94341 > #12 0x7f15b1a1f015 in sqlite3_prepare (db=0x6854, zSql=0x6854 0x6854 out of bounds>, nBytes=6, ppStmt=0x6854, pzTail=) > at sqlite3.c:94404 > #13 0x7f15b1a22f5c in sqlite3_exec (db=0x1685f50, > zSql=0x42c9c8 "CREATE TABLE bogofilter ( key BLOB PRIMARY KEY, > value BLOB);CREATE INDEX bfidx ON bogofilter(key,value);", xCallback=0, > pArg=, > pzErrMsg=) at sqlite3.c:90862 > #14 0x00417c47 in sqlexec (db=0x1685f50, cmd=0x42c9c8 "CREATE TABLE > bogofilter ( key BLOB PRIMARY KEY, value BLOB);CREATE INDEX bfidx ON > bogofilter(key,value);") > at ../../src/datastore_sqlite.c:144 > #15 0x00418338 in db_open (dummyenv=0x, > bfp=0x1685140, mode=DS_WRITE) at ../../src/datastore_sqlite.c:344 > #16 0x004078ba in ds_open (dbe=0x, bfp=0x1685140, > open_mode=DS_WRITE) at ../../src/datastore.c:157 > #17 0x00416ea0 in open_wordlist (list=0x16850d0, mode=DS_WRITE) at > ../../src/wordlists.c:120 > #18 0x00417179 in open_wordlists (mode=DS_WRITE) at > ../../src/wordlists.c:228 > #19 0x004050d3 in bogomain (argc=6, argv=0x7fff650ee028) at > ../../src/bogomain.c:62 > #20 0x0040304b in main (argc=6, argv=0x7fff650ee028) at > ../../src/main.c:31 > (gdb) Thanks, Regards, -- Steven Chamberlain ste...@pyro.eu.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
