Hi,
I'm trying to update a field of the last record using UPDATE and MAX().
The following query parses ok but updates all records. Any reason why ?
UPDATE logs SET Stop = DATETIME('NOW') WHERE (SELECT MAX(ID) FROM logs)
Thanks,
Matt.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
