Hi,
I don't know if question has already been asked, and i appologize if it is
the case...
For the SQLite ADO.NET provider, there are precompiled binaries for both
x86 and x64.
Is there a way to have an assembly targeting any cpu, that chooses by
itself the right dll to use at runtime ?
I did
I have a couple of table seach of which has one column but millions of
rows, the column is a text column.
I need to return all of the rows in table B that are not present in table A
What is the most efficient way of doing this?
___
sqlite-users mailing
Damien wrote:
Is there a way to have an assembly targeting any cpu, that chooses by
itself the right dll to use at runtime ?
The System.Data.SQLite managed-only assembly, when the native library
pre-loading code is enabled (which it is by default starting with
release 1.0.80.0), will now
On May 23, 2012, at 11:12 AM, Paul Sanderson wrote:
I need to return all of the rows in table B that are not present in table A
You have at least 3 ways to express such a query:
(1) Using 'in'
select table_b.*
fromtable_b
where table_b.key not in ( select key from table_a )
(2)
2012/5/23 Joe Mistachkin sql...@mistachkin.com
Damien wrote:
Is there a way to have an assembly targeting any cpu, that chooses by
itself the right dll to use at runtime ?
The System.Data.SQLite managed-only assembly, when the native library
pre-loading code is enabled (which it is
Hi all,
I need to disable the Sqlite3 locking system for a Windows app that runs on
a Mac using the Wine/Crossover API,
this due to the fact Wine/Crossover have problem to manage the locking
status on a network shared drive.
My app already has a built-in locking system so it could runs also
Marcelo Paiva, home user, I am bazilian, I don´t speak or write English, I
need help around sqlite?, my question:
How question in sqlite the sentence like the sentence in Posthe tgreSQL:
data - date type - example - 22/05/2012 - diferent - 22/05/2012
question/sentence: select *from
Hello List!
I see unexpected behavior using sqlite3's .read command.
The basic problem is illustrated by the following test file:
C:\type test2.sql
-- two errors, sqlite3 exits
select count(*) from no_table_a;
select count(*) from no_table_b;
C:\
Here's the result of running
When trying to analyze a 3.5 GB database file (which passes PRAGMA
integrity_check) using the Windows analyzer provided in the download page, it
fails immediately with an Empty or malformed database: db.sqlite error
message. It works on some smaller databases I've tested. My guess is that
-- Regarding: * I have a question about #9 of your test cases. According
to RFC 4180, #9 is an invalid record. The RFC states
If fields are not enclosed with double quotes, then double quotes may
not appear inside the fields.*
My example #9 was:
9,imperial (laughing) loon
I'm no
Here are the steps you must take:
1. Understand that sqlite3 does not have a DATE type, only text.
It does have functions that can work with text strings to
be treated as dates, for example strftime().
2. Convert all your dates in the database and in your programmes
to use a text format
On 22 May 2012, at 7:25pm, Marcelo Paiva mpaiva2...@gmail.com wrote:
data - date type - example - 22/05/2012 - diferent - 22/05/2012
question/sentence: select *from tcontsif01 where data='01/01/2012' and
data='01/05/2012'
SQLite has no datatype for dates. Your data '01/01/2012' and
-Original Message-
The System.Data.SQLite managed-only assembly, when the native library
pre-loading code is enabled (which it is by default starting with release
1.0.80.0), will now attempt to detect the processor architecture of the process
it is being loaded into and then it will
On 05/23/2012 05:06 PM, Demper Delic wrote:
When trying to analyze a 3.5 GB database file (which passes PRAGMA
integrity_check) using the Windows analyzer provided in the download
page, it fails immediately with an Empty or malformed database:
db.sqlite error message. It works on some smaller
Thanks Donald. I have a utility that imports csv files to sqlite so just
trying to get a handle on what I need to deal with!
Pete
lcSQL Software http://www.lcsql.com
On Wed, May 23, 2012 at 9:00 AM, sqlite-users-requ...@sqlite.org wrote:
Message: 15
Date: Wed, 23 May 2012 08:11:17 -0400
The two errors SQLITE_BUSY and SQLITE_LOCKED are very similar but also
very different. SQLITE_LOCKED implies that the contention is on the
same connection whereas SQLITE_BUSY implies that the contention is from
another connection and can be handled via a busy handler.
The error message
SQLITE_LOCKED implies that the contention is on the
same connection
Where did you get this from? Nothing can prevent execution of several
statements on the same connection.
AFAIK, SQLITE_LOCKED implies that contention is from another
connection using the same shared database cache. And it can
On Wed, May 23, 2012 at 7:22 PM, Pavel Ivanov paiva...@gmail.com wrote:
AFAIK, SQLITE_LOCKED implies that contention is from another
connection using the same shared database cache. And it can be handled
either via a busy handler just like SQLITE_BUSY or via
sqlite3_unlock_notify().
On Wed, May 23, 2012 at 1:25 PM, Stephan Beal sgb...@googlemail.com wrote:
On Wed, May 23, 2012 at 7:22 PM, Pavel Ivanov paiva...@gmail.com wrote:
AFAIK, SQLITE_LOCKED implies that contention is from another
connection using the same shared database cache. And it can be handled
either via a
On Wed, May 23, 2012 at 7:37 PM, Pavel Ivanov paiva...@gmail.com wrote:
#define SQLITE_BUSY 5 /* The database file is locked */
#define SQLITE_LOCKED 6 /* A table in the database is locked */
Was this quote supposed to answer some question or clarify something?
i
Hi,
I was always under the impression that prepared statements can only be
used from one thread at a time, so if 2 threads need to perform the
same query independently, you need to have a prepared statement for
each thread. Now I came across the following which seems to contradict
this:
On 5/23/2012 1:51 PM, Sander Jansen wrote:
I was always under the impression that prepared statements can only be
used from one thread at a time, so if 2 threads need to perform the
same query independently, you need to have a prepared statement for
each thread. Now I came across the following
On Wed, May 23, 2012 at 1:05 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 5/23/2012 1:51 PM, Sander Jansen wrote:
I was always under the impression that prepared statements can only be
used from one thread at a time, so if 2 threads need to perform the
same query independently, you need
I've downloaded and compiled icu.c according to the instructions in the
included README (though I had to add -fPIC to the compiler options).
Now, when searching a table, I'm not getting the kind of
diacritic-insensitive behavior I was expecting:
sqlite .load lib/libSQLiteICU.so
sqlite
I expected both statements to return the same result. Am I overlooking
something or do I misunderstand the capabilities of ICU's unicode-aware
LIKE operator?
I believe unicode-aware LIKE operator means case-insensitive for
non-ASCII characters, not diacritic-insensitive.
Pavel
On Wed, May
On Wed, May 23, 2012 at 2:11 PM, Courtney Grimland
cgriml...@cfa.harvard.edu wrote:
I've downloaded and compiled icu.c according to the instructions in the
included README (though I had to add -fPIC to the compiler options).
Now, when searching a table, I'm not getting the kind of
I got it from http://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked
Note that an SQLITE_LOCKED error is distinct from SQLITE_BUSY (5). SQLITE_BUSY
means that another database connection (probably in another process) is using
the database in a way that prevents you from using it. SQLITE_LOCKED
As you can see, this can get arbitrarily complex. We still don't
have a good answer. Your input is welcomed.
If only I knew enough about the subject to be able to provide any useful
input. Naturally, I think it should work exactly as I want it to work
at any given moment. ;)
I have
Rob Richardson wrote:
This is the first I have heard of this feature or requirement or whatever
this is.
This statement seems to be saying that the System.Data.SQLite
managed-only assembly
is different from the System.Data.SQLite assembly. Is that true? When
I download
a new version of the
I've downloaded and compiled icu.c according to the instructions in
the included README (though I had to add -fPIC to the compiler options).
Now, when searching a table, I'm not getting the kind of
diacritic-insensitive behavior I was expecting:
sqlite .load lib/libSQLiteICU.so
sqlite
30 matches
Mail list logo