Contents Index Moving through a result set Accessing and manipulating data with the Table API

UltraLite C++ User's Guide
  Understanding UltraLite Development
    Accessing and manipulating data with dynamic SQL

Result set schema description


The ResultSet.GetSchema method allows you to retrieve information about a result set, such as column names, total number of columns, column precisions, column scales, column sizes and column SQL types. The following example shows how you can use ResultSet.GetSchema to display schema information in a console window.

ResultSetSchema * rss = rs->GetSchema();
ULValue val;
char name[ MAX_NAME_LEN ];
for( int i = 1;
     i <= rss->GetColumnCount();
     i++ ){
   val = rss->GetColumnName( i );
   val.GetString( name, MAX_NAME_LEN );
   printf( "id= %d, name= %s \n", i, name );
}

Contents Index Moving through a result set Accessing and manipulating data with the Table API