Call the following DB-Library for Visual Basic functions to retrieve information on compute result columns after SqlNextRow% or SqlGetRow% returns a compute ID.
| Function | Description |
|---|---|
| SqlADLen& | Returns the actual length of the data in a compute column in the form of a string. This function is often used in conjunction with SqlAData$. The value returned by SqlADLen& can be different for each compute row that SqlNextRow% reads. |
| SqlAltColId% | Returns the identification number in a compute column. |
| SqlAltLen% | Returns the maximum length of the data, in bytes. The length is converted to a string in a compute column. |
| SqlAltOp% | Returns the type of aggregate function of a compute column. |
| SqlAltType% | Returns the datatype of a compute column. |
| SqlByList$ | Returns the bylist of a compute row. |
| SqlNumAlts% | Returns the number of columns in a compute row. |
| SqlNumCompute% | Returns the number of COMPUTE clauses in the current set of results. |