Re: [sqlite] Too many warnings

Hi all, I prefer disabling particular warnings by project setting of Visual Studio, i.e. the compiler argument /wd (http://msdn.microsoft.com/en-us/library/thxezb7y.aspx), instead of modifying the source code of SQLite by adding #pragma, which means you don't have to ask SQLite to change,

[sqlite] A minor suggestion about LoadLibraryEx

Hi all, I recently realized that sqlite extension DLL loading could use a little help from LoadLibraryEx(path, NULL, LOAD_WITH_ALTERED_SEARCH_PATH), unless extension DLLs were always put in the system directory. The only drawback of this function is that doesn't support Windows CE and Windows 9x.

Re: [sqlite] Performance on HP

Hi Andrea, I'm interested in your query: Andrea Connell wrote: > char * qry = "SELECT * FROM LEVEL1 WHERE COUNTRY_ID = ? AND > DIR_SEARCH_AREA1 = ? AND ADDRESS_TYPE = ? AND PHONETIC_KEY >= ? AND > PHONETIC_KEY < ? ;"; > > char * qry2 = "SELECT * FROM LEVEL2 WHERE > PARENT_KEY = ? AND

Re: [sqlite] Long delay for delete/select row in database

Hi Raphaël, Since you are dealing with intervals of numbers, perhaps recent discussion of rtree indexing will help. Besides, separating instant into highly used level of unit may be also useful. For example, instant_date and instant_time. Another rough method is applying PRAGMA synchronous =

Re: [sqlite] Who has the sqlite3.dll and lib for version 3_3_14 for windows

Open your VS2005 command prompt, type: Lib /def:sqlite3.def it will generate proper sqlite3.lib for you. /Mike/ learning Sqlite3 wrote: > Hello, > > Who have the sqlite3.dll and sqlite3.lib of version 3_3_14 for windows. > > I created them wtih visual studio 2005. But they did not work. > > Or

[sqlite] Re: Vista-IE7 problem

Barabbas Jiang Gmail <[EMAIL PROTECTED]> writes: > > Hi all, > > I found another strange problem of SQLite on Vista with IE7. > I have an input method with SQLite. When I opened it in IE7 for > typing Chinese, the SQLite returned nothing. However, *if IE7 is > &qu

[sqlite] Vista-IE7 problem

Hi all, I found another strange problem of SQLite on Vista with IE7. I have an input method with SQLite. When I opened it in IE7 for typing Chinese, the SQLite returned nothing. However, *if IE7 is "run as administrator," SQLite works.* Generally I know IE7 on Vista has a implicit security

Re: [sqlite] About a Vista problem

Hi Millan, I encountered the same problem, the record is on http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html and the issue was sent to http://www.sqlite.org/cvstrac/tktview?tn=2178 To my best knowledge, there's something funny in the dynamic library of file I/O,

Re: [sqlite] Vista problem on its aggressive "previous version"

Hi Klemens, Thank you, I'm trying to follow this: http://technet2.microsoft.com/WindowsVista/en/library/4ac505e6-dd8b-4ae7-80fa-b9d77cd8104d1033.mspx?mfr=true Cheers, Mike Klemens Friedl 提到: Try to deactivate the shadow copy for the directory where the sqlite db file(s) are stored

Re: [sqlite] Vista problem on its aggressive "previous version"

Kees Nuyt 提到: On Wed, 25 Apr 2007 22:09:21 +0800, you wrote: Hi all, Is it possible to prevent this problem happens with SQLite DLL itself? Please refer to http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html for problem description. First of all: I have no

[sqlite] Vista problem on its aggressive "previous version"

Hi all, Is it possible to prevent this problem happens with SQLite DLL itself? Please refer to http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html for problem description. Regards, /Mike/ - To

Re: [sqlite] Japanese-Korean characters

Pavan 提到: Hi, Can we store/retrieve Japanese/korean characters in sqlite db ? Thanks, Pavan. UTF-8 (or Unicode) rules! Cheers, Mike - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Re: How to enable soundex function?

Oops, my bad. After double check the pkgconfig and library path, it works now. So simply add -DSQLITE_SOUNDEX=1 in the Makefile is ok. Regards, Tian-Jian On 2005/7/14, at 上午 4:58, Tian-Jian Barabbas Jiang wrote: Good day, I've tried to add -DSQLITE_SOUNDEX=1 manually

[sqlite] How to enable soundex function?

Good day, I've tried to add -DSQLITE_SOUNDEX=1 manually in the Makefile, and even replace Mac OS X Tiger's default sqlite3 libraries with my build. But it seems just not work. Also, I can't find any configuration option for this. (I've guess as --enable-SOUNDEX=yes or --enable-