Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

SQLBrowser

Article Index

Page 1 of 4

Introduction to the SQL Browser

If you are more than expert than the average user and you know how to write SQL (Structured Query Language) then you will love the SQL Browser. Make any valid SQL query and run it.

The return or result of your SQL rows can be grouped, filtered and sorted with just a few mouse clicks. This SQL browser also allows drag and drop features, which make it easy to work with.

Anything can be exported to the XML (Extensible Mark-up Language), HTML (Hypertext Mark-up Language), Microsoft Excel, or Text File formats. This powerful tool will empower you to produce your own custom view of your data in TurboCASH4.

Even if you are not an expert in the details or file structure of TurboCASH4, you can also use this SQL Browser to filter and sort to see what you need to see. You may also use the SQL Browser to filter, sort and analyse your data.

This option allows you to generate queries and connect to the Database of a selected Set of Books using the Structured Query Language (SQL) standard. This Browse will list all the Firebird Database Files (*.fdb File extension) for the Set of Books.

License

This program is licensed under a commercial license. A nag screen will be displayed when this plugin is launched and will pop up with regular intervals.

This Plugin is already included in the TurboCASH releases. Before you can access the SQL-Browser plug-in, you need to activate it.

Commercial: Once-off payment

Order: SQLBrowser

Once you have purchased the SQL Browser plug-in, a key to unlock this plug-in will be available on the Register your TurboCASH screen.

 

Using the SQLBrowser

To use this option, you need to open a Set of Books. The SQL Browser will list all the tables in the database of the active (opened) Set of Books.

To Access and Use the SQLBrowser:

  1. On the Setup ribbon, select Tools → Plug-ins → Tools → SQL Browser menu. The SQL Browser screen will list all the tables of the active Set of Books.

  2. Select a table from the list.

  3. Right-click on the selected table and select the Open option from the context menu. The data for the selected table will be loaded in the bottom half of the TCASH Browser screen. In this documentation, the “TRANSACT” table is opened. The transactions will be displayed as follows:

    You may click on the + icon on the list to view the list of columns on the selected table (e.g. TRANSACT as in this example).

  4. You may use the context menu's on each of the sections to work with your data, if necessary:

    1. Tables – Open, Drop or Empty a selected table. You may also extract data (i.e. all Table names or the entire table including the properties (i.e. datatype and width) in the wiki format to the Script Editor all the Table names in a Set of Books. This can be copied and used in documentation and for development.

    1. Script Editor – You may write or edit SQL script in this section. If the entire table or a selected record is exported as SQL script in the Records section, it will also be displayed in this section. You may also configure the editor font.

    2. Records – This is the records in a table. For example, each line in a posted batch will create a record in the TRANSACT (Transaction) table. In this section, you may configure columns, filters, groups to view the data in a table. You may also export the entire table or a selected record as SQL script to the SQL Editor.

  1. Once you are done, you may Export, Save SQL and Load SQL.

  2. To exit the SQL Browser, click on the File → Exit menu; or click on the Close button on the titlebar.