dbsqlsend

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

Syntax

RETCODE dbsqlsend ( PDBPROCESS dbproc );

Arguments

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 Transact-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.

After 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 Microsoft Windows® operating system.

See Also