Tuesday, March 18, 2014

Types of DataSources

Types of DataSources in AOT:

A form data source supplies the data that appears on a form. 
To display data, you assign a data field from the form data source to a property of a control that appears on the form.

1. Table: 

A table is a business object in the Data Dictionary node of the AOT. A table is an object that contains data records for the system. In additionally, a table can define a table relation that enables you to look up data from a referenced table.

2. View:
A view is a business object in the Data Dictionary node of the AOT. A view is a stored query that retrieves a specified collection of data records and fields. The data in a view is retrieved when the view is accessed. 

How to use in form level:

AOT>DataDictionary>View>DirPartyView

AOT>Form>DirPartyTable



3. Query:


A query is a business object in the Queries node of the AOT. A query uses tables, maps, or views to retrieve a set of data fields. To use a query as a form data source, you use the Query property of the Data Sources node to specify the query for the form.
You might find that a query has set the Dynamic property of the Fields node to No. You set Dynamic to No when you want to specify the list of fields that appear in the query. When you add that query to the Data Sources of a form, the list of fields in the table node include all the fields for the table.

No comments:

Post a Comment

update_recordset with joins

 update_recordset with joins update_recordSet storeTransfer         setting      TransactionId = transfertable.TransferId     join transfert...