If all the collum contents are identical why should it matter wich one is modified? Just do a select ... Limit 1 .... subquery in the update.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of c.panel Sent: Thursday, June 26, 2008 4:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL understanding problem OK! so rowid should be ok ! thank you! -- View this message in context: http://www.nabble.com/SQL-understanding-problem-tp18142381p18144242.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ 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