Web SQL Database.
p170E_SQLDatabase.aia (7.3 KB)
We don't need to add libraries.
We can use the SQL command: https://www.w3schools.com/sql/default.asp
We will use Web SQL Database, currently (since 2010) W3C does not support this development, but it works and we can use it without problems.
IndexedDB is more modern and somewhat more complicated to use:
- Every time you modify an .htm file, restart the MIT Companion to update the changes.
- Beware of single quotes (') and double quotes (")
tx.executeSql('UPDATE usuarios SET name = ' + '"' + name_in + '"' + ', age = "' + age_in + '"' + ' WHERE id =' + id_in + '');