Hi all,
I was using the legacy version of Sqlite.net with Visual studio 2010 and it
works fine.
I can create an application with the Entity Framework without problem.
I'm not sure but after the SP1 upgrade, the previous version of Sqlite.net
stops to works.
I install the new version with .net 4
With 0-length token in icuNext there is the error:
Error: SQL logic error or missing database
May xNext returns 0 length when the token is stopword?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
Hi all,
I have situation where a column may contain prices (REAL) or a string
meaning no price for this, sorry. I can handle this in application code
but was wondering if I am overlooking a Sqlite feature which might do the
same out of the box: perhaps a TYPE( ) or an IsText( ) function..?
A
Hi,
I'm experiencing a weird issue and I don't know how to solve it.
First of all, I work on a multi platform middleware written in C language
that uses SQLite 3.7.5.
when I'm doing some tests on Win32, everything is OK, but now I have to use
this middleware on Android (compiled with android NDK
On Wed, Jul 13, 2011 at 8:13 AM, Amit Chaudhuri
amit.k.chaudh...@gmail.comwrote:
Hi all,
I have situation where a column may contain prices (REAL) or a string
meaning no price for this, sorry. I can handle this in application code
but was wondering if I am overlooking a Sqlite feature which
On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote:
I have situation where a column may contain prices (REAL) or a string
meaning no price for this, sorry. I can handle this in application code
but was wondering if I am overlooking a Sqlite feature which might do the
same out of the box:
On 07/14/2011 05:29 PM, Alexey Pechnikov wrote:
With 0-length token in icuNext there is the error:
Error: SQL logic error or missing database
May xNext returns 0 length when the token is stopword?
No. Don't return anything for a stop word. Just advance to the next
non stop-word token and
I'm not sure but after the SP1 upgrade, the previous version of Sqlite.net
stops to works.
I assume you mean SP1 of Visual Studio 2010. I am not aware of any issues
with the
legacy System.Data.SQLite code on Visual Studio 2010. Was there a specific
error
message or was the provider
On Wed, Jul 13, 2011 at 03:52:55PM +0200, Romain Lahore-Carraté scratched on
the wall:
Hi,
I'm experiencing a weird issue and I don't know how to solve it.
First of all, I work on a multi platform middleware written in C language
that uses SQLite 3.7.5.
when I'm doing some tests on Win32,
No. Don't return anything for a stop word. Just advance to the next
non stop-word token and return it.
Thanks, I did and it's work.
And another question... Is there any way to use multi-word synonyms? Like to:
sqlite - Open Source SQLite DBMS
I think the single token Open Source SQLite DBMS
On 07/14/2011 07:42 PM, Alexey Pechnikov wrote:
No. Don't return anything for a stop word. Just advance to the next
non stop-word token and return it.
Thanks, I did and it's work.
And another question... Is there any way to use multi-word synonyms? Like to:
sqlite - Open Source SQLite DBMS
This may be specific to RTree indexes - I haven't taken the time to fully
understand it.
Dangerous:
CREATE TRIGGER ON UPDATE ON tablename { SET RTREE MIN/MAX }
Fine:
CREATE TRIGGER ON UPDATE OF geometry OF tablename { SET RTREE MIN/MAX }
Failure to specify the field name explicitly results in
simple question:
i have table tsamov
create table tsamov (
tsamov_id integer not null primary key
,tsamov_descri text,
,tsamov_code text )
i have index on tsamov_code (it's varchar column of lenght=5)
could the next query use the tsamov_code index ??:
select * from tsamov where
could the next query use the tsamov_code index ??:
select * from tsamov where tsamov_code like 'AFG%'
Only after
pragma case_sensitive_like = true;
Read more about it here: http://www.sqlite.org/optoverview.html#like_opt.
Pavel
On Thu, Jul 14, 2011 at 11:56 AM, Sebastian Bermudez
On 07/14/2011 10:42 PM, Ben Harper wrote:
This may be specific to RTree indexes - I haven't taken the time to fully
understand it.
Dangerous:
CREATE TRIGGER ON UPDATE ON tablename { SET RTREE MIN/MAX }
Fine:
CREATE TRIGGER ON UPDATE OF geometry OF tablename { SET RTREE MIN/MAX }
Failure
On 7/14/2011 12:01 PM, Pavel Ivanov wrote:
could the next query use the tsamov_code index ??:
select * from tsamov where tsamov_code like 'AFG%'
Only after
pragma case_sensitive_like = true;
... or if the index uses COLLATE NOCASE clause.
--
Igor Tandetnik
Hello everyone.
I'm a bit embarassed with a problem I am facing, while using
System.Data.SQLite to send commands to my database. The sad thing is
that if I query the database before and after (with a simple select
statement) the block of commands I obtain the expected results, but
when I open the
On 14 Jul 2011, at 5:13pm, Mattia wrote:
So actually what I do is:
- run the application;
- make a copy of the database;
- select to see what lies inside a table;
- an insert/delete/insertupdate (obtained from a string) to that table
in the db-copy;
- another select, with correct results;
Would glob be faster than like? Since I assume like has to case-convert?
And you don't have to set any pragmas or NOCASE for it to use the index.
select * from tsamov where tsamov_code glob 'AFG*';
sqlite explain query plan select * from tsamov where tsamov_code glob 'AFG*';
sele order
On 14 Jul 2011, at 5:37pm, Black, Michael (IS) wrote:
Would glob be faster than like? Since I assume like has to case-convert?
Given your SELECT string:
select * from tsamov where tsamov_code like 'AFG%'
If you want speed don't use either, use
SELECT * FROM tsamov WHERE tsamov_code
i have this new micro site ready for my personal office
http://urlit.tk
this site is using sqlite as backend
please, don't smile !! this is very very micro site. for my personal url
shorter function
___
sqlite-users mailing list
On 14-07-2011 21:40, Sebastian Bermudez wrote:
i have this new micro site ready for my personal office
http://urlit.tk
this site is using sqlite as backend
please, don't smile !! this is very very micro site. for my personal url
shorter function
I want to add the table
CREATE TABLE ext_fts_synonyms(word text not null unique, synonym text not null);
insert into ext_fts_synonyms('sqlite','sqlite dbms');
And replace in tokenizer the term 'sqlite' to 2 terms 'sqlite' and 'dbms'
for search by queries like to
select text from fts where fts
Apologies!
My mistake. The UPDATE trigger can be catch-all-fields (ie no fields specified),
and it is still correct.
To answer your question Dan, I am not creating a trigger on an RTree.
I am creating a trigger on a regular table, which keeps the RTree up to date.
Thanks,
Ben
2011/7/14 Sebastian Bermudez sebastian.bermu...@yahoo.com:
please, don't smile !! this is very very micro site. for my personal url
shorter function
May be you want to see the test site of the business product on Tcl + SQLite? :)
https://merch.mobigroup.ru/
The site language is russian. You
I want to run sqlite3 from a script (actually from a ToolTask in the MSBuild
environment) and get it to create a database without dropping into
interactive mode. It looks like ToolTasks don't like the redirection
operator (they're interpreted as string literals), so this won't work:
Sqlite3
Luuk:
http://urlit.tk/e51c4is mapping to http://urlit.Uk;the domain is dot
TK not UK
it's working fine for me..
- Original Message
From: Luuk luu...@gmail.com
To: sqlite-users@sqlite.org
Sent: Thu, July 14, 2011 4:50:51 PM
Subject: Re: [sqlite] my new site is
Is anyone aware of another technique for preventing interactive mode from
running? I've seen this method:
Sqlite3 -init new.sql new.db .exit
How about
sqlite3 new.db .read new.sql
Pavel
On Thu, Jul 14, 2011 at 5:20 PM, Marvin Bellamy
marvin.bell...@innovision.com wrote:
I want to run
I suggest not to use any .tk domains if you use a free one from dot.tk.
They take them away if they feel like it at any time.
On 14-07-2011 21:40, Sebastian Bermudez wrote:
i have this new micro site ready for my personal office
http://urlit.tk
this site is using sqlite as backend
On 14 Jul 2011, at 9:28pm, Ben Harper wrote:
My mistake. The UPDATE trigger can be catch-all-fields (ie no fields
specified),
and it is still correct.
If that is meant to be a normal TRIGGER than you are using curly brackets
incorrectly. The syntax does not involve brackets. See
On 07/15/2011 03:28 AM, Alexey Pechnikov wrote:
I want to add the table CREATE TABLE ext_fts_synonyms(word text not
null unique, synonym text not null); insert into
ext_fts_synonyms('sqlite','sqlite dbms');
And replace in tokenizer the term 'sqlite' to 2 terms 'sqlite' and
'dbms' for search
31 matches
Mail list logo
