Re: [sqlite] WinCE sqlite version 3.0.7 source code with fixes available?
Steve Frierdich, dando pulos de alegria, escreveu : Nuno, You right. I just caught that last night, Sunday night, when I was working on it. Sorry for missing that. Does version 3.0.7 have datalocks? I know version 2.8.15 came equipped with datalocks. The config.h file for 3.0.7 version does not contain structures, define statements, inline functions, and source forth as is contained in the config.h file for version 2.8.15. I didn't implemented database locks for 3.x yet. I think that 90% of the sqlite uses on WinCE doesn't need database locks, so I decided to delay the implementation until I consider the source stable enough (the port source, not the "official" one). Also, I need to understand very well the concepts behind the new locking mechanism before venture doing it. I think that if any one needs database locks for sqlite badly, then he should not go for the 3.x version just yet (not enough time passed to decide it is stable), so I don't think my decision is going to make many people "suffer". There is a lot less workarounds needed for SQLite 3.x and there is a os_win.h where all WinCE stuff can go now, so I don't use config.h as I used in 2.8.x. Also, I decided to drop support on WinCE versions prior than 3.0, which cut more than half of the needed hacks. I feel WinCE 3.0 is the first platform that deserves any development and with the release of WinCE 5.0 I don't think I made a bad decision. Regards, ~Nuno Lucas
Re: [sqlite] WinCE sqlite version 3.0.7 source code with fixes available?
Nuno, You right. I just caught that last night, Sunday night, when I was working on it. Sorry for missing that. Does version 3.0.7 have datalocks? I know version 2.8.15 came equipped with datalocks. The config.h file for 3.0.7 version does not contain structures, define statements, inline functions, and source forth as is contained in the config.h file for version 2.8.15. Thanks for your help Steve Nuno Lucas wrote: Steve Frierdich, dando pulos de alegria, escreveu : Does anyone have WinCE sqlite version 3.0.7 source that has fixes and has been tested on WinCE and works available for download? I downloaded some WinCE source from a website but there were bugs in it when I compiled the source code. The bugs were minor and simple to fix, but they were bugs that one would never expect to appear such as: Expected constants not defined, illegal zero size array. If you did read the readme file you would have seen that you don't include the shell.c file to build the sqlite lib/dll. The shell.c file is for compiling the sqlite.exe command line program, which you can't do in most WinCE platforms (you need a command line application, like PocketConsole). Regards, ~Nuno Lucas
Re: [sqlite] WinCE sqlite version 3.0.7 source code with fixes available?
Steve Frierdich, dando pulos de alegria, escreveu : Does anyone have WinCE sqlite version 3.0.7 source that has fixes and has been tested on WinCE and works available for download? I downloaded some WinCE source from a website but there were bugs in it when I compiled the source code. The bugs were minor and simple to fix, but they were bugs that one would never expect to appear such as: Expected constants not defined, illegal zero size array. If you did read the readme file you would have seen that you don't include the shell.c file to build the sqlite lib/dll. The shell.c file is for compiling the sqlite.exe command line program, which you can't do in most WinCE platforms (you need a command line application, like PocketConsole). Regards, ~Nuno Lucas
[sqlite] WinCE sqlite version 3.0.7 source code with fixes available?
Does anyone have WinCE sqlite version 3.0.7 source that has fixes and has been tested on WinCE and works available for download? I downloaded some WinCE source from a website but there were bugs in it when I compiled the source code. The bugs were minor and simple to fix, but they were bugs that one would never expect to appear such as: Expected constants not defined, illegal zero size array. C:\EMIRSS\Software\SQLite\SQLite3_0_7Wince\src\shell.c(230) : error C2065: 'FILENAME_MAX' : undeclared identifier C:\EMIRSS\Software\SQLite\SQLite3_0_7Wince\src\shell.c(230) : error C2057: expected constant expression C:\EMIRSS\Software\SQLite\SQLite3_0_7Wince\src\shell.c(231) : error C2229: struct 'callback_data' has an illegal zero-sized array Just wondering if anyone has updated source code for WinCE sqlite version 3.0.7 source that has fixes and available for download? I like to thanks everyone for his or her input. I belong to about 5 news groups, and read hundreds of emails every day from all five newsgroups, and sqlite has the most rapid response and informative emails. Steve Frierdich Nuno Lucas wrote: Stober, Mel, dando pulos de alegria, escreveu : I created an MFC for WinCE version of shell.c to make it easier to enter text and see error messages. The problem I have is that insert SQL statement doesn't seem to work. Using the examples from here: http://bs2000.fujitsu-siemens.com/download/Goodies/SMAWPlus/SMAWPsqli/html/s qlite.1.html it doesn't like the exalamation point inside quoted strings. I advise you to check your code as the example is pretty common. As an aside, Paul Sokolovsky succeeded in porting TCL 8.4.6 into an iPaq 4150, using an arm-wince-gcc port. With that it achieved running the full test suite on sqlite 2.8.13 and all relevant single-threaded tests passed. I'm very grateful to him as I'm more confident now on the status of the port :) This unfortunely doesn't apply to 3.0.x, but I think it's a good sign :) Best regards, ~Nuno Lucas
Re: [sqlite] version 3.0.7 giving unresolved external symbol with _sqlite_free_table, _sqlite_open, _sqlite_close, _sqlite_get_table, _sqlite_exec
The prefix for several like-named routines in sqlite 3.0.7 is "sqlite3". For example: sqlite3_open Could it be that somehow you've #included "sqlite.h" instead of "sqlite3.h" in your sources? --Steve On Oct 5, 2004, at 12:45 PM, Steve Frierdich wrote: I made a static library out of the source code for Sqlite for version 3.0.7 and when I used the library in an MFC program I get linker error on unresolved external symbol for the following symbols: _sqlite_close _sqlite_open _sqlite_free_table _sqlite_get_table _sqlite_exec _sqlite_error_string _sqlite_freemem I made the same type of library for the source for Sqlite for version 2.8.15 and used that library in the same MFC program and it worked find. Can anyone tell me why or how to solve the linker error problem for version 3.0.7? Thanks Steve Frierdich 727 455 4668 J
Re: [sqlite] Version 3.0.7
Thank you, I am looking forward to it. The Sqlite-Wince is really useful, I only copy it to my directory and compile on Win32, WinCE, Linux and QNX. Jakub Nuno Lucas wrote: Jakub Adamek, dando pulos de alegria, escreveu : That's GREAT ! Nuno, are you going to merge Sqlite-Wince STABLE ? I'll do that during this week. Regards, ~Nuno Lucas -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 http://www.telematix.cz Tel: +420 608 247197 Office: +420 224233470
Re: [sqlite] Version 3.0.7
Jakub Adamek, dando pulos de alegria, escreveu : That's GREAT ! Nuno, are you going to merge Sqlite-Wince STABLE ? I'll do that during this week. Regards, ~Nuno Lucas
Re: [sqlite] Version 3.0.7
At 6:02 PM -0400 9/18/04, D. Richard Hipp wrote: SQLite version 3.0.7 is now available on the website. With this release, SQLite version 3.0 leaves beta and becomes "stable". And I thank-a-you :) -- Darren Duncan
[sqlite] Version 3.0.7
SQLite version 3.0.7 is now available on the website. With this release, SQLite version 3.0 leaves beta and becomes "stable". -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565