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
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, bracke
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
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
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 spec
> 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 separator
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] -- 70
[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 sqlite3_c
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 th
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 values(NUL
>>
>> > 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
>>
>>
Also, www.sqlite.org/lan
On Wed, 08 Dec 2004 14:27:45 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> 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
> 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.
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?
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.
Thanks,
--
Jeff Flowers
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 prag
Thanks you It works fine now
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 pr
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 t
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 Vis
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 this
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:
> >
22 matches
Mail list logo