Let’s use SQLite of the android terminal!

　for study of the SQL　or Simple demonstration of the RDB system or Data management etc.

Free Version.

+++can do it

create database
create table
Data entry to a table
Registration of the search pattern

* cannot read DB of other application.

*——————————–
* Operation guide
*——————————–

1)List of databases screen
+It changes to a list of tables screen when I touch it by DB name.
+make DB when I push down create DB button.
+It changes to a list of conditions screen when I push down "search DB" button after checking one check box of the list of DB.
+DB which I checked is deleted when I push the "DB deletion" button after checking the check box of the list of DB.
+sql file is made when I push down a "SQLScript output" button after checking the check box of the list of DB.

2)List of tables screen
+It changes to a list of items screen when I touch it by a table name.
+I make table when I push down a "table new making" button.
+When I check one check box of the list of tables and push the "alter name of table" button, I change a table name.
+When I check the check box of the list of tables and push the "drop table" button, I delete the table which I checked.
+When I check one check box of the list of tables and push the "input data" button, it changes to a list of data screen.

3)List of items screen
+It changes to an item addition screen when I push the "add item" button.

4)Item addition screen
+I input the attribute of the item.
+An item is made when I push the "save" button.

5)List of datas screen
+It changes to a data entry screen when I touch it by data.
+It changes to a data entry screen when I push the "add data" button.
+All data in the table are deleted when I push "delete all lines" button.
+When I check the check box of the List of datas and push the "delete choice line" button, the data which I checked are deleted.
+CSV is output when I push the "write CSV" button.
+I read CSV data when I push the "read CSV" button.

6)data entry screen
+I can change the data of the item where I touched when I touch it by the data of the list.
+Data are saved when I push the "save" button.

7)List of conditions screen
+It changes to a condition input screen when I push the "add view" button.
+All conditions are deleted when I push "delete all lines" button.
+When I check the check box of the list of conditions and push the "delete choice line" button, the condition that I checked is deleted.
+When I check one check box of the list of conditions and push the "search(list)" button, it changes to a list of search data screen.
+When I check one check box of the list of conditions and push the "search(detail)" button, it changes to a detail of search data screen.

8)Condition input screen
+I input an indication item, a search table, a condition.
+Condition are saved when I push the "save" button.

9)List of search data screen
+CSV data are output when I push the "CSV output" button.

10)Search data details screen
+Data before one are displayed when I push the "Prev" button.
+The next data are displayed when I push the "Next" button.

—————-
https://market.android.com/details?id=com.got.touchdesqlite

—————-
Version 1.30
change limits a function

Version 1.10
limits a function
Version 1.01
　Adjustment　Screen Layout
Version 1.00
First Version