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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to