How do you create a table (grid) to edit or delete items

See now an aia project example of SQLite with Tableviewer full CRUD (Create,Read,Update,Delete)

sqliteCRUDwithTableviewer.aia (57.0 KB)

Notes

  • This comes with a sample db in the assets, which is copied to the ASD on first run, and set as the default database. (Backup up your database if you already have one in companion app, as this will be overwritten)
BLOCKS

SCREENS

Create

Read

Select option

Update

Delete

Before you ask for filtering of list, or other features, most of these can be done with sqlite queries on the underlying data.

2 Likes