Re: [sqlite] network access problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/26/2010 08:45 PM, Art wrote: > There should be no reason that the openv2 statement with read_only specified > should fail under these circumstances, Just because you are opening the database read only does not mean that other connections in

Re: [sqlite] network access problem

Thanks for the suggestions: Sqlite Manager also fails. This is a permission issue with the sql open api. This is a "Shared Folder" under VirtualBox with "read only permission". If the folder is tagged as full access then sql open works. There should be no reason that the openv2

Re: [sqlite] FTS1 or FTS2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/26/2010 07:22 PM, Sam Carleton wrote: > I did this search: > > http://www.google.com/search?q=sqlite+text+search Thanks. I have updated the relevant wiki pages to say the information is old and to point to the current FTS3 implementation. >

Re: [sqlite] FTS1 or FTS2

On Wed, May 26, 2010 at 9:22 PM, Sam Carleton wrote: > Roger, > > I did this search: > > http://www.google.com/search?q=sqlite+text+search > > The top link points here: > > http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex > > Thus I learned of FTS1 and FTS2, maybe

Re: [sqlite] FTS1 or FTS2

Roger, I did this search: http://www.google.com/search?q=sqlite+text+search The top link points here: http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex Thus I learned of FTS1 and FTS2, maybe things should be configured so that CVS isn't crawled by search engines ;) Sam On Wed, May 26, 2010

Re: [sqlite] Novice SQLite user

On 27 May 2010, at 2:15am, jdee5 wrote: > hanks for your reply. I have read through the link you suggested, very > helpful...if I may ask another question concerning this. Say on my > application I have 2 users reading some of the database contents at the same > time and they both log

Re: [sqlite] Novice SQLite user

P- The application I sell is quite small and simple embedded db seems easier to deploy. My current install takes just a few minutes and so it doesn't seem like a good idea to have to have my customer have to configure a client/server database I need something quick and simple. I tried out MS

Re: [sqlite] Novice SQLite user

On Wed, May 26, 2010 at 8:15 PM, jdee5 wrote: > > > > Thanks for your reply.  I have read through the link you suggested, very > helpful...if I may ask another question concerning this.  Say on my > application I have 2 users reading some of the database contents at the same

Re: [sqlite] Novice SQLite user

Thanks for your reply. I have read through the link you suggested, very helpful...if I may ask another question concerning this. Say on my application I have 2 users reading some of the database contents at the same time and they both log something in my application at the same time. For

Re: [sqlite] Novice SQLite user

On 26 May 2010, at 10:04pm, jdee5 wrote: > I am looking for an SQL engine that is easy to install and sqlite seems like > the right way to go. I have an application (currently just for network use > on a LAN) and I want to move to using SQL, my application is fairly small > and simple and I

[sqlite] Novice SQLite user

I am looking for an SQL engine that is easy to install and sqlite seems like the right way to go. I have an application (currently just for network use on a LAN) and I want to move to using SQL, my application is fairly small and simple and I like the idea of embedding SQL and using SQLite so my

Re: [sqlite] how to search for asterix character?

Glob works fine as well with the [*] and is still case-sensitive and that is how it is intended. So this works fine: select field1 from table1 where field1 glob '*FH*[*]' RBS On Wed, May 26, 2010 at 8:22 PM, Olaf Schmidt wrote: > > "Bart Smissaert" >

Re: [sqlite] how to search for asterix character?

"Bart Smissaert" schrieb im Newsbeitrag news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com... > > "...Where SomeColumnContent Like '%someother[*]part%' > > Thanks Olaf, that works fine. > As my customers won't get this I think I might let my > code take

Re: [sqlite] FTS1 or FTS2

On Wed, May 26, 2010 at 1:47 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/26/2010 10:24 AM, Sam Carleton wrote: >> If I do opt to use FTS, which one should I be using, FTS1 or FTS2? >> According to the web site, it should be FTS1,

Re: [sqlite] FTS1 or FTS2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/26/2010 10:24 AM, Sam Carleton wrote: > If I do opt to use FTS, which one should I be using, FTS1 or FTS2? > According to the web site, it should be FTS1, correct? Just as a matter of interest what part of the web site led you to those

Re: [sqlite] how to search for asterix character?

>I use vb or in SQLlite Expert the * does not seem to work > >From my testing * doesn't seem to work in the likeif I use '%33' it > returns >everything with test33if I use '33%' it returns everything with >33testif I >use '%33%' it returns everything with 33test, test33 which is the same as >*

Re: [sqlite] how to search for asterix character?

> "...Where SomeColumnContent Like '%someother[*]part%' Thanks Olaf, that works fine. As my customers won't get this I think I might let my code take care of this. How would it work with glob? RBS On Wed, May 26, 2010 at 7:05 PM, Olaf Schmidt wrote: > > "Bart Smissaert"

Re: [sqlite] how to search for asterix character?

"Bart Smissaert" schrieb im Newsbeitrag news:aanlktil5lha-3-l6x8umwv8e3pyrda6h0ln3dcoyh...@mail.gmail.com... > Yes, it must be either my code or the wrapper to blame. > Thanks for confirming. It's a wrapper-"problem", but a perhaps a coding problem as well... ;-) The

Re: [sqlite] FTS1 or FTS2

Or to more directly answer the question... select * from phone where number like '%56%'; Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin Sent: Wed 5/26/2010 12:25 PM To:

[sqlite] 64-bit DLL download location

Does anyone know where I can download a LIB and DLL pre- built for Win7-64bit? I am in the process of converting C/C++ projects from Win XP to Win7-64bit and don't want to build the DLL myself. Carl Buhrke ___ sqlite-users mailing list

