Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread drh
Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > Yes, the unixLock() routine is defined in the 3.3.0 source, but not > in the 3.2.8 code. > > Nor can I find the #define for this anywhere in the 3.3.0 source (nor > can I find any definition for the sqlite3OsLock (other than a > function

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread Ken & Deb Allen
Yes, the unixLock() routine is defined in the 3.3.0 source, but not in the 3.2.8 code. Nor can I find the #define for this anywhere in the 3.3.0 source (nor can I find any definition for the sqlite3OsLock (other than a function prototype) in either the 3.2.8 or 3.3.0 source. When I

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread drh
Ken & Deb Allen <[EMAIL PROTECTED]> wrote: > > I had a look, but I do not see where the sqlite3OsLock code is > implemented. I see the function prototype, but not the actual > implementation (not even a typedef or wrapper for a native call). > The real name of the function is unixLock.

[sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread Ken & Deb Allen
I have encountered a problem while attempting to execute some code with SQLite embedded. This code was working with the previous version of the source. I am developing a small framework to permit me to use the SQLite engine from within some Cocoa applications I am developing for personal

[sqlite] Compilation warning improvements with 3.3.0

2006-01-12 Thread Ken & Deb Allen
Wow! Am I impressed! A while back I initiated the email concerning the large number of compiler warnings that were being generated when I attempted to compile the SQLite source code using either the Visual Studio 2005 compiler or using XCode 2.2 (gcc 4). This sparked off some acrimonious

Re: [sqlite] Columns being dropped in query result in Mac OS X Terminal

2006-01-12 Thread Jay Sprenkle
Do you have more than 5 records? Try putting an explicit "order by" to ensure you get the same 5 records in every query. On 1/12/06, Philip Riggs <[EMAIL PROTECTED]> wrote: > I am working in SQLite 3.1.3 on Mac OS X 10.4.4. I keep getting the > following error and am wondering why and what I can

[sqlite] Columns being dropped in query result in Mac OS X Terminal

2006-01-12 Thread Philip Riggs
I am working in SQLite 3.1.3 on Mac OS X 10.4.4. I keep getting the following error and am wondering why and what I can do about it? When I query mukey, cokey, and comppct_r independently I get the correct result. However, when I query for all three the columns are misaligned and the first

Re[2]: [sqlite] Thread handling in Windows

2006-01-12 Thread Teg
Hello Dennis, Yeah, I static link too. That's pretty much my usage pattern as well. Long lived worker threads. C Thursday, January 12, 2006, 9:15:09 AM, you wrote: DJ> [EMAIL PROTECTED] wrote: >>Every Windows DLL can provide a DllMain function. This function gets called >>whenever a thread

Re: [sqlite] SQLite and Flash memory

2006-01-12 Thread Paul Bohme
[EMAIL PROTECTED] wrote: Has anyone experimented with putting SQLite directly on the Linux MTD flash interface? I.e. by-passing JFSS2. Would this offer any kind of significant efficiency benefit? JFFS2 is designed to wear the flash evenly, preventing you from 'drilling holes' by

Re: [sqlite] Thread handling in Windows

2006-01-12 Thread Dennis Jenkins
[EMAIL PROTECTED] wrote: Every Windows DLL can provide a DllMain function. This function gets called whenever a thread gets created or destroyed. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/dllmain.asp Except that not all of us use Sqlite as a DLL. We

RE: [sqlite] realloc problem

2006-01-12 Thread Jostmeier, Klaus
Hello, I use sqlite 3.2.7 It is difficult to give you a query for that, cause the problem easily reproduceable. It happens in different situations. Regards, Klaus -Original Message- From: Robert Simpson [mailto:[EMAIL PROTECTED] Sent: Dienstag, 10. Januar 2006 16:27 To:

[sqlite] Sqlite without 64-bit integers?

2006-01-12 Thread Mattias Ohlsson
Hi, I'm trying to use the SQLite database in an embedded system that does not have 64-bit integers, i.e. long long, which is used in SQLite. I've managed to compile by definining the 64-bit types to 32-bit types: typedef long int sqlite_int64; #define UINT64_TYPE unsigned long int I've also run