SQLite component can be used to interface with the Android device built-in SQLite Relational Database Management System (RDMBS). Using this component, you'll be able to create complex data structures and create parent-child tables (e.g. employer, employees) and query data from 1 or multiple tables by joining tables together.
SQLite component is a non-visible component that has blocks that you see in image blow:.
- DropTable - used to drop an existing table
- DisplayTables - displays all table names within the current database
In our sample app, we will add ability to create table, insert data, read data, drop table. First, we will create a table that has 4 columns of type varchar:
Next, we will insert some test-data into this table. Notice from image below:
Now, we will query data to display result. The result will be in form of a LIST where 1st row will be the column headings.
If you wish to eliminate the column heading, just get the values starting from 2nd element of the LIST: