Re: [sqlite] SQLite version 3.7.5

2011-02-02 Thread Michael Knigge
> 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 >

Re: [sqlite] usleep bug?

2010-09-27 Thread Michael Knigge
> 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() -

Re: [sqlite] typo in src/os_os2.c

2010-07-30 Thread Michael Knigge
> 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

Re: [sqlite] SQLite for .NET Framework 4.0

2010-07-08 Thread Michael Knigge
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

Re: [sqlite] SQLite turns 10 years old

2010-05-29 Thread Michael Knigge
> 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

Re: [sqlite] SQL questio

2009-12-16 Thread Michael Knigge
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

Re: [sqlite] SQLite version 3.6.21

2009-12-09 Thread Michael Knigge
>> 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

Re: [sqlite] onthefly Compression of SQLite database

2009-02-02 Thread Michael Knigge
> 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

Re: [sqlite] ODBC drivers are faster than NAtive C API why?

2009-01-28 Thread Michael Knigge
> 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

Re: [sqlite] What is the advantage of using native c API over ODBC

2009-01-23 Thread Michael Knigge
> 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

[sqlite] GCC Compiler Warnings

2009-01-22 Thread Michael Knigge
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(

Re: [sqlite] SQLite file security

2008-11-19 Thread Michael Knigge
> 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

Re: [sqlite] sqlite .dll package doesn't have .h file

2008-08-19 Thread Michael Knigge
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

Re: [sqlite] GCC give a warning while passing a struct as the user data to the callback function of sqlite3_exec()

2008-08-19 Thread Michael Knigge
> 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) {

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-14 Thread Michael Knigge
> 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

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-14 Thread Michael Knigge
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

Re: [sqlite] malformed database file

2006-05-19 Thread Michael Knigge
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

[sqlite] malformed database file

2006-05-18 Thread Michael Knigge
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

Re: [sqlite] what if sqlite_finalize() fails?

2006-02-22 Thread Michael Knigge
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] what if sqlite_finalize() fails?

2006-02-22 Thread Michael Knigge
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

Re: [sqlite] Re: Database Disk Full

2006-02-13 Thread Michael Knigge
-- 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]

[sqlite] Duplicate keys

2005-05-13 Thread Michael Knigge
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

Re: [sqlite] Sub-Select

2005-03-08 Thread Michael Knigge
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

Re: [sqlite] Sub-Select

2005-03-08 Thread Michael Knigge
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

[sqlite] Sub-Select

2005-03-08 Thread Michael Knigge
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 =

[sqlite] How to close a cursor?

2005-01-16 Thread Michael Knigge
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

Re: [sqlite] OT: Compiling under Windows

2005-01-14 Thread Michael Knigge
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

[sqlite] OT: Compiling under Windows

2005-01-12 Thread Michael Knigge
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