To update a database table, please do the following.
-
Add the following code to your script.
sqlQuery =” UPDATE Persons SET Address='950 Tower Lane' City='Foster City' WHERE LastName='GuiXT' AND FirstName='Synactive'"
-
Add an execute statement as in the following example:
db.exec(sqlQuery);
-
The table 'Persons' has now been updated with the new information.