Contents Index Moving through a result set Accessing and manipulating data using the table API

UltraLite ActiveX User's Guide
  Understanding UltraLite ActiveX Development
    Accessing and manipulating data using Dynamic SQL

ULResultSet schema property


The ULResultSet.Schema property allows you to retrieve information about the columns in the query. The properties of this ULResultSetSchema object include ColumnName, ColumnCount, ColumnPrecision, ColumnScale, ColumnSize, and ColumnSQLType.

The following example demonstrates how to use ULResultSet.Schema to capture schema information.

' eMbedded Visual Basic
Dim i As Integer
Dim MySchema as ULResultSetSchema
Set MySchema = MyResultSet.Schema
For i = 1 To MySchema.ColumnCount
  cn = MySchema.ColumnName(i)
  ct = MySchema.ColumnSQLType(i)
  MsgBox cn, ct
Next i
// JScript
var i;
var MySchema;
For ( i = 1; i <= MySchema.ColumnCount; i++) {
  cn = MySchema.ColumnName(i);
  ct = MySchema.ColumnSQLType(i);
  alert ( cn + " " + ct );
}

Contents Index Moving through a result set Accessing and manipulating data using the table API