GetType returns the SQL type of the column indicated by index.

If index is an integer, it is used to index into the current Result module's table.  If index is a string, it is the name of the column.

The type returned by GetType can be used in an explicit cast to make Maple perform a particular type conversion.  For more information, see conversions.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{res}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; name\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetType}\left(1\right)$

$\mathrm{INTEGER}$

$\mathrm{res}:-\mathrm{GetType}\left(2\right)$

$\mathrm{VARCHAR}$

$\mathrm{res}:-\mathrm{GetType}\left(3\right)$

$\mathrm{INTEGER}$

$\mathrm{res}:-\mathrm{GetType}\left(4\right)$

$\mathrm{DOUBLE}$

$\mathrm{res}:-\mathrm{GetType}\left(''id''\right)$

$\mathrm{INTEGER}$

$\mathrm{res}:-\mathrm{GetType}\left(''name''\right)$

$\mathrm{VARCHAR}$

$\mathrm{res}:-\mathrm{GetType}\left(''number''\right)$

$\mathrm{INTEGER}$

$\mathrm{res}:-\mathrm{GetType}\left(''mass''\right)$

$\mathrm{DOUBLE}$