Returns the designated column’s SQL type.
PSCursorClass objects
cursorobject.GetColumnType ( int iCol )
Argument |
Description |
|---|---|
cursorobject |
A variable that contains a reference to an instance of PSCursorClass |
iCol |
Number of the column for which you want to obtain the SQL type |
Integer
Returns a static member variable in java.sql.Types. For a list of SQL types, see the Sun Microsystems Web site.
Use this method in conjunction with GetColumn<DataType> methods to obtain values in a cursor. You cannot use GetValue to obtain column values in a cursor.
The following example retrieves the type of the fifth column in the mycursor object:
column_type = mycursor.GetColumnType(5);
