BOOL CODBC::UpdateBalance(DWORD dwID, DWORD dwBalance)
{
	SQLRETURN	ret;
	char szQuery[MAXSIZE_QUERYSTR];

	wsprintf(szQuery, "UPDATE users SET balance=%d WHERE (id=%d)", dwBalance, dwID);
	
	ret = SQLExecDirect(m_hStmt, (SQLTCHAR *) szQuery, lstrlen(szQuery));
	if (SQL_SUCCESS != ret && SQL_SUCCESS_WITH_INFO != ret)
	{
 
		char Sqlstate[6], text[1000];
		SQLINTEGER NativeError;
		SQLSMALLINT len;

		if (SQL_SUCCESS != SQLGetDiagRec(SQL_HANDLE_STMT, m_hStmt, 1, (SQLCHAR *) Sqlstate, &NativeError, (SQLCHAR *) text, 1000, &len))
			return FALSE;



		m_pErrorManager->WriteError("Can't process SQLExecDirect");
		return FALSE;
	}

	return TRUE;
}