SQLColumnDefOutputHint

Description

Global const object for SQL column definitions, used in SQLColumnDef.

• SQLColumnDefOutputHint.None – Output will be default for the column type.
• SQLColumnDefOutputHint.TimeT – Used to inform SBM ModScript that the output for this column should be a TimeT object.
• SQLColumnDefOutputHint.VariantDate – Used to inform SBM ModScript that the output for this column should be a Variant storing a Date.

Technical Details

SBM ModScript version: 11.4.

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