dbmorecmds

Indicates whether there are more commands to be processed.

Syntax

RETCODE dbmorecmds ( PDBPROCESS dbproc );

where

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

Returns

SUCCEED to indicate more results in the command batch; otherwise, FAIL.

Remarks

It should be called after dbnextrow returns NO_MORE_ROWS. If you know that the current command is returning no rows, you can call dbmorecmds after dbresults returns SUCCEED.

You can get the same information by calling dbresults until it returns NO_MORE_RESULTS.

See Also

dbcmdrow, dbnextrow, dbresults, dbrows, dbrowtype