SqlMoreCmds%

Indicates whether there are more statements in the command buffer to be processed.

Syntax

SqlMoreCmds% ( sqlconn% )

where

sqlconn%

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

Returns

SUCCEED (1) or FAIL (0). SUCCEED indicates there are more results in the command buffer to be processed.

Remarks

You can call SqlMoreCmds% after SqlNextRow% returns NOMOREROWS. If you know that the current statement is returning no rows, you can call SqlMoreCmds% after SqlResults% returns SUCCEED.

You can get the same information by calling SqlResults% until it returns NOMORERESULTS.

See Also

SqlCmdRow%, SqlResults%, SqlRows%, SqlRowType%