Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - AppForge Programming » Understanding UltraLite Development with AppForge » Working with data using dynamic SQL

Navigation with dynamic SQL Next Page

ULResultSet schema property

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


The following example shows how you can use ULResultSet.Schema to display schema information in a MobileVB grid. The example assumes you have a ULResultSet named MyResultSet and a MobileVB grid named grdSchema.

'MobileVB using VB6
Dim i As Integer
For i = 1 To MyResultSet.Schema.ColumnCount
  grdSchema.AddItem (MyResultSet.Schema.ColumnName(i) _
  & Chr(9) & CStr(MyResultSet.Schema.ColumnSQLType(i))), 0
Next i
grdSchema.AddItem _
  ("Column Name" & Chr(9) & "Column Type"), 0