Saving Data to Tables

Saving Data to Tables

Tables with primary key or identity columns are editable by default.

To save data loaded from other objects to a table, specify the target table using INSERT, UPDATE, and DELETE objects.

Here’s a sample for the xls.objects table:

IDTABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_OBJECTUPDATE_OBJECTDELETE_OBJECT
 s02view_cashbookVIEWs02.cashbooks02.cashbooks02.cashbook
 s02usp_cashbookPROCEDUREs02.cashbooks02.cashbooks02.cashbook
 s02code_cashbookCODE<SQL>s02.cashbooks02.cashbooks02.cashbook

Here’s a sample for the QueryList view:

IDTABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_PROCEDUREUPDATE_PROCEDUREDELETE_PROCEDUREPROCEDURE_TYPE
 s02view_cashbookVIEWs02.cashbooks02.cashbooks02.cashbook
 s02usp_cashbookPROCEDUREs02.cashbooks02.cashbooks02.cashbook
 s02code_cashbookCODE<SQL>s02.cashbooks02.cashbooks02.cashbook

Tools like SaveToDB 8+, DBEdit, DBGate, and ODataDB automatically create these configurations when they can detect the target table.

For instance, if a user has the VIEW DEFINITION permission and a view or stored procedure contains code like SELECT * FROM s02.cashbook, the tools will handle the necessary configurations.

Remember, target tables must have primary key or identity columns.

Implementation Details

SaveToDB and DBEdit generate and execute INSERT, UPDATE, and DELETE commands automatically.

DBGate issues INSERT, UPDATE, and DELETE commands on the server-side based on POST, PUT, and DELETE requests.

ODataDB creates EntitySets for tables and views, along with FunctionImports that target the EntitySet for stored procedures and SQL code.

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.