db Manager Lite displays a graphic representation of data structures. It can display a real database, i.e., multiple datasets, each containing multiple recordsets or tables. The Data Tree Window can also show other hierarchically organized files.
Selecting a dataset in the Data Tree Window sets the data set as the default data set and displays its tables in the Recordsets drop-down selection box. Selecting a table in the display sets it as the default table and fills the Data Grid with records from the table. Full, multi-line SQLite queries, including "dot" commands, can be entered in either the Composition Window or Results Window and run. DBML can also run queries from disk files
The DB Manager Window
Near the left-top of the window is a tuerquoise "Menu" button. Clicking the button enables a drop-down menu that runs various database functions..
On the left, top of the window is a set of buttons arranged vertically. The first or topmost button should display this document. The next three buttons are window control buttons. The first minimizes the window. The second button toggles the window to stay on top of other windows or not. The third button closes the process.
To the left of those buttons is a data tree window. It can contain data base structures or display data from TCB data tree files. At the top of the data tree display are three buttons arranged horizontally. The first or left-most button opens a dialogue to select a data tree file to load. The next button from the left clears the data tree diagram. The last button refreshes the data tree.
A set of drop-down selection boxes are located to the right of the data tree. The top left drop-down, Data Sets, contains SQLite data set files names used in the process. It is loaded with an initial list of files from a prepared plain text file. Subsequently, it can be added to using the Open dataset file button described below. When a dataset is selected and the Enter key is pressed, the dataset is set as the default dataset, and the tables in the data set are loaded into the Recordsets drop-down next to it.
When a table is selected in the Recordsets drop-down and the Enter key is pressed, the Data Grid is filled with records from the table. Below the Data Sets and Recordsets drop-downs are three drop-downs containing useful information that can be used in formulating SQL queries. When an item is selected in these drop-downs and the Enter key is pressed, the text of the item is inserted into the Composition Window.
To the right of the data tree window are two large boxes arranged vertically, the Data Grid, and Composition Window. The Data Grid displays data from TCB data grid files or SQLite databases generated from queries or object functioning. The Composition and Results windows can be used interchangeably. The difference is that the drop-down objects in this process, insert their selected contents into the Composition Window when the Enter key is pressed. Both these boxes have clear box, run SQL, execute box contents, save to file, and load from file buttons. The Composition Window also has an explain query button.
Finally
The Menu button at top of the DB Manager window provides most of the real power of db Manager Lite. The Make browse selection makes a table browse\edit process for the default table and runs it. The process screen is properly labeled for the table with any needed input boxes. It contains a Data Grid loaded with records from the table. The created process will have the current screen background image applied.
The Export data selecttion opens a dialogue for the user to select a file to exports data from the default table into a .csv file.
THe Check data set selection checks the default dataset for integrity, if OK, the Composition Window will display "ok."
The Compact data set selection compacts the default dataset and the
The Load query from file runs query from a file and puts the results in the Composition Window.
The Default table selection gets information for the default table and inserts it into the Composition Window.
The Open a data set selection opens a database file or create a new one. Open sets the dataset file as the default or creates it new, adds it to the Data Sets drop-down, loads the dataset structure into the Data Tree, and loads the Recordsets drop-down with tables, if any, from the dataset.
The Add column selection opens a dialogue to add a column to the default table.
The Rename default selection opens a dialogue to change the name of a table.
The Register default selection registers the default default table as a TCB table. It creates a special descriptor record for the table in a system table called "Recordsets." If this table doesn't exist in the default dataset, it is created automatically. This descriptor uses descriptions for the table that already exist. The Recordsets descriptor record can be edited to create enhanced descriptions for a table structure.
The Import .csv data selection opens a dialogue for the user to select a file to import comma separated or .csv data into the default table. Of course, the format (location of data) should mirror that of the table.
The Recordset Master selection runs te RecordSet Master program to create TCB datasets. It produces SQLite datasets and tables with special descriptors for enhanced TCB processing. All the tables created by RecordSet Master have the first column described as "rsid integer autoincrement." It creates a special descriptor record for the table in a system table called "Recordsets." If this table doesn't exist in the target dataset, it is created automatically.
The Remove the default selection opens a dialogue to delete the default table from the default dataset.
There is a row of data control buttons for scrolling and adding, deleting, and updating the table. Next is a search box that allows a record to be placed in the view/edit area using its id number. The user can also enter a SQL where clause without "where" and no closing semicolon, ";". For example: categoryname like '%produce%'. That example will result in data from the first record with the string "produce" in the "categoryname" column being placed in the view/edit area. Selecting and the right-clicking a record in the Data Grid, places its data in the view/edit area.
Summary
The db Manager Lite process provides a better SQLite database manager than most all hard-coded database managers except maybe our own from which this process is modeled on. In fact, the only thing the db Manager Lite process doesn't do that our hard-coded one does, is convert dBase .dbf files. But, the drag-and-drop TCBdbCnv.exe program that comes with this version does that.
Features:
Copyright © 1982-2016 Phoenix Information Systems/TM all rights reserved
Contact: Fred Pierce, makpiya@aol.com, makpiya@gmail.com, 831.240.9969