Call the following DB-Library for Visual Basic functions to retrieve information on regular result columns after SqlExec% or SqlOk% returns SUCCEED.
| Function | Description |
|---|---|
| SqlColLen% | Returns the maximum length of the data, in bytes, converted to a string in a regular column. |
| SqlColName$ | Returns the name of a regular result column. |
| SqlColType% | Returns the SQL Server datatype for a regular result column. |
| SqlDatLen& | Returns the actual length, in bytes, converted to a string of the data in a regular column. This function is often used in conjunction with SqlData$. The value returned by SqlDatLen& can be different for each row that SqlNextRow% reads. |
| SqlNumCols% | Returns the number of columns in the current set of results. |
| SqlPrType$ | Converts a SQL Server token value to a string. |