How Do I Open a Data Source Using a Physical Name that is Different than the one Specified on the Data Repository? (Magic xpa 4.x)
Usually, the data source names are set in the Data repository. This makes maintenance easier; you can find the data source names easily and change them in one central place.
However, there will be times when you want to change the data source name at the task level. For instance, you might want to use the same table description to define separate tables for different users, or create archival copies of data named by date/month.
In this example, we have a subtask that creates a copy of the Order Header record. It opens the same item in the Data repository, but uses the Data source name property to override the name. The data will be added or modified in a file named after the year and month (‘0712’ for Dec. 2007, for instance), in the directory represented by the logical name %WorkingDir%.
Note: You cannot name the same data source two different names in the same task. In this example, we create the archived record in the subtask, because the parent task opens the same data source object under the default name.
How Do I Access an Existing Database Table?
The Online and Rich Client Samples projects (program TS04 and RTS04)
