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