Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

y. Documentation on lemon is found in the "doc" subdirectory of the distribution. " But my tarball (sqlite-3.6.16.tar.gz) had an empty "doc" subdirectory. I tried to make doc but all I got was: make: Nothing to be done for `doc'. Thanks, Andy

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: > >> I know I'm probably doing something wrong, but I can't seem to get >> a simple UPDATE...LIMIT query working. >> >> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; >> SQL error: near "L

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

.. I've wasted more time on stupider things than this, so it's no use cying over spilled milk. :-) Thanks, Andy Andy Froncioni --- My other signature is a pun. --- a.fronci...@sym

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

On 6-Jul-09, at 12:18 PM, Dan wrote: > > On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: > >> I know I'm probably doing something wrong, but I can't seem to get >> a simple UPDATE...LIMIT query working. >> >> sqlite> UPDATE customers SET lock=1 WHERE

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

I know I'm probably doing something wrong, but I can't seem to get a simple UPDATE...LIMIT query working. sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; SQL error: near "LIMIT": syntax error I have compiled sqlite3 with the following configure options: % CFLAGS="-Os