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
"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)
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
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
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
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'
6 matches
Mail list logo