Release 10.1A: OpenEdge Development:
.NET Open Clients

> ## Temp-table array fields

> In the 4GL, fields in a temp-table can be defined with an extent option to create a one-dimensional array of the specified data type, with the number of elements specified by the extent. In .NET, an array field in a Progress temp-table is flattened, such that each array element becomes a separate column of the DataTable.

> For static temp-table parameters, the strongly typed class generated by ProxyGen automatically flattens array fields in the table into the required number of columns. The meta data for the table knows which columns are part of the array and maps the data between the flattened model in .NET and the array model in Progress.

> For dynamic temp-table parameters, the parameter is mapped to a .NET `System.Data.DataTable` class. For `OUTPUT` parameters, this DataTable is created with any array fields flattened, such that each array element becomes a separate column of the DataTable. For `INPUT` and `INPUT-OUTPUT` parameters, the client must create an instance of a .NET `System.Data.DataTable` to provide the schema and data. For temp-tables with array fields, the client must provide Progress-specific mappings for the DataTable. For more information, see the "Passing a TABLE or TABLE-HANDLE as an INPUT parameter" section and the "Providing Progress extensions for INPUT TABLE-HANDLE parameters" section.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095