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 - M-Business Anywhere Programming » Understanding UltraLite for M-Business Anywhere Development » Working with data using SQL

Navigation with SQL Next Page

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