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