Data Source Repository (Magic xpa 3.x)
You can access the Data Source repository by selecting Data Sources from the Task menu or pressing Ctrl+D.
The Data Source repository lists all of the data sources used in the program, including the Main Source, the data sources used by Link operations, and the data sources assigned to choice controls. The entries in this list cannot be deleted. You can only edit their properties.
The Data Source repository includes the following columns:
|
|
|
|
#
|
This read-only column contains an automatically generated sequential number.
|
|
Data Source
|
This read-only column contains the data source index.
|
|
Description
|
This read-only column contains the data source name.
If the data source appears only once as a Main Source, Link or Declare, then its name from that entry (in the task) will be shown.
If the data source appears more than once as a Main Source, Link or Declare, then its name from the Data repository (Shift+F2) will be shown.
|
|
Access
|
The Access property is relevant in a multi-user environment and determines how the table is to be accessed.
Use Read for Read Only access, or Write for Read and Write access.
This property has no effect and will not be parkable for a data source that is only used in a Control data source.
|
|
Share
|
The Share property is relevant in a multi-user environment and determines how other concurrent tasks can access the table.
Use Read to allow other tasks Read Only access.
Use Write to allow other tasks Read and Write access (effectively row locking).
Use None for no shared access (Table locking).
The combination of Access and Share will be used by Magic xpa to determine the Open Mode of the table automatically. Thus, Write Access with Share Write implies Record Locking, Read and Write Access with Share Read implies Table Sharing. Share None implies exclusive use of the table.
This property has no effect and will not be parkable for a data source that is only used in a Control data source.
|
|
Open
|
The Open mode property determines how the data source is opened. The valid values are:
Normal – The Open mode for a valid data source for all normal purposes.
Reindex – The Reindex Open mode instructs Magic xpa to drop all the indexes of the data source when opening it, perform processing, and rebuild the indexes upon session termination. The Reindex Open mode depends on support by the underlying database gateway.
If the data source is used only in the Control data source, the value will be ‘Normal’ and the field will not be parkable.
This property has no effect and will not be parkable for a data source that is only used in a Control data source or XML data source.
|
|
Name
|
The actual physical name of the data source.
|
|
XML Var
|
The XML source variable.
|
|
Cache
|
This property specifies whether the linked table is cached. This property is relevant for linked data sources only.
The default value will be according to the cache strategy on the table. After the first definition in the task, there is no inheritance from the data source properties.
The possible values are:
|
|
Identify Modified Row
|
This column determines how Magic xpa selects records that have been modified by another user, before updating your database.
Magic xpa can identify and select records according to the following options:
This column applies only for Deferred Transaction mode tasks and SQL tables.
This property has no effect and will not be parkable for a data source that is only used in a Control data source or XML data source.
|
