SqlRowType%

Indicates whether the current result row is a regular row or a COMPUTE row.

Syntax

SqlRowType% ( sqlconn% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

Returns

One of four values depending on certain conditions:

• If the current row is a regular row, REGROW (-1) is returned.
• If the current row is a compute row, the ID of the COMPUTE clause is returned.
• If SqlRowType% was unsuccessful, FAIL (0) is returned.
• If no rows have been read, NOMOREROWS (-2) is returned.

Remarks

Because SqlNextRow% returns the row type, you can usually determine the type of the current row without using SqlRowType%.

See Also

SqlNextRow%