Android Question How to create app to display the database tables and search between them?

Yousef AlMashri said:

Hi guys,
I'm a new user of B4A tool.
First of all, I would like to thank everyone here for helping.
My question is, I want to create simple app to display the SQL Tables with search button.
So, I was created different 4 tables using (DB Browser for SQLite) and I saved them as file.db.

Note: I don't want to add anybutton for (add, edit, delete). The app wanted to display the tables only.

Now I want to start to create B4A project to display the tables and search between them.
The problem here is, I don't know how I should start.

Can anyone help me please.

Click to expand...

RB Smissaert said:

When you say display the tables only, I take it you want to display the tables plus their fields.
So, you want some kind of DB Browser.
In that case you could make 2 listviews, one on the left for the tables and one on the right for
the fields of the selected tables. You could then populate both listviews from 2 views, created
like this:

CREATE VIEW SysObjects as select type as ObjectType, name as ObjectName from sqlite_master where type in('table', 'view', 'index')

CREATE VIEW SysColumns as select ObjectType, ObjectName, cid as ColumnID, name as ColumnName, type as Affinity, IsNotNull, dflt_value
as DefaultValue, pk as IsPrimaryKey from SysObjects join pragma_table_info(ObjectName)

The result of:

select * from SysColumns

Will give you all need to populate both listviews.

This I think is a good starting point.


RBS

Click to expand...

klaus said:

You may have a look at:
Android SQLite Viewer
SQLiteLight four simple SQLite projects
B4A User's Guide chapter 5 SQLite Database

Click to expand...