> -Original Message-
> From: Ken & Deb Allen [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 15, 2005 4:44 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Problems using SQLITE .Net Data Provider (Windows)
>
> I recently downloaded the (Finisar) .Net Data Provider for
> SQLITE
Hi,
I am using the latest from the CVS. While doing "make test", it fails at
tcl-10.5 with a segmentation fault.
myhost [/usr/home/sqlite] > make test
...
...
tcl-10.1... Ok
tcl-10.2... Ok
tcl-10.3... Ok
tcl-10.4... Ok
tcl-10.5...make: *** [test] Segmentation fault
myhost [/usr/home/sqlite] >
On Mon, 15 Aug 2005, Curtis King wrote:
On 15-Aug-05, at 7:12 PM, D. Kettler wrote:
g++ -o kumacgen kumacgen.cpp /usr/lib/libsqlite3.a
add -lpthread to your link line.
ck
Thank you! I should have thought of that, d'oh. Anyway, it works now.
--
David Kettler
[EMAIL PROTECTED]
On 15-Aug-05, at 7:12 PM, D. Kettler wrote:
g++ -o kumacgen kumacgen.cpp /usr/lib/libsqlite3.a
add -lpthread to your link line.
ck
On Tue, 16 Aug 2005, Ulrik Petersen wrote:
Hi,
There are libsqlite3.a, libsqlite3.la, and libsqlite3.so files
in /usr/lib/
Could you show us the exact command line you are trying to use when
running g++ ?
I'm especially interested in the version where you give the
/usr/lib/libsqlite3.a
On 15-Aug-05, at 5:39 PM, D. Kettler wrote:
Project? DLL? Visual Studio? I said I was using Linux and g++
just link with full path to libsqlite3.a
example: gcc -o foo foo.o /usr/local/lib/libsqlite3.a
man gcc
ck
Sorry about that. I'm using 2.8.16, and we just changed it to compile
into a lib that is statically linked into the executable (with no DLL) .
I encountered a very similar sounding problem, so I thought I would
offer our solution.
I guess that sqlite3 is organized differently. I just looked
Hi,
> There are libsqlite3.a, libsqlite3.la, and libsqlite3.so files
> in /usr/lib/
Could you show us the exact command line you are trying to use when
running g++ ?
I'm especially interested in the version where you give the
/usr/lib/libsqlite3.a fully qualified filename on the commandline.
On Mon, 15 Aug 2005, Aaron Schneider wrote:
If you compile and use the header files from the projects, they will
add a __declspec(dllimport) to the beginning of the files. In Visual
Studio, this changes the symbol defs, so functions used in your
linked
code will not work.
To fix it, just
>> If you compile and use the header files from the projects, they will
>> add a __declspec(dllimport) to the beginning of the files. In Visual
>> Studio, this changes the symbol defs, so functions used in your
linked
>> code will not work.
>>
>> To fix it, just change the "#define
I recently downloaded the (Finisar) .Net Data Provider for SQLITE
from SourceForge in order to use this in a C# applications under
Windoes XP. I had a few small problems getting the database created
at all via .Net, but that is working, and I was able to also define
the schema for my
On Mon, 15 Aug 2005, Aaron Schneider wrote:
If you compile and use the header files from the projects, they will add
a __declspec(dllimport) to the beginning of the files. In Visual
Studio, this changes the symbol defs, so functions used in your linked
code will not work.
To fix it, just
>When I add the -static flag to my g++ command it gives me 'undefined
>reference to' errors for every instance where I attempt to use a sqlite
>function.
If you compile and use the header files from the projects, they will add
a __declspec(dllimport) to the beginning of the files. In Visual
Hello,
I've written a simple C++ app which uses sqlite and thus far it works
perfectly fine as long as I compile it linking to the library dynamically
(standard g++ behavior). However, I would like to be able to distribute
this app to people who do not necessarily have the sqlite libraries
Hi Michael
I tried your example and have experienced the same results. Then I
created the following two indices, now the two queries are same fast:
CN_execute "CREATE INDEX idx_t1_id ON t1 (id)"
CN_execute "CREATE INDEX idx_t2_id ON t2 (id)"
It seems that sqlite doesn't create an index for
Khamis Abuelkomboz wrote:
CREATE INDEX idx_t2_t1id ON t2 (t1id, deleted);
Doent not help.
whereas the following quere takes "no" time:
SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t1.id=t2.id WHERE t1.deleted<>1
This is fast, because no entries has been found to be joined.
This is not true -
Michael Gross wrote:
Hello
I use sqlite 3.2.2. I have a strange performance problem. I am able to
solve the problem by a slight change in the query but I want to ask if
somebody can explain this behavior to me:
I have two tables:
CREATE TABLE t1 (id VARCHAR(40) NOT NULL PRIMARY KEY,
Dr. Hipp isn't showing his hand here, but the timeline indicates that he
added support for MySQL-style backquote quoting on Saturday:
http://www.sqlite.org/cvstrac/chngview?cn=2591
--Ned.
http://nedbatchelder.com
-Original Message-
From: Marcus Welz [mailto:[EMAIL PROTECTED]
Sent:
Danic Systems Releases DragonDB - MVB Edition 1.0 for AppForge MobileVB.
East Brunswick, NJ, USA (August 12, 2005) -- Danic Systems, LLC
announced today that it is shipping DragonDB - MVB Edition 1.0 for
AppForge MobileVB. DragonDB - MVB Edition is an SQL database engine and
software
Hello
I use sqlite 3.2.2. I have a strange performance problem. I am able to
solve the problem by a slight change in the query but I want to ask if
somebody can explain this behavior to me:
I have two tables:
CREATE TABLE t1 (id VARCHAR(40) NOT NULL PRIMARY KEY, deleted BIT);
CREATE TABLE
I'm try to replace MSAccess and to use SQLite instead as proved to be more fast
and reliable
Is there an efficient way of interacting with SQLite from VBA in Excel. What
I'm trying to do is
1. open the database
2. insert values from my s/sheet
3. run some sql script and queries
4. create a csv
21 matches
Mail list logo