Wednesday, December 7, 2016, 3:12:05 AM, you wrote:
>> On Dec 6, 2016, at 5:40 PM, Richard Andersen <r...@taosoft.dk> wrote: >> >> cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName = >> 'filename.zip'"; > You can add other columns to set by adding more “name = value” > expressions in between SET and WHERE. > Here’s the documentation of the UPDATE command: > http://www.sqlite.org/lang_update.html > <http://www.sqlite.org/lang_update.html> Ah - have already looked at these pages but ignored the diagrams as I thought they were refering to some internal technical stuff, but now I realize they're explaining the syntax (never seen it done that way before). Thanks! Richard _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
