ODataDB Sample 21 - Tab Framework

This sample demonstrates how business users can create feature-rich database and web applications.

Database and web developers can use it to easily prototype applications.

To leverage these features, install the Tab Framework into your database.

You can install it using the SaveToDB add-in Application Installer or by using the source code from the SaveToDB SDK.

Note that you can use these applications in ODataDB, DBGate, DBEdit, and Microsoft Excel with the SaveToDB add-in installed.

Configure applications once, and use them across different platforms.

All the tables below are interactive.

Configuring Applications

Start by defining the required application tables in the tab.tables table.

For example, here are the configured tables of the sample application for recording money transactions.

Next, define the required columns and their properties in the tab.columns table.

The Tab Framework automatically creates auto-increment primary key columns, so you don't need to create columns like id.

You can specify the source tables for column values, such as account_id, item_id, and company_id in the sample.

You can also designate columns to be used as filter parameters.

Once configured, populate your list tables.

Below is the s21.accounts table. It does not allow adding or deleting rows because the protect_rows column is checked in the tab.tables table.

Here is the s21.items table:

Below is the s21.companies table:

Finally, here is the cashbook table.

Try changing filter parameters and table data, including columns like item_id or column_id.

The Tab Framework includes two roles: tab_developers and tab_users.

Tab_developers can configure applications, while tab_users can view and edit data.

Request your database administrators to configure database users first.

After that, you can manage application users yourself using the Actions menu (select a user and click the right-most button).

The Tab Framework supports localization of table and column names, as well as list table items.

Define the supported languages in the first step.

Then, add the translations. To enable translation of list table items, check the translation_supported column in the tab.columns table.

Your business users can select their preferred language and regional settings using language-specific URLs, such as:

The Tab Framework empowers business users to create multi-user applications independently.

Users can view and edit data in a browser, the DBEdit desktop app, or Microsoft Excel.

You can download the Tab Framework with the SaveToDB SDK for Microsoft SQL Server.