In this lesson, you add functions that access rows in a relational database. Add the functions in order, before the final end statement in SQLService.egl.
The addPayment() function adds a new row to the database.
To code the function:
The getAllPayments function reads all of the records from the table and stores them in an array.
To code the function:
The editPayment function replaces an existing row in the database with an edited version. The function assumes that the user previously read the row from the database.
To code the function:
The deletePayment function deletes the specified record from the table.
To code the function:
The createDefaultTable function creates a set of data for testing your completed application.
To code the function:
In the next lesson, you will create a widget to hold the table of expense data.