REPLACE INTO States (Material, Name, Qnt) values (1, 'MyName', Qnt + 1) I want to increase value of Qnt if the record already exist and insert it with 1 value if not exist, the default value for Qnt is 1 and it is NOT NULL
But the record done with these values (1, 'MyName, 1) Thanks in Advance -- Zaher Dirkey _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
