String constants should be enclosed in single quotes. Double quotes are for identifiers. So in your case you make perfectly legal no-op action - update field R with value of field R, i.e. leave field R unchanged.
Pavel On Wed, Feb 3, 2010 at 4:43 PM, Ron Hudson <[email protected]> wrote: > I am using the latest version of sqlite3.exe (version 3.6.22) Running > Windows Vista. The sqlite3 executable and > the database file are in a subdirectory of my Documents directory (where > I know rights are not a problem) > > In the table named "check", I am trying to update the value in a field > named "R" with the value of R. > Id is an integer primary key and I am trying to update the first record. > > update check set R="R" while id=1; > > then I "select * from check;" and the field R is unchanged. Why is the > field R unchanged? > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
