Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

The precompiled version did work. I was just trying to compile it myself to get experience building a linux box. Lloyd - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, January 03, 2006 1:29 PM Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list) "Lloy

RE: [sqlite] LIMIT keyword does work in an UPDATE statement

Dennis, it works perfectly well, so thank you for your quick and relevant solution. test mjom <[EMAIL PROTECTED]> a écrit : Hi, i'm beginning with SQLite and it seems that the keyword LIMIT is not supported on an UPDATE statement. Does anybody would have a workaround to update only the very fi

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Tue, Jan 03, 2006 at 10:15:17AM -0500, [EMAIL PROTECTED] wrote: >> test mjom <[EMAIL PROTECTED]> writes: >> >> > create table tbl1 ( id integer primary key autoincrement, ref >> > integer, sts varchar(16)); >> > insert into tbl1 (ref,sts) val

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

test mjom wrote: Hi, i'm beginning with SQLite and it seems that the keyword LIMIT is not supported on an UPDATE statement. Does anybody would have a workaround to update only the very first row matching the search criteria ? Ex : create table tbl1 ( id integer primary key autoincreme

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

On Tue, Jan 03, 2006 at 10:15:17AM -0500, [EMAIL PROTECTED] wrote: > test mjom <[EMAIL PROTECTED]> writes: > > > create table tbl1 ( id integer primary key autoincrement, ref > > integer, sts varchar(16)); > > insert into tbl1 (ref,sts) values (10, 'ready' ); > > insert into tbl1 (ref,sts

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

test mjom wrote: Hi, i'm beginning with SQLite and it seems that the keyword LIMIT is not supported on an UPDATE statement. Does anybody would have a workaround to update only the very first row matching the search criteria ? Ex : create table tbl1 ( id integer primary key autoincreme

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

test mjom <[EMAIL PROTECTED]> writes: > create table tbl1 ( id integer primary key autoincrement, ref > integer, sts varchar(16)); > insert into tbl1 (ref,sts) values (10, 'ready' ); > insert into tbl1 (ref,sts) values (20, 'ready' ); insert into tbl1 > (ref,sts) values (30, 'ready' );

[sqlite] LIMIT keyword does work in an UPDATE statement

Hi, i'm beginning with SQLite and it seems that the keyword LIMIT is not supported on an UPDATE statement. Does anybody would have a workaround to update only the very first row matching the search criteria ? Ex : create table tbl1 ( id integer primary key autoincrement, ref in

[sqlite] 3.2.7 test failure

Hi, I've downloaded the 3.2.7 source and built it (on windows). Then I run the tcl test suite and got the following errors: malloc-10.105... Error: table abc already exists malloc-10.106... Error: table abc already exists malloc-10.107... Error: table abc already exists ... ... Error: table abc a

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

"Lloyd Thomas" <[EMAIL PROTECTED]> wrote: > Thanks Kimball > Your right about having a little experience. I am > just running into error after error installing apps, but I'm learnoing > slowly. Anyway, I was trying to install the sqlite support for another > application I

Re: [sqlite] undelete records?

Kimball Larsen <[EMAIL PROTECTED]> wrote: > I have an sqlite 2.1 format database file with records in it that > have been marked deleted (I believe the term for this is that their > pages are on the freelist) > Is there any simple way to get these records back? Or are they gone > forever? > A

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

Lloyd Thomas wrote: > > Thanks Kimball > Your right about having a little experience. I am > just running into error after error installing apps, but I'm learnoing > slowly. Anyway, I was trying to install the sqlite support for another > application I want to use and as a

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

Thanks Kimball Your right about having a little experience. I am just running into error after error installing apps, but I'm learnoing slowly. Anyway, I was trying to install the sqlite support for another application I want to use and as a side issue it seems to have in