Getting Started with DBEdit

Getting Started with DBEdit

DBEdit is an advanced database data editor.

It allows getting data from tables, views, stored procedures, or SQL queries and saving changes back to a database.

Here is a sample of data loaded from a view:

Contrary to other editors, DBEdit creates drop-down lists for fields and parameters using user-friendly value names from the referenced tables.

For example, this sample has the following tables:

And, the view has the following code:

CREATE VIEW s02.view_cashbook
AS
SELECT
    *
FROM
    s02.cashbook

It is enough! DBEdit finds related tables itself.

Moreover, database developers may customize a lot of features.

Here is a sample of an editable report implemented using a stored procedure:

DBEdit can execute supplied procedures or SQL codes on cell change events.

For example, the handler of this stored procedure has the following declaration:

CREATE PROCEDURE s02.usp_cash_by_months_change
    @column_name nvarchar(255)
    , @cell_number_value money = NULL
    , @section int = NULL
    , @item_id int = NULL
    , @company_id int = NULL
    , @year int = NULL

The procedure gets the edited cell column name and value, and values from table columns and procedure parameters.

You may use DBEdit on any supported database platforms in the same manner:

  • Microsoft SQL Server
  • Oracle Database
  • IBM DB2
  • MySQL and MariaDB
  • PostgreSQL
  • NuoDB
  • Snowflake
  • SQL Server Compact
  • SQLite

You may try to connect to your database and edit data easily.

To learn DBEdit features, try its samples. You will find code templates for typical tasks.

See also:

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.