Rockwell Automation Arena Users Guide - Manual (Page 64)

A RENA U SER ’ S G UIDE
56
• •
•
•
•
Microsoft Excel, Microsoft Access, and ActiveX Data Objects Access Types.
When an entity arrives at the ReadWrite module, the specified file is examined to see if an
ADO connection to the file is open (active). If the file is currently closed, then an ADO
connection is automatically opened to the data source using either the Microsoft Jet OLE
DB Provider (if the Access Type is Microsoft Excel or Microsoft Access) or the specified
connection string (if the Access Type is ActiveX Data Objects).
The Recordset ID is then examined to see if that recordset in the file is open. A recordset
refers to a table of data in the data store that is organized in columns (i.e., fields) and rows
(i.e., records).
If the recordset is currently closed, then it is automatically opened using the recordset
definition specified in the File module (e.g., the specified named range or table name).
The recordset then remains open until the file is closed.
The values of the attributes, variables, or expressions (other) listed in the Assignments
repeat group are then read from or written to the specified Record Number (i.e., row) in
the recordset. The first entry in Assignments is read from or written to the first field in the
record, the second entry corresponds to the second field, and so on.
Extensible Markup Language Access Type. When an entity arrives at the Read-
Write module, the specified file is examined to see if it is open (active). If not, the file is
automatically opened into a single ADO recordset.
The values of the attributes, variables, or expressions (other) listed are then read from or
written to the specified Record Number (i.e., row) in the recordset.
T YPICAL USES
„
Reading in airline arrival/departure information
„
Prompting an end user for model configuration data (menu)
„
Writing order information to a data file, such as order arrival, order fill time, order
completion time
P ROMPTS
Prompt Description
Name Unique module identifier displayed on the module shape.
Type Method of reading or writing used. Data may be read from a file or from
the keyboard. Data may be written to a file or to the screen.
Arena File Name Name used to identify the file within the File module. Applies only
when reading from or writing to a file.