Cicode Programming Reference > Cicode Function Categories > SQL Functions Introduction > SQLAppend

SQLAppend

Appends a statement string to the SQL buffer. Cicode cannot send an SQL statement that is longer than 255 characters. If you have an SQL statement that is longer than the 255 character limit, you can split the statement into smaller strings, and use this function to append the statements in the SQL buffer.

Syntax

SQLAppend(hSQL, String)

hSQL:

The handle to the SQL connection, returned from the SQLConnect() function. The SQL connection handle identifies the table where details of the associated SQL connection are stored.

String:

The statement string to append to the SQL buffer.

Return Value

0 (zero) if successful, otherwise an error number is returned. (For details of the 307 error code, call the SQLErrMsg function).

Related Functions

SQLSet, SQLBeginTran, SQLCommit, SQLConnect, SQLDisconnect, SQLEnd, SQLErrMsg

Example

See SQLSet

See Also

SQL Functions