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); }
public bool ColumnExist(string tableName, string columnName) { short value = ODBCDriver.SQLColumns(this.m_StatementHandle, null, 0, null, 0, tableName, -3, columnName, -3); if (this.IsOK((int)value)) { value = ODBCDriver.SQLFetch(this.m_StatementHandle); ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(this.IsOK((int)value)); } ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(false); }
private bool TableExist(string tableName) { short value = ODBCDriver.SQLTables(this.m_StatementHandle, null, 0, null, 0, tableName, -3, "TABLE", -3); if (this.IsOK((int)value)) { value = ODBCDriver.SQLFetch(this.m_StatementHandle); ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(this.IsOK((int)value)); } ODBCDriver.SQLCloseCursor(this.m_StatementHandle); return(false); }