Citando D. Richard Hipp d...@hwaci.com:
On Jun 18, 2009, at 12:36 PM, galea...@korg.it wrote:
This statement is giving me truoble:
INSERT INTO PlayList_Song(id_song, id_playlist, song_number) VALUES
(5235, 9, 256)
That INSERT statement works fine for me.
Did you try recompiling with
Yes, I've been looking into using the prepare/bind/step functions instead.
I'm at a complete loss as to what might have caused the behavior I initially
saw, since every test I run now runs in constant time.
Thanks for the doc links Dennis, and thanks to everyone for their help and
suggestions.
Dear all,
we plan to use FTS in embedded devices for address search.
One requirement is to save storage.
Assume I create a table FTS_addresses (Field1,Field,2,..Fieldn),
where Field1 is an identifier for my addresses.
If now field1 would be used as document id, and if every fts query returns
Hi
I have a very strange performance problems involving indexes and triggers. A
somewhat simplified example of what I want to do (but which allows to reproduce
the behavior) is the following:
CREATE TABLE MY_FC (ID integer, DESCRIPTION text);
I then proceed to insert 5 rows from my
Hi Nico,
Thank you for your answer.
It's obvious from the function prototype (no DLL/DSO file name
argument).
Yes, of course. I'm not confusing a string holding a filename and a
function pointer!
However, you can use sqlite3_load_extension() instead per-DB connection,
OR, you can even do the
I'm trying to add some literal replacements in my prepared SQL statement
but I'm currently getting a SQL syntax error.
Here's a snippit of what I'm trying to do:
...
sqlite3_stmt* stmt;
sqlite3_prepare_v2(db, Select * from ?, -1, stmt, NULL); -- near
?: syntax error
You're trying identifier replacement, not literal replacement. It's
not allowed. You have to write table name without binding.
Pavel
On Fri, Jun 19, 2009 at 9:58 AM, Shaun Seckman
(Firaxis)shaun.seck...@firaxis.com wrote:
I'm trying to add some literal replacements in my prepared SQL statement
Not sure I fully understand what you mean. Is it not possible to replace the
table name in the prepared statement? What sort of things can I replace then?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel Ivanov
Sent:
Yes, it's impossible to replace table or column names. You can replace
any constant values like this:
select table.column2, column3 + ?
from table
where column1 = ? and column2 + ? column3
limit ?, ?
Pavel
On Fri, Jun 19, 2009 at 10:06 AM, Shaun Seckman
(Firaxis)shaun.seck...@firaxis.com
Ah, that makes more sense :) Thanks a bunch for the clarification!
-Shaun
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel Ivanov
Sent: Friday, June 19, 2009 10:57 AM
To: General Discussion of SQLite Database
Subject:
On 20/06/2009 12:06 AM, Shaun Seckman (Firaxis) wrote:
Not sure I fully understand what you mean.
Is it not possible to replace the table name in the prepared statement?
It is not possible.
What sort of things can I replace then?
You can do replacement at any place where a literal (i.e. a
2009/6/19 hiral hiralsmaill...@gmail.com:
Hi Simon / John,
Thank you for replies.
You are able to repeatably corrupt the db under SQLite 3.5.9? It would
be worthwhile publishing a script that can do that.
was getting error often or did get error ONCE??
I am running application which uses
I want to test sqlite3asynch io but it seems that all the ex\async files
are :
not it amalgamation ?
not in zipped source files ??
not included in the sqlite3.dll ???
But it seems to work fine with win32 platform using amalgamation +
sqlite3async files !
Does future sqlite3.dll/libsqlite3.so
Hello, I found an issue in group_concat, that appears mainly cosmetical,
however may be good to be aware of for those making a more creative use of this
function. See the ticket http://www.sqlite.org/cvstrac/tktview?tn=3923. Edzard.
___
sqlite-users
I finally got around to reviewing SQLite's asynchronous I/O functionality.
http://sqlite.org/asyncvfs.html http://sqlite.org/asyncvfs.html
We actually have an C++ wrapper to uses the same concept, a background thread
for I/O.
The async functionality included w/ SQLite is not a complete
On Jun 20, 2009, at 12:06 AM, Robert Lehr wrote:
I finally got around to reviewing SQLite's asynchronous I/O
functionality.
http://sqlite.org/asyncvfs.html http://sqlite.org/asyncvfs.html
We actually have an C++ wrapper to uses the same concept, a
background thread for I/O.
You
Is it possible to have a search feature for the archive? I.e. rather than
having to do a linear search through 18 archives for an answer to a question,
have a google-like search across all of the archives?
Ray Rizzuto
raymond.rizz...@sig.com
Susquehanna
I noticed that the sqlite.so (SLES 9 32-bit) is numbered .0.8.6 in 3.5.9 and
3.6.15 versions. This caused me some issues when I tried running an
application build against 3.6.15, but the .so that it found was from 3.5.9.
It partially worked, depending on the methods I called.
Part of the
The documentation found at http://sqlite.org/c3ref/exec.html is unclear
about some parts: is it possible to not request an error message (via
passing NULL as the errmsg parameter)? And what are the possible return
values?
- Sherief
___
sqlite-users
On Fri, 19 Jun 2009 13:56:52 -0400, Rizzuto, Raymond
raymond.rizz...@sig.com wrote:
Is it possible to have a search feature for the
archive?
Which archive?
I'll assume you have 18 different databases and you want to
search them in parallel.
I.e. rather than having to do a linear
search
thanks!
On Jun 18, 2009, at 6:01 PM, Dennis Cote wrote:
James Gregurich wrote:
on that update statement, is the SQL optimizer smart enough to not
rerun that select statement for each column in the update's set
clause? Is it going to run a single select statement to get value1,
value2, etc.
There is a search of archives at
http://www.mail-archive.com/sqlite-users%40sqlite.org/
On Fri, Jun 19, 2009 at 2:43 PM, Kees Nuyt k.n...@zonnet.nl wrote:
On Fri, 19 Jun 2009 13:56:52 -0400, Rizzuto, Raymond
raymond.rizz...@sig.com wrote:
Is it possible to have a search feature for the
Hello
KN On Fri, 19 Jun 2009 13:56:52 -0400, Rizzuto, Raymond
KN raymond.rizz...@sig.com wrote:
KN
KN Is it possible to have a search feature for the
KN archive?
KN
KN Which archive?
I think Raymond means the sqlite-users archive.
You could download all the txt.gz files, cat them together
The link I posted (http://www.mail-archive.com/sqlite-users%40sqlite.org/)
only goes back to March 10, 2009 It searches well but is currently
incomplete. Will it be expanded to include older posts?
http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/
goes back much further, but
My apologies for being unclear. I meant the archive of all the sqlite-users
messages. I prefer not to ask a question that has already been answered.
The link http://www.mail-archive.com/sqlite-users@sqlite.org/ suggested by Adam
DeVita does has such a function. I was accessing the archives
On 19 Jun 2009, at 06:36, hiral wrote:
I am running application which uses the db over the NFS. If I move
the db
over the local drive then it's working fine.
So I m observing this bug in NFS environment frequently.
In the same test environment (in which I am getting db corrupted),
if I
Date: Fri, 19 Jun 2009 14:53:05 -0700
From: Robert Lehr rl...@cadence.com
Subject: Re: [sqlite] async io and locks
To: sqlite-users@sqlite.org
In-Reply-To: 43c62cbb-57db-4d1b-af36-2facf239c...@gmail.com
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
I have never been able to
Once again, I am forced to reply to the top-level, outside the thread
b/c I am not receiving individual replies. I apologize for the inconvenience.
On Jun 20, 2009, at 12:30 AM, Dan wrote:
On Jun 20, 2009, at 12:06 AM, Robert Lehr wrote:
I finally got around to reviewing SQLite's asynchronous
(A) I was able to reply inside the thread. *confused*
(B) that the lock is acquired independent... is incorrect and irrelevant.
It should be ignored.
-robert
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 20/06/2009 3:56 AM, Rizzuto, Raymond wrote:
Is it possible to have a search feature for the archive? I.e. rather than
having to do a linear search through 18 archives for an answer to a question,
have a google-like search across all of the archives?
http://search.gmane.org/
In the box
On Jun 20, 2009, at 6:22 AM, Robert Lehr wrote:
Once again, I am forced to reply to the top-level, outside the thread
b/c I am not receiving individual replies. I apologize for the
inconvenience.
On Jun 20, 2009, at 12:30 AM, Dan wrote:
On Jun 20, 2009, at 12:06 AM, Robert Lehr wrote:
31 matches
Mail list logo