Re: [sqlite] FTS1 or FTS2

On 26 May 2010, at 6:24pm, Sam Carleton wrote: > 212-456-7890 > 212-789-1234 > 212-564-9875 > 212-357-8452 > 212-285-6100 > 560-851-5522 > > If searching for a number with '56', I want to get back: 212-4*56*-7890, > 212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100. Is FTS the right >

Re: [sqlite] how to search for asterix character?

Yes, it must be either my code or the wrapper to blame. Thanks for confirming. RBS On Wed, May 26, 2010 at 6:18 PM, Black, Michael (IS) wrote: > This works for me: > > sqlite> create table t(t varchar); > sqlite> insert into t values('Testing*with asterisk'); > sqlite>

Re: [sqlite] how to search for asterix character?

> I use vb What wrapper is that? RBS On Wed, May 26, 2010 at 6:14 PM, ro...@zhole.com wrote: > I use vb or in SQLlite Expert the * does not seem to work > From my testing * doesn't seem to work in the likeif I use '%33' it returns > everything with test33if I use '33%' it

Re: [sqlite] how to search for asterix character?

This works for me: sqlite> create table t(t varchar); sqlite> insert into t values('Testing*with asterisk'); sqlite> insert into t values('Testing without asterisk'); sqlite> select * from t; Testing*with asterisk Testing without asterisk sqlite> select * from t where t like '%*%'; Testing*with

Re: [sqlite] how to search for asterix character?

I use vb or in SQLlite Expert the * does not seem to work >From my testing * doesn't seem to work in the likeif I use '%33' it returns everything with test33if I use '33%' it returns everything with 33testif I use '%33%' it returns everything with 33test, test33 which is the same as * Hope

Re: [sqlite] how to search for asterix character?

Yes, thanks, it looks it might indeed be the (VB) wrapper that is to blame here. Will contact the developer. RBS On Wed, May 26, 2010 at 5:53 PM, Jean-Christophe Deschamps wrote: > >>How do I search for the asterix character *  ?? >> >>This doesn't work: >>select field1 from

Re: [sqlite] how to search for asterix character?

>How do I search for the asterix character * ?? > >This doesn't work: >select field1 from table1 where field1 like '%FH%*%' >as the * character here seems to be ignored. > >Using the latest version of SQLite. You're doing it right. Either you use a wrapper that messes with * in litterals or

[sqlite] how to search for asterix character?

How do I search for the asterix character * ?? This doesn't work: select field1 from table1 where field1 like '%FH%*%' as the * character here seems to be ignored. Using the latest version of SQLite. RBS ___ sqlite-users mailing list

Re: [sqlite] Does sqlite always allow creating own field named 'rowid'?

On Wed, May 26, 2010 at 6:19 PM, Pavel Ivanov wrote: > > But just > > wondering, was allowing to create such field intentional? As I suppose > such > > field is complete phantom since most sql queries will interpret rowid > > internally and won't allow access this user field

Re: [sqlite] Does sqlite always allow creating own field named'rowid'?

> Of course if you define a column "rowid integer primary key" then the > declared column and the internal rowid are one and the same... As an extension of this, if you are in the habit of relying on the internal rowid rather than having your own specifically declared "integer primary key"

Re: [sqlite] Does sqlite always allow creating own field named 'rowid'?

> While implementing a table that intended for arbitrary table storage, I > automatically named some field rowid not linking at the moment that it > will > have a name conflict with sqlite internal rowid name. Lately I discovered > this, and (not a big deal) recreated table with a different name.

[sqlite] Does sqlite always allow creating own field named 'rowid'?

While implementing a table that intended for arbitrary table storage, I automatically named some field rowid not linking at the moment that it will have a name conflict with sqlite internal rowid name. Lately I discovered this, and (not a big deal) recreated table with a different name. But just

Re: [sqlite] Update detail record based on master properties

> where exists ( > select 1 from master_table where >master_table.id=detail_table.masterid and >masterfieldtocheck = okvalue and >masterfield2tocheck = okvalue2); > > -- or > > where detail_table.masterid in ( > select id from master_table where >masterfieldtocheck = okvalue and

Re: [sqlite] Update detail record based on master properties

Max Vlasov wrote: > We all know UPDATE sometimes is limited so in order to make some complex > conditional updating we can only rely on the complexity of WHERE clause. > > I would like to update my detail table based on master properties (so to set > some value only if the corresponding master

Re: [sqlite] Update detail record based on master properties

On 26 May 2010, at 9:21am, Max Vlasov wrote: > UPDATE detail_table SET somefield=somevalue > WHERE > (SELECT masterfieldtocheck FROM master_table WHERE master_table.id > =detail_table.masterid)=okvalue > > Is there a way to alias the master table when I need to check several fields > of the

[sqlite] Update detail record based on master properties

We all know UPDATE sometimes is limited so in order to make some complex conditional updating we can only rely on the complexity of WHERE clause. I would like to update my detail table based on master properties (so to set some value only if the corresponding master record fits some conditions).

Re: [sqlite] please help beginner on install issue

I have fixed the problem with google's help: just _sqlite3.so is not installed correctly. i reinstall python, the problem is gone. thanks. -- From: "zeal" Sent: Wednesday, May 26, 2010 2:59 PM To: "General Discussion of SQLite

[sqlite] please help beginner on install issue

Hi, beginner question: i installed python, sqlite3 in linux with step: 1cd sqlite-3.6.22 2./configure --prefix=/home/omc/daisy/python/ 3make 4make install when i run the python, and want to import sqlite3, error at: Python 2.5.2 (r252:60911, May 26 2010,