SqlCmdRow%

Indicates whether the current statement can return rows.

Syntax

SqlCmdRow% ( sqlconn% )

where

sqlconn%

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

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlCmdRow% determines whether the current command can return rows. The following types of statements can return rows:

• A Transact-SQL SELECT statement
• A Transact-SQL EXECUTE statement that is executing a stored procedure containing a SELECT statement

Call SqlCmdRow% after SqlResults% returns SUCCEED. Even if SqlCmdRow% returns SUCCEED, the statement will not return rows if none have qualified. To determine whether any rows are returned, use SqlRows%.

Even if SqlCmdRow% returns FAIL, you must still process the results by calling SqlNextRow% until it returns NOMOREROWS.

See Also

SqlNextRow%, SqlResults%, SqlRows%, SqlRowType%