Re: [sqlite] Unable to compile fts2 as loadable extension

Yes I know and fts3 is enabled by default but I need to be able to load fts2 as an external extension for legacy support. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 8, 2008, at 6:15 AM, Alexandre Courbot wrote: > Any

Re: [sqlite] Unable to compile fts2 as loadable extension

Any reason why you don't want to use fts3 instead? Using fts2 means potential big consistency issues if you run vacuum on your database. Moreover, fts3 should just compile and run smoothly on latest versions. Alex. ___ sqlite-users mailing list

[sqlite] Free the text (SQLite ODBC driver 0.79 & ADO 2.8 problem)

So I’m in the process of liberating my GIS data on a shoestring budget with the SQLite / SpatiaLite combo, all test connections to my database (through Christian Werner’s ODBC driver) are going great, but then I run into major difficulties returning ADODB RecordSet’s in ArcMap VBA on any Text

[sqlite] Record locking

Are there any plans to put record locking in Sqlite? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-mode application

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dan wrote: >http://www.sqlite.org/faq.html#q17 Just for the record, compiling with GCC on 64 bit Linux with -Wall results in about 20 'variable may be used uninitialized in this function', although I believe they are all because the compiler

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-modeapplication

I agree with Michael. Some of these warnings can be stopped with trivially small code modifications, and they do try to prevent human error. Consider this line (from my 3.5.9 amalgamation): X1 = 365.25*(Y+4716); //X1 is an int Which produces the following warning in VC++2008: warning C4244: '='

[sqlite] Unable to compile fts2 as loadable extension

I was able to compile fts1 as a loadable extension but I am having a lot of issue with fts2. The first issue is a duplicate sqlite_api symbol found in fts2.c and fts2_tokenizer.c (due to the SQLITE_EXTENSION_INIT1 macro used in both files). I solved the issue using a: extern

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-mode application

> The flood of warnings is a pain. SQLite dev claims they are all > spurious, but with so many I wouldn't venture to guess how they can > tell. http://www.sqlite.org/faq.html#q17 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-mode application

Not sure why the Win32 DLL is not compatible. I would think it should be. You might want to work that out first. Can you elaborate? As for compiling with the WDK, it can be done. The amalgamated source is best. The flood of warnings is a pain. SQLite dev claims they are all spurious, but

Re: [sqlite] concurrent users?

"Shawn Anderson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > I've read many things, some conflicting, about concurrent > users on a Sqlite database. > The feeling I get is that Sqlite is good for a standalone desktop > database, but should not be used in a concurrent user

Re: [sqlite] Column values

Thank you. You are right, it is type I am looking for. Have a super one! Merv Timothy A. Sawyer wrote: > You're asking for the column type, not the value. If you open the database > with sqlite3 there is a command that you can use that shows the SQL commands > that created the table. The .help

Re: [sqlite] concurrent users?

I'm using SQLite in a commercial application where the db is used as a document, often located at a network share (windows only). The db is used as a multiuser document where many users can connect and read/write to the db simultaneously, and it's working perfect. Although, mostly the users will

Re: [sqlite] concurrent users?

"Shawn Anderson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've read many things, some conflicting, about concurrent users on a > Sqlite database. > The feeling I get is that Sqlite is good for a standalone desktop > database, but should not be used in a concurrent user

[sqlite] concurrent users?

Hi, I've read many things, some conflicting, about concurrent users on a Sqlite database. The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users). Is there a definitive answer? thanks!

Re: [sqlite] What is NOT INDEXED and INDEXED BY

"Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE > statements." http://www.sqlite.org/cvstrac/chngview?cn=5772 > > In test script I can see queries like > "SELECT * FROM t1 NOT INDEXED WHERE b = 10

Re: [sqlite] Memory Resident Database

Thanks guys for the responses. My program only needs the database as long as the process still exists so I don't need to copy it on a database file. The memory resident option ":memory:" is perfect. Thanks again. Mihai Limbasan wrote: > > Ribeiro, Glauber wrote: >> You probably want to open

[sqlite] What is NOT INDEXED and INDEXED BY

Hello! "Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements." http://www.sqlite.org/cvstrac/chngview?cn=5772 In test script I can see queries like "SELECT * FROM t1 NOT INDEXED WHERE b = 10 ORDER BY rowid" "DELETE FROM t1 INDEXED BY i1 WHERE a = 5 AND b = 10" But I can't