SQLColumnDef

Description

Provides information about a single column. See also AppDB.ReadDynaSQL.

Inheritance

SQLColumnDef does not inherit from any object type.

Constructors

• SQLColumnDef() – Creates a SQLColumnDef object.
• SQLColumnDef( DBTypeConstants dbType, string name ) – Creates a SQLColumnDef object and populates members.
• SQLColumnDef( DBTypeConstants dbType, string name, SQLColumnDefOutputHint hint ) – Creates a SQLColumnDef object and populates members.

Properties

Example

var out = []; // creates an empty Vector

Shell.Db().ReadDynaSQL(
  "select TS_ID,TS_NAME,TS_LASTLOGINDATE from TS_USERS where TS_STATUS=? order by TS_NAME",
  [
    SQLColumnDef(DBTypeConstants.INTEGER,"TS_ID"),
    SQLColumnDef(DBTypeConstants.VARCHAR,"TS_NAME"),
    SQLColumnDef(DBTypeConstants.BIGINT,"TS_LASTLOGINDATE", SQLColumnDefOutputHint.TimeT)
  ], out, [Pair( DBTypeConstants.INTEGER, 0)] );

for ( row : out ){
  Ext.WriteStream( "${row[0]}\t${row[1]}\t${row[2].date}" );
}