[sqlite] How to search words

Hi all, I am quite-learner of SQLite. I want to clear some doubts regarding Can i search a word in the whole of the database.? With advanced thanks and Regards Anantha Narayanan.T.L CELEBRATE FOR A REASON CALLED UNITY. UNITE FOR A REASON CALLED LIFE. -- "This e-mail message may contain

Re: [sqlite] Whole word searches

Kurt Welgehausen wrote: There are no brackets in the SQL spec; that's a Microsoft extension. SQLite's glob operator has similar syntax; it's an extension also. If it weren't for brackets, in another context, I might still be using Access (and would be much the poorer for it). In some cases,

Re: [sqlite] NULL values with NOT NULL constraint

On Wed, 8 Dec 2004, D. Richard Hipp wrote: Ara.T.Howard wrote: Has anyone seen anything like this and can suggest possible causes? does your code fork? Ooo. That sounds like the voice of experience speaking. :-) I should add forking to the documented list of ways to corrupt your database file. i

Re: [sqlite] Sequences In SQLite

I want to apologize for not thinking of checking the FAQ. I didn't see what I was looking for in the documentation and totally forgot about the FAQ. Thanks, and again, sorry. -- Jeff Flowers

Re: [sqlite] Whole word searches

Thanks Kurt. I think glob looks promising. best regards -brett Quoting Kurt Welgehausen <[EMAIL PROTECTED]>: > > How do I search on whole words ... > > find ... "main" and don't want ... "maintain" > > I tried using brackets as specified in the SQL spec > > There are no brackets in the SQL

Re: [sqlite] Whole word searches

> How do I search on whole words ... > find ... "main" and don't want ... "maintain" > I tried using brackets as specified in the SQL spec There are no brackets in the SQL spec; that's a Microsoft extension. SQLite's glob operator has similar syntax; it's an extension also. If your word

Re: [sqlite] NULL values with NOT NULL constraint

Ara.T.Howard wrote: Has anyone seen anything like this and can suggest possible causes? does your code fork? Ooo. That sounds like the voice of experience speaking. :-) I should add forking to the documented list of ways to corrupt your database file. -- D. Richard Hipp -- [EMAIL PROTECTED] --

Re: [sqlite] Whole word search

[EMAIL PROTECTED] wrote: How do I search on whole words within a text field. For example, if I want to find the whole word "main" and don't want records with "maintain", how can I do that with Sqlite? Write your own string comparison function that does such things and register it using

[sqlite] Whole word search

I asked this question yesterday but got no answer, so here goes my second try. How do I search on whole words within a text field. For example, if I want to find the whole word "main" and don't want records with "maintain", how can I do that with Sqlite? I tried using brackets as specified in

Re: [sqlite] NULL values with NOT NULL constraint

On Wed, 8 Dec 2004, Michael Robinette wrote: I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1

Re: [sqlite] Sequences In SQLite

> Is there anything like serial sequences in SQLite? What I want to do is > have a primary interger key that auto-increments as records are added to > a table. http://www.sqlite.org/faq.html#q1 http://www.catb.org/~esr/faqs/smart-questions.html Ulrik P.

Re: [sqlite] Sequences In SQLite

On Wed, Dec 08, 2004 at 04:40:02PM -0500, Jeff Flowers wrote: > Is there anything like serial sequences in SQLite? What I want to do is > have a primary interger key that auto-increments as records are added to > a table. does the first entry in the faq on the website not do what you want?

Re: [sqlite] NULL values with NOT NULL constraint

Michael Robinette wrote: I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1 values(NULL,NULL,NULL); a

Re: [sqlite] Sql lite new user

Thanks you It works fine now

[sqlite] NULL values with NOT NULL constraint

I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1 values(NULL,NULL,NULL); a pragma integrity_check

Re: [sqlite] Sql lite new user

A connection object should not be copied, they will both hold the same internal connection to sqlite. I really should add a copy constructor, thanks for reminding me. For now just do sql.open("mk.db"). On Wed, 8 Dec 2004 18:45:17 +0100, ibrahim <[EMAIL PROTECTED]> wrote: > Hello, > > I m new

[sqlite] Sql lite new user

Hello, I m new to this mailing list , I currently try to add sql lite to a program I m working on It is a quizz program , And I want the question to be incorporated into a sql lite database to enable search ...etc.. I m download the source code of version 2_8_15 And compiled it under

Re: [sqlite] Setting The Width Option

Jeff Flowers wrote: > On Tue, 7 Dec 2004 18:57:18 -0800, "Scott Leighton" > <[EMAIL PROTECTED]> said: >> On Tuesday 07 December 2004 10:28 am, Jeff Flowers wrote: >>> Is it possible to set the .width option when calling the sqlite >>> frontend? I was surprised that there wasn't a options to do

Re: [sqlite] Setting The Width Option

On Tue, 7 Dec 2004 18:57:18 -0800, "Scott Leighton" <[EMAIL PROTECTED]> said: > On Tuesday 07 December 2004 10:28 am, Jeff Flowers wrote: > > Is it possible to set the .width option when calling the sqlite > > frontend? I was surprised that there wasn't a options to do this, > > something like: >