How Do I Set a Dynamic Name for a Data Source? (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 easily 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 to 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 %Archive%.
Note: You cannot give the same data source two different names in the same task. In this example, we created the archived record in the subtask, because the parent task opens the same data source object under the default name.
How Do I Create a Database Table Using Magic xpa?
The Online and Rich Client Samples projects (program EN05 and REN05)
