This guide explains how to use the Table object in a project.
Creating local table in a project with the Smartface means creating SQLite table in an app for Android and iOS. There are two approaches to create the table objects:
A table can also be created by The SQL query:
A table can have different kinds of columns, let's insert different types as Integer, String, DateTime and Float columns.
A table can be inserted by The SQL query:
How to Keep Data Secure
In order to keep all data in secure, you can encrypt your datas with JS encryption libraries.
Add the textButton btnEncrypt to the related page. Than when it's pressed the value 1 will be encrypted.
Run on Memory
If you need to filter a dataset, you may have to commit. If there is sensitive data committed, you should use the OnMemory table option. Therefore, the table will be kept in memory, but not stored locally. You can use inMemoryDB.sql file, which is placed inside Assets folder, in order to perform this.
Add the below code in inMemoryDB.sql as below :
Finally, developer must run inMemoryDb.sql as below:
Keep in mind that, inMemoryDb.sql is in memoryDB, not in defaultDB.