public bool RetrieveValue(string sqlstatement, ref string result) { short value = ODBCDriver.SQLExecDirect(this.m_StatementHandle, sqlstatement, -3); if (!this.IsOK((int)value)) { return(false); } value = ODBCDriver.SQLFetch(this.m_StatementHandle); if (!this.IsOK((int)value)) { ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(false); } System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(1024); short num; value = ODBCDriver.SQLGetData(this.m_StatementHandle, 1, 1, stringBuilder, 1024, out num); if (!this.IsOK((int)value)) { ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(false); } result = stringBuilder.ToString(); ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(true); }
private bool ExecuteSQL(string sqlStmt) { short value = ODBCDriver.SQLExecDirect(this.m_StatementHandle, sqlStmt, sqlStmt.Length); return(this.IsOK((int)value)); }