Function executeSQL

mapmssql2008.c:276–293

Execute SQL against connection. Set error string if failed */

/* Execute SQL against connection. Set error string  if failed */
static int executeSQL(msODBCconn *conn, const char * sql)
{
    SQLRETURN rc;

    SQLCloseCursor(conn->hstmt);

    rc = SQLExecDirect(conn->hstmt, (SQLCHAR *) sql, SQL_NTS);

    if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO)
    {
        return 1;
    }
    else
    {
        setStmntError(conn);
        return 0;
    }
}

/* Get columns name from query results */
static int columnName(msODBCconn *conn, int index, char *buffer, int bufferLength)