[sqlite] Sqlite and we7 local time issue

2016-01-23 Thread Gunnar Roth
you just need to define SQLITE_MSVC_LOCALTIME_API. But i think it should do this automatically if defined(_WIN32_WCE) && _WIN32_WCE >= 0x800 Regards, Gunnar Roth

Re: [sqlite] why I can't find the implementation of functions in IoMethod structure?

2006-08-01 Thread Gunnar Roth
Sarah schrieb: > Why I can't find the implementation of functions(xClose, xRead, xWrite, > xSeek) in IoMethod in the whole SQLite project? > > Are these functions implemented in OS level? > > Of course, where did you expect these os specific function implementation to be? static const

Re: [sqlite] Reading a damaged database file?

2006-08-01 Thread Gunnar Roth
Olaf Beckman Lapré schrieb: Hi, Is there a way to do this programmatically? I would like to recover from a damaged database upon program startup. 1. Copy the code for dump command from shell.c 2. Try if "vacuum;" command repairs the database. with "pragma integrity_check;" you can check

Re: [sqlite] Reading a damaged database file?

2006-08-01 Thread Gunnar Roth
[EMAIL PROTECTED] schrieb: =?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote: Hi, Is there a way to do this programmatically? I would like to recover from a damaged database upon program startup. If your program crashes, or your computer loses power in the middle of a

Re: [sqlite] Reading a damaged database file?

2006-08-01 Thread Gunnar Roth
[EMAIL PROTECTED] schrieb: Gunnar Roth <[EMAIL PROTECTED]> wrote: Well what happens if i write the db to a compact flash card and remove it while writing and put it back again? The database should recover automatically. Actually i have tried that on our ce device

Re: [sqlite] how to unsubscribe this mail list

2006-08-02 Thread Gunnar Roth
jason zhang schrieb: > Hi All, > I don't find the method to unsubscribe this mail list from www.sqlite.org, > could you please tell me how? > > Thanks > Jason > Use a mail client, which has an option to show you all the headers of this mail ( View as source or similara)nd you find these headers

[sqlite] are there known software patents concerning sqlite?

2006-10-11 Thread Gunnar Roth
Hello list, as software patents become a more and more important issue ( one could also call it a pain in the *ss) I would like to know if anyone has done a patent research for sqlite. Or does anyone know about people who claimed that sqlite would violate therir patens? kind regards, gunnar

Re: [sqlite] documentation on the webserver

2006-10-14 Thread Gunnar Roth
Am 14.10.2006 um 04:40 schrieb Jay Sprenkle: The problem is that the function: less_goofy_sqlite3_step(); does not exist in version 3.1.14. Nor does the function: sqlite3_extended_result_codes() ; Mybe you should clean your glasses ;-) the less_goofy_sqlite3_step() function is printed in

[sqlite] so many warnings on vc6 with warning level 4

2006-11-13 Thread Gunnar Roth
Hello, i want to use sqlite3 in a sub-project at work. when compiling with warning level 4 with vc6 ( internal philosophy ) , i get over 480 warnings. With warning level 3 there are still 119 left. This leads to problems to convince the project lead of the quality of sqlite3 ( which i do not

Re: [sqlite] lemon issue

2007-01-25 Thread Gunnar Roth
[EMAIL PROTECTED] schrieb: > dear all: > i am a programmer from China, i use sqlite in my project. > from sqlite, i know lemon. > i work on windows, using vc6.0, i am trying to do something using lemon, > but i have some issues. > i write a my_calculator.y file, and generate

Re: [sqlite] developers mailing list

2007-02-26 Thread Gunnar Roth
Jakub Ladman schrieb: It's seems a bit strange to me that Makefile.linux-gcc includes tcl in the build by default, but it does. Maybe that should change... If you add "-DNO_TCL" to the OPTS variable in Makefile.linux-gcc this error should go away. i.e. add the following line somewhere after the

Re: [sqlite] journal - "Unable to open the database file"

2007-03-09 Thread Gunnar Roth
Allan, Mark schrieb: RB Smissaert, The database file is named .vdb. Is .vdb ok or wrong? Does it have to be .db3? Or is there just certian extensions I need to avoid? I quote from http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows "Be *VERY, VERY* careful what you name your

Re: [sqlite] Is there an inverse for .import?

2007-03-09 Thread Gunnar Roth
Anderson, James H (IT) schrieb: I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? Maybe its dumb but its called .dump ;-) regards, gunnar

Re: [sqlite] Version 3.3.14

2007-04-03 Thread Gunnar Roth
[EMAIL PROTECTED] schrieb: SQLite version 3.3.14 is now available on the SQLite website We have also added the concept of "exclusive access mode". In exclusive access mode, SQLite holds onto locks until you close the connection I should maybe made clear that this new behaviour influences

Re: [sqlite] Version 3.3.15

2007-04-09 Thread Gunnar Roth
[EMAIL PROTECTED] schrieb: SQLite version 3.3.15 is now available on the website http://www.sqlite.org/ This release fixes a problem introduced in 3.3.14 which causes the database connection to become wedged if you attempt to ROLLBACK a CREATE TEMP TABLE statement. Hello Mr. Hipp. Is

Re: [sqlite] Version compatibility

2010-07-24 Thread Gunnar Roth
http://www.sqlite.org/onefile.html Am 23.07.2010 um 11:25 schrieb Andy Chambers: > Hi, > > I've been reading about version compatibility between different > versions of sqlite at the > link below: > > http://www.sqlite.org/formatchng.html > > It states the expected behaviour for old and new

Re: [sqlite] Unicode searches

2008-04-05 Thread Gunnar Roth
Keith Stemmer schrieb: > Yes, I can add a custom collation which works for ASCII chars LOL. > Plain wrong > If you don't understand the problem, just don't reply. > > Plain unreasonable carefulle read ( and understand) this http://sqlite.org/c3ref/create_collation.html and this