Data Tables Pane (Schema Modeler)
This is a Data Abstract Schema Modeler topic
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 doesn't necessarily have to 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. Or 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.
The created SQL commands will be identical to those that are auto-generated by the Business Processor, 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
Available Editions: Data Abstract for .NET, Xcode, Delphi, Java and JavaScript
