Update a database

Added by iNTERFACEWARE

Use conn:execute() to update a database table

Source Code
   -- connect to a SQLite database
   conn = db.connect{
      api = db.SQLITE,
      name = 'test',
      live = true
   }   
      
   -- update data in a database table
   conn:execute('UPDATE Patient SET FirstName = "Fred", WHERE LastName = "Smith")')
Description
Use conn:execute() to update a database table