dbsqlsend

Sends a command batch to SQL Server and does not wait for a response.

Syntax

RETCODE dbsqlsend ( 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 or FAIL.

Remarks

This function sends SQL statements, stored in the command buffer of the DBPROCESS, to SQL Server. Statements can be added to the command buffer by calling dbcmd or dbfcmd.

Once dbsqlsend returns SUCCEED, dbsqlok must be called to verify the accuracy of the command batch. Then dbresults can be called to process the results.

This function is particularly useful for multitasking with the Windows operating system.

See Also

dbcmd, dbfcmd, dbnextrow, dbresults, dbsettime, dbsqlexec, dbsqlok; Building Applications