ue, February 15, 2011 4:48:24 PM
>Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR
>
>On 02/15/2011 06:04 PM, venkat easwar wrote:
>> Forgot to mention what error I am getting.
>>
>> near "order": syntax error
>> near "limit": syntax error -
Oh... Thanks Kennedy. Between any options on run time to enable the feature?
VENKAT
From: Dan Kennedy
To: sqlite-users@sqlite.org
Sent: Tue, February 15, 2011 4:48:24 PM
Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR
On 02/15/2011 06:04 PM, venkat
On 02/15/2011 06:04 PM, venkat easwar wrote:
> Forgot to mention what error I am getting.
>
> near "order": syntax error
> near "limit": syntax error - if i remove the order by clause
See under the "Optional LIMIT and ORDER BY Clauses" heading
on this page:
http://www.sqlite.org/lang_update.ht
Discussion of SQLite Database
Sent: Tue, February 15, 2011 4:32:40 PM
Subject: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR
Hi Buddies,
Sqlite support document says, update with limit and order by clauses are
supported. But I found it actually not working. Sample DB schema,
create table chec
1 4:32:40 PM
Subject: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR
Hi Buddies,
Sqlite support document says, update with limit and order by clauses are
supported. But I found it actually not working. Sample DB schema,
create table check_update( a int, b char);
insert into check_update values (1,'
Hi Buddies,
Sqlite support document says, update with limit and order by clauses are
supported. But I found it actually not working. Sample DB schema,
create table check_update( a int, b char);
insert into check_update values (1,'venkat',22);
insert into check_update values (2,'venkat',23);
Now
6 matches
Mail list logo