ProductsTechnical SupportDownloadsPurchasingSearch EngineNewsHomeE-mail Us

ACE/400 Data Control can be used with many applications such as:

What are the benefits of Data Control?

The main advantage of Data Control is to fit a standard way of database programming. This standard has been established by Microsoft with the Microsoft DAO. The DAO is based on the latest portability norm that is OLE. In fact, Data Control is an OLE control. A data control (if OLE and DAO compliant) has two integrated parts:

With ACE/400 Data control, these two parts are combined on a single OCX file named EACDAO.OCX. The Ace/400 Data Control system has been designed to be:

The major benefit of using Data Control is its similar interface with VB, Excel, Access, Powerbuilder and others.

ACE/400 Data Control Features

ACE/400 Data Control key features are:

ACE/400 Data Control has very similar methods and properties as the regular VB Data control (the object named ‘Data’).


ACE/400 Data Control OLE Type Library Details

As explained above, ACE/400 Data Controls have an OLE Type Library section. This Type Library is very similar to the Microsoft DAO Type library. It is composed of different objects:

The Data control is represented by the name ACE400Data. All of these objects and methods can be easily browsed using the object browser in VB. A small help text is available with each property or method.

1. "ACE400" object

This object contains default properties or methods for the OLE type library. Available methods and properties:

Opendatabase: opens a Database

This method takes the parameters (all optional):

If multiple ‘opendatabase’s are made on different machines, this will automatically generate multiple sessions.


2. "Databases": property representing all connections.


3. "Database" object

This object represents a connection to the AS/400. So, all operations that belong to a connection are available through this object:

Please note that only files opened with Commit mode will be affected with transaction methods. Of course these files must also be journalized.


4. "Recordset" object

This is the richest object because it contains all operations available on the file. It can be obtained in two ways:

Useful properties:

Useful methods:


5. "Fields" object

This object allows you to get the set of fields available for a recordset. It can be used in two ways:

  1. Walking in a set:

  2. In VB, this can be done like this:
    For each Field in recset.Fields
    Debug.print Field
    Next Field

  3. Walking using Item property:
  4. For i = 0 to recset.Fields.count
    The following data access programming ways are equivalent:
    Debug.Print recset(i)
    Debug.Print recset.Fields(i)
    Debug.Print recset.Fields(i).Value
    Next i


6. "Field" object

This object allows you to get or set values for a field. Getting and setting value is done by a simple affectation. In fact, the property value is the default property for the object. Other properties include: