The SQL_Clear() function clears any results sets and errors for the specified pass-through SQL connection.
SQL_Clear(SQL_connection)
• SQL_connection – A long integer specifying the pass-through SQL connection for which results sets and errors will be cleared.
A long integer indicating the status. The value 0 is returned if the results set was successfully cleared. Any other value indicates an error occurred.
Use the SQL_Clear() function if you will be executing several sets of SQL statements using one pass-through SQL connection.