Tutorials & Manuals

Prev: <a href="https://revolution.screenstepslive.com/s/revolution/m/sqlyoga/l/5867-retrieve-records-from-the-database-using-sql-record-objects">Retrieve Records from the Database Using SQL Record Objects
Next: <a href="https://revolution.screenstepslive.com/s/revolution/m/sqlyoga/l/5869-delete-records-from-the-database-using-sql-record-objects">Delete Records from the Database Using SQL Record Objects

Update Records in the Database Using SQL Record Objects

## Create SQL Record object by getting record from database.

## Store the found record in theRecordA

sqlrecord_find "lessons", 1, theRecordA

sqlrecord_set theRecordA, "title", "My New Lesson"

sqlrecord_set theRecordA, "description", "A short lesson I made and modified."

sqlrecord_update theRecordA

put the result into theError

put it into theAffectedRows