B4A Library TD_DBNavBar

​

Status: UPDATE
Name: TD_DBNavBar
Code: B4A
Type: b4xlib
Version: 2.6
License: Royalty free for personal and commercial use
External License: Usage of BR_Button (C) Lucas Siqueira
Author: TechDoc G. Becker

Attached: Download Link

Update:

• mRS Resultset as public object added
• mID String as public variable added
• ID Property added to each button to hold the button name for later identification
• Some Bugfixes done

TD_DBNavBar is a user Interface (GUI) to choose and activate datamangement functions to be needed to mange stored data in an SQLite or SQLCipher Database. The Datamangement functions are not included (except movement of cursor position). They can be taken from DBUtils or TD_DBUtils (comming soon).
To interact with the User the view has 2 toolbars. BR_Button is used as Button View. The BR_Button View Class is included.

The Datanavigation Bar

Buttons goto First, Previous, Next, Last record of the Resultset.
At last right hand position button Find to position cursor by a given column value (TD_DBUtils).
In the middle the button PosInfo which displays the current cursor position (first is 1) and the row count of the selected rows in the resultset. A short click will switch the toolbar to the Database bar.

and the Databasebar.

Buttons insert, update, reload and delete. Insert, update, delete may call functions to manage the databasetable data. Button reload will be used to recall a given Select Command to reload the data from the database to the resultset.
In the middle button DBInfo database information may be shown. If pressed by a long click a Dialog of all Database, Table and column details is shown (TD_DBUtils). A short click will switch the toolbar to Datanavigation bar.

Both bars are part of a customlistview. to show the desired bar you may scroll up or down as well.

Custom Properties:
setButtonText to set the text to the middle button.
markButton to change/reset the Bordercolor of a button (except middle button)
KeyClick to turn key click on/off

There are some custom Designer Properties as well to customize the Buttons GUI.

The download link will lead you to a google drive cloud where you can download the example project (b4a). Please notice that you will find the b4xlib in the libs folder.
The example project shows all the needed steps to install and use the view.