> As of this release, the popular ADO.NET provider for SQLite by Robert
> Simpson, System.Data.SQLite, is hosted on the SQLite website. See
> http://System.Data.SQLite.org/ for additional information. Release builds
> of System.Data.SQLite will appears on the SQLite download page over the
> cour
> Since the time for sleeping is an integer number of seconds it's probably
> simplest just to replace this call with one to sleep(10). sleep() is defined
> in POSIX.1 so I believe it should be available in a library for every
> platform SQLite is expected to run on.
Windows has no sleep() - b
> Do you have an OS/2 compile capability? The SQLite developers do not. We
> would appreciate your assistance in testing SQLite on OS/2. If you can
You don't have OS/2 or you can't get it working?
OS/2 is about $US 5 on eBay. AFAIK it runs not under VMWare but I've
read that it runs under bo
Daniel schrieb:
> does anyone know if there is a support for SQLite in .NET Framework 4.0.
As always: http://sqlite.phxsoftware.com/
--
Yours sincerely
Michael Knigge
Development
S.E.T. Software GmbH
Lister Straße 15
30163 Hannover
GERMANY
Tel. +49 511/3 97 80-23
Fax +49 511/3 97 80
> Thanks, everybody, for helping to make SQLite the most widely deployed
> SQL database engine in the world. And Happy 10th Birthday to SQLite!
No, *WE* have to thank *YOU* for this great piece of work, that you give to use
for free! Amazing!
Thank you!
bye,
Michael
All,
> (Disclaimer: I'm german and miss the right tone quite often.)
I haven't followed this thread but just to be clear: We germans are not
rude by nature :-)
But we germans usualy tend to "say what we think", in exactly the words
that we think (at least here in hannover, there was an articl
>> And what compiler are you using that is sensitive to these violations
>> yet generates no warnings?
>
> It's the very nature of undefined behaviour that it does not require a
> warning. Welcome to the world of C.
Is the compiler you use a secret? Do you have to kill us if you tell the
name/v
> VARCHARs. In total, my SQLite database is about 100MB. Very, very huge.
100 MB? Come on, this isn't that "BIG"
> It seems that compressing an SQLite database is very efficient. Is there
> any way to compress/decompress a whole database on the fly ?
Well, you could license the CEROD exten
> I tried to execute some SQL queries using drivers(sqliteodbc) and Native c
> API but i found that ODBC drivers are working twice faster than c API.
> Why this behavior is coming as c APIs are supposed to be faster than
> drivers?
May be the old issue: You've been using transactions with your ODB
> Hi All,
> What are the basic advantage of using SQLite with C API over ODBC.
1. Better Performance.
2. You can use SQLite Features that are not "mappable" to the ODBC-API.
3. You don't have to worry if there are Bugs in the ODBC-Driver.
4. No need to install the ODBC-Driver to let your Applic
Hi,
my C skills are not the very best, but GCC reports some warnings when
compiling 3.6.10 (amalgamation) and I guess GCC is right:
if( unlink(zLockFile) )
{
int rc, tErrno = errno;
if( ENOENT != tErrno )
{
rc = sqliteErrorFromPosixError(tErrno, SQLITE_IOERR_UNLOCK);
}
if( IS_L
> Now my question is how I can provide security to my database for
> example no one can access my database except my application .how can I
> provide security
o encrypt data by yourself
o buy the properitary encryption add-on from hwaci.com
o code your appl with .NET and use the ADO-Provid
Joshua Hudson schrieb:
> A precompiled .dll package is provided. I want to use it.
> The package doesn't contain a .h file to #include in my program.
>
> Now what?
Download the source and take the .h file from the source code? Just as
an idea
__
> however, the program runs well. What may causing the warning? what
> should i do to get rid of this warning.
The warning is produced because your callback() isn't
int callback(void *, int, char **, char **);
try this:
int callback(void *foo, int argc, char **argv, char **azColName)
{
My
> Could be phrased better, but as it is it's perfectly correct. PRAGMA
> page_count returns the size of the underlying database, measured in
> units of pages needed.
Yes, you are right - my fault. Sorry!
bye,
Michael
___
sqlite-users mailing list
sq
See page
http://www.sqlite.org/draft/doc/35to36.html
"Added the page_count PRAGMA for returning the size of the underlying
database file in pages."
I guess you mean "... the **count**" and not **size**.
Bye,
Michael
___
sqlite-users mail
Hi,
Is the database really corrupt, or are you getting
a spurious error? You can tell if the database is
truely corrupt or not by running
PRAGMA integrity_check;
I will check this.
And yes, every thread uses its own sqlite3* ;)
Are you really sure of this? In my experience most of
All,
in a application with several threads (guess 6) we sometimes encounter a
SQLITE_CORRUPT. I'm not the author of this application and my time is
spare, but I really want to ensure that this is not an SQLite issue.
Some hints how to debug this? Anythig I could turn on within SQLite so
we c
THe bigger question is why you are designing a new system to
work with SQLite-2. SQLite-2 is in maintenance for use on legacy
Eh... sorry, I was in a hurry of course I use sqlite3_finalize()!
systems. Use SQLite-3 instead. sqlite3_finalize() cannot fail
for any reason other than SQLITE
All,
I wonder what I have to do if sqlite_finalize() fails? sqlite_close()
will fail if there are any prepared statements associated with a
database handle - so I can't close.
Due to the manual, sqlite_finalize() could return SQLITE_ABORT - do I
have to call sqlite_finalize() again in this c
e = 10200K
--
Mit freundlichen Grüßen
Michael Knigge
S.E.T. Software GmbH
Lister Str. 15
30163 Hannover
Tel.: +49 511 / 3 97 80 -23
Fax: +49 511 / 3 97 80 -66
eMail: [EMAIL PROTECTED]
Hi,
is the order, in which rows with duplicate keys are retrieved, specified?
For example: A table with two columns - the first is a Index. If I
INSERT in the following order:
C1 C2
-
3 1
1 1
1 2
1 1
1 3
2 1
If I now do a "SELECT * FROM Table ORDER BY C1;", is it guranteed that
the row
Jakub Adamek schrieb:
Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a
matter of opinion) the column naming. Try
Thanks a lot - it works!
Bye
Michael
Hi,
sorry... I forgot I get the error "no such column: Sub.Sendung"
So I guess/hope it's only a "syntax error" with my SQL - my SQL-Skills
are rather bad ;-(
Thanks,
Michael
All,
could someone please tell me why this query doesn't work with 3.1.3
(with 3.0.8 it works):
SELECT max(
All,
could someone please tell me why this query doesn't work with 3.1.3
(with 3.0.8 it works):
SELECT max(Sub.Sendung)
FROM
(SELECT S.Sendung
FROM Auftrag AS A,
Sendung AS S
WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND
(A.PosyNId = 6 AND A.PosyNId = S.PosyN
All,
how do I close a cursor with SQLite --> I want to stop processing a
SELECT before sqlite3_step() returns SQLITE_DONE...
Is sqlite3_interrupt() the right way? Does sqlite3_interrupt() deletes
the prepared SQL-Statement?
Thank you,
Michael
All,
What do you mean with "Multithreaded" or "Mulithreaded-DLL" project? Can
you explain exactly where you can select between these two options, and
whether you are using Visual Studio 6 or 2002/2003?
Sorry for being not "precise" enough - english isn't my native language
so it's sometimes "har
Hello,
this question is slightly OT here but.
I want to compile SQLite as a library (not as a DLL) and add this
library to my DLL-Project. Why? Because the C-Compiler from MS produces
so many warnings and I want to compile all my own projects without even
a single warning
So I wonder wh
28 matches
Mail list logo