Configuring OData Model

Configuring OData Model

ODataDB allows configuring application features with the SaveToDB Framework.

In short, SaveToDB Framework is a set of special tables used to configure features.

You may easily install it on any supported database platform.

Two of our products, DBEdit and SaveToDB add-in for Microsoft Excel, also use this framework.

So, you may configure features once and use Microsoft Excel, a desktop DBEdit app, or an ODataDB JavaScript client to view and edit data.

ODataDB supports a subset of application features available in SaveToDB and DBEdit.

For now, it supports only the following configuration tables: xls.objects, xls.handlers, and xls.translations.

xls.objects

Use the xls.objects table to specify target tables or stored procedures used to save changes using the Save button.

See an xls.objects sample and the generated model.

You may add stored procedures into this table to change its type from ActionImport to FunctionImport if ODataDB detects the type incorrectly.

Also, you may add SQL-code objects here. For example, you may see the s02.code_cashbook object. You may try it.

See also:

xls.handlers

Use the xls.handlers table to configure:

See an xls.handlers sample and the generated model.

You may see more handler types than supported, as this is a sample for the SaveToDB add-in.

See also:

xls.translations

Use the xls.translations table to translate names of objects, columns, and parameters.

See an xls.translations sample and check the ODataDB.DisplayName annotations in the generated models in English, French, Spanish, Italian.

You may try the same procedure in different languages and locales (change and save data on one page, and reload data in another one):

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.OK