flakpit wrote: > > The SQL to insert the blob into my database is : > > "INSERT INTO archive (docnumber, document) VALUES (?,?)" > > How to change the syntax to update a blob field? Is it the same as updating > normal data or a variant on the above?
You can replace the data using an replace statement (an abbreviation of insert or replace) assuming that docnumber is the primary key. replace into archive (docnumber, document) VALUES (?,?) Otherwise you would use an update statement to do an update. update archive set document = ? where docnumber = ? HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users