I have found the following: BEGIN; UPDATE entry SET Spinnaker="No" ,Singlehand="Doublehand" ,Doublehand="Third" ,Multi="Multihull" ,Furler=" " WHERE ROWID="45"; COMMIT
Results in the value of the column Singlehand to be set to the current value on the column Doublehand for this ROWID. Experiment show that when the value of the Column (say A) is the same as the name of another column (say B), the first column (A) is set to the current value of the second (B). THis is all being run on an IMAC using MACOS X version 10.6.2. I have not run these test on another a system. Is there something that I am missing? Thank you for your assistance. Best Regards, Ray Ray Irvine Crew's Nest - #1383 c34irvine1...@comcast.net http://www.flickr.com/photos/crews_nest/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
