The first step is to create a SQL Record object.

put sqlrecord_createObject("lessons") into theRecordA

## theRecordA is now an array that includes all fields in the 'lessons' table.

Now that you have a SQL Record object you can set the column values for the new record. In this example the "title" column and "description" column are being assigned values.

sqlrecord_set theRecordA, "title", "My Lesson"

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

Once you are done assigning values to the columns you can create the record in the database.

sqlrecord_create theRecordA

put the result into theError

put it into theAffectedRows

## In addition to the other column values, theRecordA now contains the database value for the 'id' (primary key) column.