Sets a statement string in 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 and the SQLAppend() function to append the statements in the SQL buffer.
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.
The statement string to set in the SQL buffer. The string needs to contain the first part of an SQL statement.
0 (zero) if successful, otherwise an error number is returned. (For details of the 307 error code, call the SQLErrMsg() function).
SQLAppend, SQLBeginTran, SQLCommit, SQLConnect, SQLDisconnect, SQLEnd
hSQL = SQLConnect("DRV=QEDBF");
SQLSet(hSQL, "SELECT *")
SQLAppend(hSQL, " FROM EMP");
SQLAppend(hSQL, " ORDER BY last_name");