Schema description creation and retrieval

The GetResultSetSchema method allows you to retrieve schema information about a result set, such as column names, total number of columns, column scales, column sizes, and column SQL types.

Example

The following example demonstrates how to use the GetResultSetSchema method to display schema information in a command prompt:

const char * name;
int column_count;
const ULResultSetSchema & rss = prepStmt->GetResultSetSchema();
int column_count = rss.GetColumnCount();
for( int i = 1; i < column_count; i++ ) {
    name = rss.GetColumnName( i );
    printf( "id = %d, name = %s\n", i, name );
}

In this example, required variables are declared and the ULResultSetSchema object is assigned. It is possible to get a ULResultSetSchema object from the result set object itself, but this example demonstrates how the schema is available after the statement is prepared and before the query is executed. The number of rows in the result set are counted, and the name of each column is displayed.

Schema description creation and retrieval

Example

See also