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

SQL Anywhere 12.0.1 » UltraLite - M-Business Anywhere Programming (deprecated) » UltraLite development for M-Business Anywhere » Data creation and modification using SQL statements

 

ResultSetSchema objects

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 );
}