The ResultSetSchema object

The ResultSet.schema property allows you to retrieve information about the columns in the query.

The following example demonstrates how to use ResultSetSchema to capture schema information.

var I;
var MySchema = rs.schema ;
for ( I = 1; I <= MySchema.columnCount; I++) {
  colname = MySchema.getColumnName(I);
  coltype = MySchema.getColumnSQLType(colname).toString();
  alert ( colname + " " + coltype );
}
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1