SqlMoreText%

Sends part of a large text or image value to SQL Server.

Syntax

SqlMoreText% ( sqlconn%, size&, text$ )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

size&

Is the size, in bytes, of the particular part of the text or image value sent to SQL Server. You cannot send more text or image bytes to SQL Server than are specified in the call to SqlWriteText% or SqlUpdateText%. The size& parameter cannot be larger than 32K.

text$

Is a string containing the text or image portion to be written.

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlMoreText% is used in conjunction with SqlWriteText% or SqlUpdateText% to send a large text or image value to SQL Server in the form of a number of smaller chunks. This function is particularly useful with operating systems unable to allocate extremely long data buffers.

After calling SqlMoreText% for the last time, call SqlOk%.

For an example using SqlMoreText%, see "SqlWriteText%."

See Also

SqlTxPtr$, SqlTxTimeStamp$, SqlUpdateText%, SqlWriteText%