Try OpenEdge Now
skip to main content
.NET Open Clients
Using the Open Client .NET OpenAPI to Directly Access the AppServer : Setting up parameters and return types : Defining the schema for a temp-table parameter
 

Defining the schema for a temp-table parameter

Defining the schema for an ABL temp-table (TABLE or TABLE-HANDLE) parameter is a multi-step process.
To define the schema for a temp-table parameter:
1. If the parameter is for input or input-output, define an ADO.NET DataTable to hold the parameter value.
2. Define a TempTableMetaData object to hold the parameter schema.
3. Add field descriptions to the TempTableMetaData object.
4. Add the TempTableMetaData object and the DataTable (if applicable) as a temp-table parameter to your ParamArray object using the appropriate set parameter method.
* Defining a TempTableMetaData object
* Adding field descriptions to the TempTableMetaData object
* Adding the TempTableMetaData with its DataTable as a temp-table parameter