Send part of a text or image value to the server.
RETCODE dbmoretext(dbproc, size, text) DBPROCESS *dbproc; DBINT size; BYTE *text;
A pointer to the DBPROCESS structure that provides the connection for a particular front-end/server process. It contains all the information that DB-Library uses to manage communications and data between the front end and server.
The size, in bytes, of this particular part of the text or image value being sent to the server. It is an error to send more text or image bytes to the server than were specified in the call to dbwritetext.
A pointer to the text or image portion to be written.
SUCCEED or FAIL.
This routine is used in conjunction with dbwritetext to send a large SYBTEXT or SYBIMAGE value to the server in the form of a number of smaller chunks. This is particularly useful with operating systems that are unable to allocate extremely long data buffers.
dbmoretext and dbwritetext are used in updates only, and serve to replace the Transact-SQL update statement.
dbsqlok and dbresults must be called before the first call to dbmoretext and after the last call to dbmoretext.
See the dbwritetext reference page for more information, including an example that uses dbmoretext.
The DB-Library/C option DBTEXTSIZE affects the value of the server @@textsize global variable, which restricts the size of text or image values that the server returns. @@textsize has a default value of 32,768 bytes. An application that retrieves text or image values larger than 32,768 bytes will need to call dbsetopt to make @@textsize larger.
The DB-Library/C option DBTEXTLIMIT limits the size of text or image values that DB-Library/C will read.
