In this document we will create a macro-enabled workbook and use a pre-built macro to import MultiValued data into a series of worksheets in the workbook.
The data will come from the sample CUST file in the GAXOLEDB account that is created when the FusionWare Direct Data Access Server (Direct DAS) is installed on your MultiValue system.
You will need to modify the connection string to reflect your system, and you can freely modify the COMMANDTEXT property and other code to process different tables.
We will use the FusionWare Direct OLE DB Provider to access this data.
I've been working with a user on replacing their current web store with one that actually integrates with their System i POS system. Their old one printed an order form off, and they had to pick up the printer output, manually check inventory, grab it, complete the order, then notify the customer. If anything went wrong, they had to notify the customer. It was all asynchronous, which is not what most customers expect from a web transaction.
I've just discovered another use for Twitter.