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. Dan. > Can anyone help me? > > Thanks, > > Andy > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
