Android Question SQLite table editor code sample

peacemaker

Expert
Licensed User
Longtime User
HI, All

Do we have any _universal_ class for SQL table editing ? (for B4A at least)
Say:
1) some menu for the table name selection
2) preparing the SQL requests for SELECT, INSERT (add record), UPDATE (selected record)
3) getting PRAGMA and fields types of the chosen table
4) single VIEW activity with some scrolling and _clickable_ interface to see whole the table, if even many fields.
DButils.ExecuteHTML may be OK, but it needs to add the possibility to replace the column names to readable_for_user_ones
5) single ADD/EDIT activity to work with the new/chosen record with the EditText array (filtered input according to the fields types), that INSERTs or UPDATEs the record back to the db
6) clicking on the VIEW activity record - for menu to DELETE or EDIT the record by point 5 above...

And noting everywhere that index "id" field must be passed by...

Any ideas ?
 
Last edited:
Top