dbmoretext

Sends part of a text or image value to Microsoft® SQL Server™.

Syntax

RETCODE dbmoretext (
PDBPROCESS dbproc,
DBINT size,
LPCBYTE text );

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.

size

Is the size, in bytes, of the particular part of the text or image value being sent to SQL Server. It is an error to send more text or image bytes to SQL Server than were specified in the call to dbwritetext or dbupdatetext.

text

Is a pointer to the text or image portion to be written.

Returns

SUCCEED or FAIL.

Remarks

This function is used in conjunction with dbwritetext or dbupdatetext to send a large SQLTEXT or SQLIMAGE value to SQL Server in the form of a number of smaller chunks. This is particularly useful with operating systems that cannot allocate extremely long data buffers. A text or image fragment must be shorter than 64 KB.

After calling dbmoretext for the last time, call dbsqlok.

For an example of dbmoretext, see dbwritetext.

See Also