Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread Kees Nuyt
rs@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 easwar wrote: >> Forgot to mention what error I am getting. >> >> near "order": syntax error >> nea

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread venkat easwar
Oh... Thanks Kennedy. Between any options on run time to enable the feature? VENKAT From: Dan Kennedy <danielk1...@gmail.com> To: sqlite-users@sqlite.org Sent: Tue, February 15, 2011 4:48:24 PM Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR On

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread Dan Kennedy
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:

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread venkat easwar
ue, February 15, 2011 4:34:21 PM Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR Forgot to mention what error I am getting. near "order": syntax error near "limit": syntax error - if i remove the order by clause VENKAT From: ve

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread venkat easwar
e-users@sqlite.org> 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

[sqlite] UPDATE WITH ORDER BY LIMIT ERROR

2011-02-15 Thread venkat easwar
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);