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

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 side

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?

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 want to

[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

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' );

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

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) values

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

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) values (10, 'ready' );

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

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: sqlite-users@sqlite.org Sent: Tuesday, January 03, 2006 1:29 PM Subject: Re: [sqlite] Building sqlite 3.2.8 on