DBGate Change History

Version 1.6, August 21, 2020

New features:

• DBGate allows using fields of tables and views as WHERE filters.
  To create a field parameter, check the field in the field setup dialog box.
• DBGate supports the DoNotChange handler at the object and column levels.
  You can use it to make columns read-only.
• DBGate allows using the calendar dialog box for date parameters.
• DBGate allows stopping the application using the /api/$stop request.
  You can use this feature when embedding DBGate to single-user applications or for development purposes.
  To enable it, set the StopEnabled option in the application settings to true.

Bug fixes:

• DBGate raises "Object reference not set to an instance of an object" on executing MySQL procedures.

Version 1.5, August 5, 2020

Bug fixes:

• DBGate raises "Object reference not set to an instance of an object" on executing MySQL procedures.

Version 1.4, July 31, 2020

Bug fixes:

• A browser cannot open a page on IIS and shows the ERR_SSL_PROTOCOL_ERROR error.

Version 1.3, July 27, 2020

Improvements:

• DBGate allows testing samples in a free version.

Version 1.2, July 24, 2020

Improvements:

• Improved CSS and JavaScript files
• Improved pages of samples

Bug fixes:

• DBGate resets the selection on the right mouse button click and breaks the range copy/paste feature.
• DBGate does not rollback cell changes when the server returns an error.
• DBGate does not send the application/json ContentType header in several cases.
• DBGate ignores the document base URL in API roots.

Version 1.1, July 22, 2020

New features:

• DBGate supports copy/paste and cell range operations.
• DBGate supports dynamic parameter values and drop-down value lists.
  For example, if a procedure has a parameter like @company_id, DBGate executes it to reload values when a user changes the company.
• DBGate supports filtered drop-down value values.
  For example, if a value list has three columns like id, name, and item_id, DBGate filters values using the cell value in the item_id column.
• DBGate supports JSON forms that return parameter values, column and row headers, and table cells in one JSON result.
  See the new "Sample 20 - Cube App" for details.
• DBGate supports the /$definition operation to returns the object SQL definition.
  It returns the definition only if a user has the VIEW DEFINITION permission in a database.
  You can find a code browser sample in the DBGate samples.
• The connection string section allows defining a default query list in the "QueryList" parameter.
  Use this feature to configure the entity container and keep the service root clear.
• The connection string section allows defining hidden schemas in the "HiddenSchemas" parameter.
• The DefaultValue handler allows setting default values of parameters in the HANDLER_CODE field.
• The DoNotSort handler allows disabling the translation for the specified column or the entire table.
• The DoNotTranslate handler allows disabling the translation for the specified column or the entire table.
• The following handlers allow specifying data types of columns and parameters on unknown types:
  DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
  DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, and DataTypeTime.
  Use these handlers, for example, to specify data types of SQL code parameters or stored procedure columns.
• DBGate supports database schemas in the endpoints.
  For example, /edit/mssql/xls27/ returns the objects of the xls27 schema with database names
  while /edit/mssql/xls27/en-GB/ returns the objects with translated names and the en-GB culture.

Improvements:

• DBGate includes a new set of pages with complete descriptions of DBGate samples.
• DBGate JavaScript client includes a lot of improvements.
  It has the same look in Chrome, Firefox, Opera, Safari, IE, and Edge.
  It has new classes and element ids to style DBGate elements.
• DBGate keeps parameter values with the same name but changed ids.
  For example, the Budget item can have different ids for different companies.
  When a user changes the company_id, DBGate keeps the Budget item as a parameter.

Bug fixes:

• DBGate allows saving changes for objects that have the merge operations only (not supported in DBGate).
• DBGate does not translate checkbox parameter names.

Version 1.0, May 15, 2020