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 reco
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 o
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
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 st
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 ha
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
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
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
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 othe
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(someco
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 v
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
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 com
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
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 f
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.
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 -lpt
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
À
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, c
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://wandering
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 Bl
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 re
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-
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/
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
_
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 comp
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
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 >1
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/incl
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
SQ
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 c
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
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
[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
34 matches
Mail list logo
