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 lock!=1 LIMIT 10; >> SQL error: near "LIMIT": syntax error >> >> >> I have compiled sqlite3 with the following configure options: >> >> % CFLAGS="-Os -DSQLITE_ENABLE_RTREE=1 - >> DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1" ./configure >> >> And, yes, I'm sure I'm executing the freshly-compiled sqlite3, and >> not >> the system-installed version. :-) > > You will need to build from the source tarball (the one with the > unsupported configure script), not the amalgamation package for > this to work.
Thanks a bunch. I'll try that... But I don't remember reading that the tarball I used was not suitable for these compile options. Where does it say this? Cheers, Andy Andy Froncioni --------------------------------------------------------------- My other signature is a pun. --------------------------------------------------------------- a.fronci...@sympatico.ca (514) 829-0255 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
