Ray Irvine <c34irvine1...@comcast.net> wrote: > I have found the following: > > BEGIN; UPDATE entry SET Spinnaker="No" ,Singlehand="Doublehand" > ,Doublehand="Third" ,Multi="Multihull" ,Furler=" " WHERE ROWID="45"; > COMMIT
In SQL, string literals should be enclosed in single quotes. Column and table names may be enclosed in double quotes (double quotes are required if the column name is not a valid identifier, optional otherwise). As an extension, SQLite treats a string in double quotes as a literal if it cannot find a matching column or table name. Thus, in your statement, "Doublehand" represents the column entry.Doublehand - not a string literal 'Doublehand'. I strongly suggest you get into the habit of using single quotes for string literals, and using double quotes only in those very rare cases when they are actually required. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
