Re: [sqlite] FTS simple tokenizer

On 02/28/2012 12:09 AM, Jos Groot Lipman wrote: It was reported before (and not solved) http://www.mail-archive.com/sqlite-users@sqlite.org/msg55959.html The document sources are updated now. So the fix will appear on the website next time it is regenerated.

Re: [sqlite] FTS simple tokenizer

Using the _ character to separate words is an informal language standard, s in: method_do_this... On Tue, Feb 28, 2012 at 12:40 AM, Dan Kennedy wrote: > On 02/28/2012 12:09 AM, Jos Groot Lipman wrote: > >> It was reported before (and not solved) >>

[sqlite] Alter table: number size

Hi all, I need to alter a field from smallint(1) to smallint(2), is there to do this using ALTER TABLE ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Alter table: number size

On Tue, Feb 28, 2012 at 7:14 AM, Marco Turco wrote: > Hi all, > > I need to alter a field from smallint(1) to smallint(2), > No you don't; not unless your application or the wrapper you are using are reading the schema or datatypes separately. SQLite itself makes no

[sqlite] Unable to match proper pattern using GLOB keyword

Hi, I am using GLOB in Where clause with character '[' like below: select * from TableName where ColumnName GLOB '*[*'; Table is having data in ColumnName like "ABC[XYZ", but it is not able to find match. How to achieve this record using GLOB. For other characters this statement is working

[sqlite] Is it possible to reduce the number of times sqlite3BTreeMoveToUnpacked is called with an SQLITE C++ application?

Good morning, We have a SQLITE C++ application which tries to find the intersection between the blobs in separate sqlite database tables(which we call subgraphs) ,containing record numbers. When we profile the code below we find that the top profiler user is sqlite3BTreeMoveToUnpacked. I have

Re: [sqlite] Unable to match proper pattern using GLOB keyword

On Tue, Feb 28, 2012 at 1:47 AM, Jitendra Shrivastava < jitendra.s...@gmail.com> wrote: > Hi, > > I am using GLOB in Where clause with character '[' like below: > > select * from TableName where ColumnName GLOB '*[*'; > > Table is having data in ColumnName like "ABC[XYZ", but it is not able to >

[sqlite] ANNOUNCE: Sqlite Root 1.9.7.5 freeware for MS Windows

I am pleased to announce the new version Sqlite Root 1.9.7.5 at www.sqliteroot.com: What is Sqlite Root? = Sqlite Root is a Gui Admin Tool for manage Sqlite Database Features:

Re: [sqlite] Is it possible to reduce the number of times sqlite3BTreeMoveToUnpacked is called with an SQLITE C++ application?

On 02/28/2012 04:29 PM, Frank Chang wrote: Good morning, We have a SQLITE C++ application which tries to find the intersection between the blobs in separate sqlite database tables(which we call subgraphs) ,containing record numbers. When we profile the code below we find that the top

[sqlite] Multiple WHENs in triggers

Hi all, I'm trying to put in a series of conditionals into a trigger, along the lines of -- CREATE TRIGGER UpdateSaleItemDescription AFTER INSERT ON SaleItem WHEN NEW.SaleItem_ID='7' BEGIN UPDATE SaleItem SET SaleItem_Description='This is seven' WHERE SaleItem_ID=NEW.SaleItem_Id; END; WHEN

Re: [sqlite] Multiple WHENs in triggers

> I can't > believe that SQLite only allows only one trigger with only one WHEN per > action... can it? SQLite allows only one WHEN per trigger but any number of triggers per action (without any defined order of execution). So you can do it like this: CREATE TRIGGER UpdateSaleItemDescription1

Re: [sqlite] Multiple WHENs in triggers

Pavel Ivanov-2 wrote: > >>SQLite allows only one WHEN per trigger but any number of triggers per >>action (without any defined order of execution). So you can do it like >>this: > Thanks, Pavel, that's just what I needed to know. I think I'd been got by other languages only allowing one

Re: [sqlite] Multiple WHENs in triggers

On 2/28/2012 11:05 AM, Pavel Ivanov wrote: Or you can also do it like this: CREATE TRIGGER UpdateSaleItemDescription AFTER INSERT ON SaleItem BEGIN UPDATE SaleItem SET SaleItem_Description='This is seven' WHERE SaleItem_ID=NEW.SaleItem_Id AND NEW.SaleItem_ID='7'; UPDATE SaleItem SET

[sqlite] accessing multiple databases

I'm attempting to do a test accessing multiple databases with the code listed below. It errors on the 2nd db select statement and says that the "table does not exist". I am using 2 identical db for the test with different names. Any idea what I am doing wrong? - Thanks, Jan Zumwalt '; echo

Re: [sqlite] accessing multiple databases

Are you sure it's really opening the DB you think it's opening? I think SQLite will create the file if it's not there, and you'll have nothing in it. Perhaps you should try it and specify the complete path, just in case. I don't know if the PDO object looks for the file before opening it.

[sqlite] sqlite3.dll wrapper to import .csv file

Hi All, I am using sqlite3.dll in my c# winform app, I was wondering if anyone knows how to import .csv file into sqlite db table using c# sqlite3.dll wrapper function. Thank's for any help I get. Cheers, Rick ___ sqlite-users mailing list