DBGate Sample 01 - Basic Features

This example shows basic DBGate features:

You may select data from tables, views, and stored procedures.
You may save data changes back to a database.

DBGate supports the following ways to save changes:

You may save changes to the target table or view directly.
You may save changes using procedures for insert, update, and delete operations.
You may save changes using the cell change handler procedure.

Try these examples:

s01_cashbook Simple plain table
s01_view_cashbook Simple view editable by default
s01_usp_cashbook Simple stored procedure editable by default
s01_usp_cashbook2 Simple stored procedure saved by _insert, _update, and _delete procedures
s01_usp_cashbook3 Simple stored procedure with editable cells saved by a _change stored procedure
s01_usp_cash_by_months Report stored procedure with editable cells saved by a _change stored procedure

You may analyze requests and returned results using the browser developer tools.

You may find the definition of any object using the code browser below.
Take a look at the procedures used to save changes. They are simple.

Note that DBGate generates the metadata model, automatically reading the database metadata under the user's account.

So, a user gets only available objects and features. Take a look at metadata for power user1 and restricted user2.

Note that in a production environment, DBGate requires a username and a password to connect to a database.
These samples do not require credentials for demo purposes.

Code Browser

DBGate creates the webforms automatically based on underlying database objects.
For example, it creates the s01_cashbook form using the s01.cashbook declaration only.

You may download samples for any supported database platform with the SaveToDB SDK.