wxJavaScript

wxDbColInf

Used with the getColumns for obtaining all retrievable information about a column's definition.

wxDbColInf contains information of all columns of one or more tables. That's why you need to use an index before retrieving the properties of a column.

   
   var cols = db.getColumns("user_table");
   if (    cols != null
        && cols.count > 0 )
   {
      // [0] is necessary to retrieve the name of the first column!!!
      var colname = cols[0].colName; 
   }
   
  

Constants

Properties

Name	Type	Description
bufferLength	Integer
catalog	String
colName	String
columnLength	Integer
dbDataType	Integer
decimalDigits	Integer
fkCol	Integer
fkTableName	String
nullable	Integer
numPrecRadix	Integer
pkCol	Integer
pkTableName	String
remarks	String
schema	String
sqlDataType	Integer
tableName	String
typeName	String