Basic features of the JavaScript client
DBGate can be used as a database data editor without any configuration.
Basic client features include:
- Getting data from tables, views, and procedures
- Saving data changes to tables and views
- Changing procedure parameters
- Replacing IDs with names from primary key tables
- Copying and pasting ranges
- Undo and redo actions
- Sorting rows by multiple columns
- Hiding and displaying columns
- Aligning columns
- Formatting numeric values
- Calendar for entering dates
- Multilingual interface
- Embedding in corporate web pages
In general, we have tried to provide the required minimum of Microsoft Excel functionality for working with data.
The screenshot shows getting data from a stored procedure that can be saved to a source data table.
DBGate also identified primary key tables of the accounts, items, and companies, and generated value lists for parameters and cells.
To get such an editor, just add the database connection string.
