Viewing data
On Table view or View view tap "Show Data" button, Data view will pop.
* Note that Data view is opened in read-only mode while showing View data. That is because SQLite do not support View data editing. That means you can't insert, delete or update anything in the Data View. Just view.
Adding rows
On Data view tap on "+"(Plus) button, a new row will be added. Edit fields of the row. Read more in "Editing data" section.
Editing data
On Data view tap on any cell and type data you need.
If you need to type multiline text tap on ">"(Forward) button. Edit text view will pop.
In Edit text view type your text, then tap "Hide keyboard" button. Then tap "<-"(Back) button.
Deleting rows
On Data view tap on empty boxes in left side of each row to check it. To
Then tap "-"(Minus)button.
Data filtration
On Data view tap the button with a loupe sign, Filter and Order view will pop. Switch to Filter view
Tap "+"(Plus) button to add a new filter rule. Filter Rule viewer will pop.
In Filter Rule editor define column, value and operator in appropriate fields. Tap "<-"(Back) button to save the rule.
To edit existing rule tap on it. Filter Rule viewer containing the filter will pop.
To delete rules check rules you want to delete. Then tap "-"(Minus)button.
To apply current filter tap "<-"(Back) button on Filter and Order view.
Ordering data
On Data view tap the button with a loupe sign, Filter and Order view will pop. Switch to Order view
Tap "+"(Plus) button to add a new order rule. Order Rule viewer will pop.
In Order Rule editor define column and order mode in appropriate fields. Tap "<-"(Back) button to save the rule.
To delete rules check rules you want to delete. Then tap "-"(Minus)button.
To apply current order tap "<-"(Back) button on Filter and Order view.
Paging data
To set number of data rows to be shown on Data view tap a button with three lines sign, Page Number view will pop.
To select a page of data to be shown on Data view tap "<"(Previous) ">"(Next) buttons.
Or tap a button with number of current page betweens this two buttons, Page Number view will pop.
