Online Help

GetColumnCount returns the number of columns in result.

$\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}≔c:-\mathrm{ExecuteQuery}\left(''SELECT\; id\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetColumnCount}\left(\right)$

$1$

$\mathrm{res}≔c:-\mathrm{ExecuteQuery}\left(''SELECT\; id,mass\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetColumnCount}\left(\right)$

$2$

$\mathrm{res}≔c:-\mathrm{ExecuteQuery}\left(''SELECT\; id,mass,name\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetColumnCount}\left(\right)$

$3$

$\mathrm{res}≔c:-\mathrm{ExecuteQuery}\left(''SELECT\; id,mass,name,number\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetColumnCount}\left(\right)$

$4$