Data Tables Pane
From RemObjects Software
This is a Data Abstract Tool topic
Feel free to add your notes to this topic below.
The Data Tables Pane lists all Data tables that are defined in your Schema.
A data table represents a rowset of data that will be retrieved and worked with by your Data Abstract application. A data table mustn't necessarily be backed by a physical table in your database, the data can come from either a table, a view or a custom query that might for example join multiple tables or calculate live data.
There are two ways to create a new data table for your schema:
Press the "New Data Table" button in the pane's toolbar, and then fill in the details for your table by hand Drag a table from Data Explorer to the Data Tables pane and select "Create New Data Table":
The Schema Modeler will automatically create a new data table for you, and set it up accordingly (it will create persistent field definitions for all fields, as well as provide a default SQL query to select the data).
You can then use the Data Table Details view to make manual adjustments to the new dataset, if needed.
The Create New Data Table and Delta-Commands option in the screenshot will create additional Commands for you in the Commands Pane, to be used for INSERTING, UPDATING and DELETING data.
These created SQL commands will be identical to those that are auto-generated by BusinessProcessor, so in general you will not need to create them. But if you are planning to use custom queries for updating data, these commands provide a good starting point.
See Also
Product: RemObjects Data Abstract
Current version: Data Abstract 'Vinci' (5.0)
Lists — Glossary — Features — How To — Drivers — Components — Tools — Samples — Articles — Architecture — Issues
Categories: Text | Data Abstract | Tool | .NET
