You must be logged in and have permission to create or edit a blog.
Author: Created: 4/29/2010 10:05 AM RssIcon
This blog is written by Robert Houben, CTO of FusionWare Integration Corp. Robert has more than 20 years experience in software design and architecture specializing in data and software integration. He is the past founder of Liberty Integration Software, a premier provider of MultiValue integration solutions. Robert was the CTO at FusionWare Corp and was the primary architect behind the FusionWare Integration line of products. Robert was the development manager for the PK Harmony and PC Harmony products at Synex Systems.
By Robert Houben, CTO on 8/11/2010 12:28 PM

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.

By Robert Houben, CTO on 8/10/2010 2:41 PM
This document describes how you can rapidly create a DataSet of your MultiValued data without having to map your data.  Starting with a TCL LIST/SORT command that produces the output that you want to retrieve, we show you how to go from that to a fully functional ADO.NET command that retrieves this data for you.  Note that although we focus on ADO.NET, the same command can be called from COM/COM+ using the FusionWare Direct OLE DB Driver, or from Java using the FusionWare Java Data Adapter.
By Robert Houben, CTO on 8/10/2010 2:29 PM
This article provides examples and explains in depth, how Microsoft's DbDataAdapter Fill method converts nested IDataReader objects representing MultiValued data into a series of DataTable and DataRelation objects in a DataSet.
By Robert Houben, CTO on 5/13/2010 12:56 PM
We developed our first web middleware solution in 1994, and released it to our first customer in 1995.  In this blog entry we review of the standards and industry best practices that shaped the FusionWare Direct products and solutions for the Web.
By Robert Houben, CTO on 5/12/2010 11:46 AM
Connecting to a MultiValue (PICK) database using FusionWare Direct ADO.NET provider from a WPF application using Visual Studio 2010.  Example code using the sample CUST file in the FusionWare Direct Data Access Server (Direct DAS) account. This is part two where we customize the Data Access Layer further to allow selective retrieval of data.
By Robert Houben, CTO on 5/12/2010 9:33 AM
FusionWare Integration Corp. has added SQL Azure support to their popular mv2SQL product in a new offering they call mv2Cloud.  Here we discuss what this means for the MultiValue community.
By Robert Houben, CTO on 4/23/2010 10:21 AM

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.

By Robert Houben, CTO on 4/21/2010 10:54 AM

I've just discovered another use for Twitter.

By Robert Houben, CTO on 4/20/2010 10:58 AM
Many customers with green-screen applications struggle with integrating these systems with a web store.  The challenges are daunting and in some cases have caused customers to shelve these initiatives.  In this series of articles, we will look at the steps and decisions required in order to build out this kind of solution without breaking the budget, and within a reasonable timeframe.
By Robert Houben, CTO on 4/15/2010 10:38 AM
FusionWare's mvLynx Connect API makes it extremely easy for your MV/BASIC programmers to access data from SQL Server, Oracle, DB2, DB2/400, MySQL or other relational databases without having to have any expertise with connectivity tools.

In this article, we explain how it all works and give some simple examples.

This product has been in use for several years and handles large volumes of data for customers.
Privacy Statement | Terms Of Use | Copyright 2017 by Fusionware Integration Corp.