|
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