sPhenix code displayed by LXR master/​RDBC/​odbc/​ODBCResultSet.cxx	Source navigation Diff markup Identifier search General search
	Version: master Revert   Change

File indexing completed on 2025-08-03 08:22:05

 // $Id: ODBCResultSet.cxx,v 1.3 2007/02/28 21:33:40 phnxbld Exp $
 //*-- Author : Valeriy Onuchin 14/02/2000 
 //
 
 /**************************************************************************
 
    ROOT wrappers of libodbc++ library
     
    Copyright (C) 1999-2000 Manush Dodunekov <manush@stendahls.net>
    
    This library is free software; you can redistribute it and/or
    modify it under the terms of the GNU Library General Public
    License as published by the Free Software Foundation; either
    version 2 of the License, or (at your option) any later version.
    
    This library is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
    Library General Public License for more details.
    
    You should have received a copy of the GNU Library General Public License
    along with this library; see the file COPYING.  If not, write to
    the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
    Boston, MA 02111-1307, USA.
 
 **************************************************************************/
 
 //
 /////////////////////////////////////////////////////////////////////
 //
 // A TSQLResultSet provides access to a table of data. A 
 // TSQLResultSet object is usually generated by executing 
 // TSQLStatement. 
 //
 // A TSQLResultSet maintains a cursor pointing to its current row 
 // of data. Initially the cursor is positioned before the first
 // row. The Next() method moves the cursor to the next row. 
 //
 // The GetXXX methods retrieve column values for the current row.
 // You can retrieve values using either the index number of the 
 // column or the name of the column. In general,using the column 
 // index will be more efficient. Columns are numbered from 1. 
 //
 // For maximum portability, TSQLResultSet columns within each row
 // should be read in left-to-right order and each column should be 
 // read only once. 
 //
 // For the GetXXX methods, the driver attempts to convert the
 // underlying data to the specified ROOT type and returns a suitable 
 // value. See the specification for allowable mappings 
 // from SQL types to ROOT types with the ODBCResultSet::GetXXX 
 // methods. 
 //
 // Column names used as input to GetXXX methods are case
 // insensitive. When performing a GetXXX using a column name, 
 // if several columns have the same name, then the value of the 
 // first matching column will be returned. The column name option 
 // is designed to be used when column names are used in the SQL 
 // query. For columns that are NOT explicitly named in the query, 
 // it is best to use column numbers. If column names are used, there 
 // is no way for the programmer to guarantee that they actually refer 
 // to the intended columns. 
 //
 // A TSQLResultSet is automatically closed by the TSQLStatement that 
 // generated it when that TSQLStatement is closed, re-executed, 
 // or used  to retrieve the next result from a sequence of multiple 
 // results. 
 //
 // The number, types and properties of a TSQLResultSet's columns are
 // provided by the TSQLResulSetMetaData object returned by the 
 // GetMetaData() method. 
 //
 // See also: 
 //      TSQLStatement::ExecuteQuery(const TString&),
 //      TSQLStatement::GetResultSet(), TSQLResultSetMetaData
 //
 //___________________________________________________________________
 //
 //       kCONCUR_READ_ONLY 
 //
 // The concurrency mode for a TSQLResultSet object that may 
 // NOT be updated.
 //___________________________________________________________________
 //
 //       kCONCUR_UPDATABLE 
 //
 //  The concurrency mode for a TSQLResultSet
 //  object that may be updated.
 //___________________________________________________________________
 //
 //       kFETCH_FORWARD 
 //
 // The rows in a result set will be
 // processed in a forward direction; first-to-last.
 //___________________________________________________________________
 //
 //       kFETCH_REVERSE 
 //
 // The rows in a result set will be
 // processed in a reverse direction; last-to-first.
 //___________________________________________________________________
 //
 //       kFETCH_UNKNOWN 
 //
 // The order in which rows in a result set
 // will be processed is unknown.
 //___________________________________________________________________
 //
 //       kTYPE_FORWARD_ONLY 
 //
 // The type for a TSQLResultSet object whose
 // cursor may move only forward.
 //___________________________________________________________________
 //
 //       kTYPE_SCROLL_INSENSITIVE 
 //
 // The type for a TSQLResultSet object that is
 // scrollable but generally not sensitive to changes made by
 // others.
 //___________________________________________________________________
 //
 //       kTYPE_SCROLL_SENSITIVE 
 // 
 // The type for a TSQLResultSet object that is
 // scrollable and generally sensitive to changes made by
 // others.
 //
 /////////////////////////////////////////////////////////////////////
  
 #include <ODBCResultSet.h>
 #include <ODBCResultSetMetaData.h>
 #include <ODBCStatement.h>
 #include <TList.h>
 #include <TMath.h>
 #include <TStopwatch.h>
 #include <TBuffer.h>
 #include <TTree.h>
 #include <TRandom.h>
 #include <TBranch.h>
 #include <RDBC/odbc++/resultset.h>
 #include <RDBC/odbc++/resultsetmetadata.h>
 #include <iostream>
 #include <sstream>
 #include <ctype.h>
 #include <time.h>
 #include <TSQLRow.h>
 
 #if ROOT_VERSION_CODE >= ROOT_VERSION(5,15,0)
 #include <TBufferFile.h>
 #endif
 
 using namespace odbc;
 using namespace std;
 
 ClassImpQ(ODBCResultSet)
 
 /////////////////////////////////////////////////////////////////////
 class RDBCRow: public TSQLRow
 {
 friend  class ODBCResultSet;
 
 private:
    TSQLResultSet* fResultSet; // parent result set
    RDBCRow(TSQLResultSet *result=0) { fResultSet=result; }
    RDBCRow* Set(TSQLResultSet *result) { fResultSet=result; return this; }
    virtual ~RDBCRow() {  fResultSet = 0; }
    TString fField;  // selected field
 
 public:
    void        Close(Option_t* /* opt="" */) { fResultSet = 0; }
    ULong_t     GetFieldLength(Int_t field) { return fResultSet ? fResultSet->GetMetaData()->GetColumnDisplaySize(field-1) : 0; }
    const char* GetField(Int_t field) { fField = fResultSet ? fResultSet->GetString(field-1).Data() : ""; return fField.Data(); }
 }; 
 
 /////////////////////////////////////////////////////////////////////
 //___________________________________________________________________
 ODBCResultSet::ODBCResultSet(TSQLStatement* stmt,void* imp):
    TSQLResultSet(stmt,imp)
 {
    // ctor
    
    fStatement = stmt;
    odbc::ResultSet* rs = (odbc::ResultSet*)imp;
    fImp = rs;
    fRow = new RDBCRow(this);
    
    try {
       odbc::ResultSetMetaData* mdimp = rs->getMetaData();
       fMetaData = new ODBCResultSetMetaData(this,mdimp);    
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }                             
 
 //___________________________________________________________________
 ODBCResultSet::~ODBCResultSet()
 {
    // destructor. 
 
    odbc::ResultSet* imp = (odbc::ResultSet*)fImp;  
 
    try {
       if(imp) delete imp; 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 
    fImp = 0; 
    
    if(fMetaData) delete ((ODBCResultSetMetaData*)fMetaData);
    if(fRow) delete fRow;
    
    ODBCStatement* stmt = (ODBCStatement*)fStatement;
    if(stmt->fCurrentResult==this) stmt->fCurrentResult = 0;
 
    fMetaData = 0;
    fRow = 0;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::WasNull()
 {
    // Reports whether the last column read had a value of SQL NULL. 
    // Note that you must first call GetXXX on a column to try to 
    // read its value and then call WasNull() to see if the value 
    // read was SQL NULL.
    //
    // Returns:
    //       kTRUE if last column read was SQL NULL and 
    //       kFALSE - otherwise
    //  Throws:
    //       TSQLException - if a database access error occurs
  
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       return_value = rs->wasNull();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 TString ODBCResultSet::GetString( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a TString.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, the result 
    //       is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TString str;
    
    if(!fImp) { Destroyed(); return str; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {
       str = ODBCXX_STRING_CSTR( rs->getString(columnIndex) );  
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return ""; 
    }
    return str;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::GetBoolean( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a boolean.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, the result is
    //       kFALSE
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {    
       return_value =  rs->getBoolean(columnIndex);
    
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Char_t ODBCResultSet::GetByte( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a byte.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Char_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value =  rs->getByte(columnIndex);
       
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;   
 }
 
 //___________________________________________________________________
 Short_t ODBCResultSet::GetShort( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a Short_t.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Short_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->getShort(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetInt( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a Int_t.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->getInt(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Long_t ODBCResultSet::GetLong( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a Long_t.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Long_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->getLong(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Float_t ODBCResultSet::GetFloat( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a Float_t.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    Float_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {      
       return_value = rs->getFloat(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Double_t ODBCResultSet::GetDouble( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a Double_t.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    Double_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {      
       return_value = rs->getDouble(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 TArrayC ODBCResultSet::GetBytes( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a char array.
    // The chars represent the raw values returned by the driver.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
  
    TArrayC array;
    
    if(!fImp) { Destroyed(); return array; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {           
       ODBCXX_BYTES b = rs->getBytes(columnIndex);
       
       array.Set( (Int_t)ODBCXX_BYTES_SIZE(b),
                  (Char_t*)ODBCXX_BYTES_DATA(b) );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
    return array;
 }
 
 //___________________________________________________________________
 TSQLDate ODBCResultSet::GetDate( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a TSQLDate
    // object.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TSQLDate return_value;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       odbc::Date dt = rs->getDate(columnIndex);
       return_value = TSQLDate( dt.getYear(),
                                dt.getMonth(),
                                dt.getDay() );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
    return return_value;
 }
 
 //___________________________________________________________________
 TSQLTime ODBCResultSet::GetTime( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a TSQLTime
    // object.
    //
    // Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TSQLTime return_value;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       odbc::Time tm = rs->getTime(columnIndex);
 
       return_value = TSQLTime( tm.getHour(),
                                tm.getMinute(),
                                tm.getSecond() );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
    return return_value;
 }
 
 //___________________________________________________________________
 TSQLTimestamp ODBCResultSet::GetTimestamp( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a
    // TSQLTimestamp object.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TSQLTimestamp return_value;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       odbc::Timestamp tmstmp = rs->getTimestamp(columnIndex);
       return_value = TSQLTimestamp( tmstmp.getYear(),
                                     tmstmp.getMonth(),
                                     tmstmp.getDay(), 
                                     tmstmp.getHour(),
                                     tmstmp.getMinute(),
                                     tmstmp.getSecond(),
                                     tmstmp.getNanos() );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
    return return_value;
 }
 
 //___________________________________________________________________
 TBuffer* ODBCResultSet::GetAsciiStream( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a stream 
    // of ASCII characters. The value can then be read in chunks from 
    // the stream. This method is particularly suitable for 
    // retrieving large LONGVARCHAR values. The driver will do 
    // any necessary conversion from the database format into ASCII. 
    //
    //  Note: All the data in the returned stream must be read prior 
    //    to getting the value of any other column. The next call to 
    //    a get method implicitly closes the stream. Also, a stream 
    //    may return 0 when the method available is called whether 
    //    there is data available or not.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       A TBuffer that delivers the database column 
    //       value as a stream of one char ASCII characters. 
    //       If the value is SQL NULL then the result is null.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TBuffer* buffer = 0;
 
    if(!fImp) { Destroyed(); return buffer; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {   
       ODBCXX_STREAM* rsStream = rs->getAsciiStream(columnIndex);
       Int_t bufsiz = rsStream->rdbuf()->in_avail();
       if(bufsiz<=0) return 0;
 #if ROOT_VERSION_CODE >= ROOT_VERSION(5,15,0)
       buffer  = new TBufferFile(TBuffer::kWrite, bufsiz); 
 #else
       buffer  = new TBuffer(TBuffer::kWrite, bufsiz); 
 #endif
       int c;
       while ((c = rsStream->get()) != EOF)
     {
       *buffer << (char) c;
     }
       buffer->SetBufferOffset();
       buffer->SetReadMode();
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       buffer = 0;
    }
    return buffer;
 }
 
 //___________________________________________________________________
 TBuffer* ODBCResultSet::GetBinaryStream( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as a stream of
    // uninterpreted chars. The value can then be read in chunks 
    // from the stream. This method is particularly suitable for
    //  retrieving large LONGVARBINARY values. 
    //
    //  Note: All the data in the returned stream must be read 
    //    prior to getting the value of any other column. The next 
    //    call to a Get method implicitly closes the stream. Also, 
    //    a stream may return 0 when the method available is called 
    //    whether there is data available or not.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       TBuffer that delivers the database column 
    //       value as a stream of uninterpreted chars. If the value 
    //       is SQL NULL then the result is null.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TBuffer* buffer = 0;
 
    if(!fImp) { Destroyed(); return buffer; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {   
       ODBCXX_STREAM* rsStream = rs->getBinaryStream(columnIndex);
       Int_t bufsiz = rsStream->rdbuf()->in_avail();
       if(bufsiz<=0) return 0;
 #if ROOT_VERSION_CODE >= ROOT_VERSION(5,15,0)
       buffer  = new TBufferFile(TBuffer::kWrite, bufsiz); 
 #else
       buffer  = new TBuffer(TBuffer::kWrite, bufsiz); 
 #endif
       int c;
       while ((c = rsStream->get()) != EOF)
     {
       *buffer << (char) c;
     }
       buffer->SetBufferOffset();
       buffer->SetReadMode();
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       buffer = 0;
    }
    return buffer;
 }
 
 //___________________________________________________________________
 TObject* ODBCResultSet::GetObject( Int_t columnIndex )
 {
    // Gets the value of a column in the current row as ROOT object.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       TObject 
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    TObject* obj =0;
 
    TBuffer *b = GetBinaryStream(columnIndex);
    obj = (TObject *)b->ReadObjectAny(TObject::Class()); 
    // Laurent found that this causes a memory leak, Valeriy Onuchin never responded to this
    // b->DetachBuffer();
    delete b; 
    return obj;
 }
 
 //___________________________________________________________________
 TString ODBCResultSet::GetString( const TString& columnName )
 {
    // Gets the value of a column in the current row as a TString.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetString(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::GetBoolean( const TString& columnName )
 {
    // Gets the value of a column in the current row as a boolean.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is kFALSE
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetBoolean(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Char_t ODBCResultSet::GetByte( const TString& columnName )
 {
    // Gets the value of a column in the current row as a Char_t.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetByte(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Short_t ODBCResultSet::GetShort( const TString& columnName )
 {
     // Gets the value of a column in the current row as a Short_t.
     // 
     // Parameters:
     //      columnName - the SQL name of the column
     // Returns:
     //      the column value; if the value is SQL NULL, 
     //      the result is 0
     // Throws:
     //      TSQLException - if a database access error occurs
 
    return GetShort(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetInt( const TString& columnName )
 {
    // Gets the value of a column in the current row as a Int_t.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetInt(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Long_t ODBCResultSet::GetLong( const TString& columnName )
 {
    // Gets the value of a column in the current row as a Long_t.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL,
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetLong(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Float_t ODBCResultSet::GetFloat( const TString& columnName )
 {
    // Gets the value of a column in the current row as a Float_t.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetFloat(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 Double_t ODBCResultSet::GetDouble( const TString& columnName )
 {
    // Gets the value of a column in the current row as a Double_t.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is 0
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetDouble(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TArrayC ODBCResultSet::GetBytes( const TString& columnName )
 {
    // Gets the value of a column in the current row as a char
    // array. The chars represent the raw values returned by the 
    // driver.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetBytes(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TSQLDate ODBCResultSet::GetDate( const TString& columnName )
 {
    // Gets the value of a column in the current row as a TSQLDate
    //  object.
    // 
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    return GetDate(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TSQLTime ODBCResultSet::GetTime( const TString& columnName )
 {
   // Gets the value of a column in the current row as a TSQLTime
   // object.
   //
   //   Parameters:
   //        columnName - the SQL name of the column
   //   Returns:
   //        the column value; if the value is SQL NULL,
   //        the result is null
   //   Throws:
   //        TSQLException - if a database access error occurs
 
   return GetTime(FindColumn(columnName)); 
 }
 
 //___________________________________________________________________
 TSQLTimestamp ODBCResultSet::GetTimestamp( const TString& columnName )
 {
    // Gets the value of a column in the current row as a
    // TSQLTimestamp object.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       the column value; if the value is SQL NULL, 
    //       the result is null
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetTimestamp(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TBuffer* ODBCResultSet::GetAsciiStream( const TString& columnName )
 {
    // Gets the value of a column in the current row as a stream 
    // of ASCII characters. The value can then be read in chunks 
    // from the stream. This method is particularly suitable for 
    // retrieving large LONGVARCHAR values. The driver will do 
    // any necessary conversion from the database format into ASCII. 
    //
    //  Note: All the data in the returned stream must be read prior
    //    to getting the value of any other column. The next call to
    //    a  Get method implicitly closes the stream. Also, a stream 
    //    may return 0 when the method available is called whether 
    //    there is data available or not.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       TBuffer that delivers the database column 
    //       value as a stream of one char ASCII characters. If 
    //       the value is SQL NULL then the result is null.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetAsciiStream(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TBuffer* ODBCResultSet::GetBinaryStream( const TString& columnName )
 {
    // Gets the value of a column in the current row as a stream of
    // uninterpreted chars. The value can then be read in chunks 
    // from the stream. This method is particularly suitable for
    // retrieving large LONGVARBINARY values. The driver will 
    // do any necessary conversion from the database format into 
    // uninterpreted chars. 
    //
    //  Note: All the data in the returned stream must be read 
    //    prior to getting the value of any other column. The next 
    //    call to a Get method implicitly closes the stream. Also, 
    //    a stream may return 0 when the method available is called 
    //    whether there is data available or not.
    //
    //  Parameters:
    //       columnName - the SQL name of the column
    //  Returns:
    //       TBuffer that delivers the database column 
    //       value as a stream of uninterpreted chars. If the value 
    //       is SQL NULL then the result is null.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return GetBinaryStream(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TObject* ODBCResultSet::GetObject( const TString& columnName )
 {
    // Gets the value of a column in the current row as ROOT object.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Returns:
    //       TObject 
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    return GetObject(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 TString ODBCResultSet::GetCursorName()
 {
    // Gets the name of the SQL cursor used by this TSQLResultSet. 
    //
    // In SQL, a result table is retrieved through a cursor that 
    // is named. The current row of a result can be updated or 
    // deleted using a positioned Update/Delete statement that 
    // references the cursor name. To insure that the cursor has 
    // the proper isolation level to support update, the cursor's 
    // select statement should be of the form 'SELECT FOR UPDATE'. 
    // If the 'FOR UPDATE' clause is omitted the positioned 
    // updates may fail. 
    //    The current row of a TSQLResultSet is also the current row 
    // of this SQL cursor. 
    //
    //  Note: If positioned update is not supported a 
    //       SQLException is thrown
    //  Returns:
    //       the TSQLResultSet's SQL cursor name
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    TString str;
    
    if(!fImp) { Destroyed(); return str; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       str = ODBCXX_STRING_CSTR( rs->getCursorName() );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return "";
    }
    return str;
 }
 
 //___________________________________________________________________
 TSQLResultSetMetaData* ODBCResultSet::GetMetaData()
 {
    // Retrieves the number, types and properties of a 
    // TSQLResultSet's columns.
    //
    //  Returns:
    //       the description of a TSQLResultSet's columns
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    return fMetaData;
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::FindColumn( const TString& columnName )
 {
    // Maps the given resultset column name to its TSQLResultSet
    // column index.
    //
    //  Parameters:
    //       columnName - the name of the column
    //  Returns:
    //       the column index
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try { 
       return_value = rs->findColumn( 
                                  ODBCXX_STRING_C(columnName.Data()) );
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::IsBeforeFirst()
 {
    // Indicates whether the cursor is before the first row in 
    // the result set.
    //
    //  Returns:
    //       kTRUE if the cursor is before the first row, 
    //       kFALSE otherwise. Returns kFALSE when the
    //       result set contains no rows.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->isBeforeFirst();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::IsAfterLast()
 {
    // Indicates whether the cursor is after the last row in 
    // the result set.
    //
    //  Returns:
    //       kTRUE if the cursor is after the last row, 
    //       kFALSE otherwise. Returns kFALSE when the
    //       result set contains no rows.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {      
       return_value = rs->isAfterLast();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
           
 //___________________________________________________________________
 Bool_t ODBCResultSet::IsFirst() 
 {
    // Indicates whether the cursor is on the first row of 
    // the result set.
    //
    //  Returns:
    //       kTRUE if the cursor is on the first row, 
    //       kFALSE otherwise.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->isFirst();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::IsLast()
 {
    // Indicates whether the cursor is on the last row of the 
    // result set.
    //
    //  Note: Calling the method IsLast() may be expensive because 
    //       the driver might need to fetch ahead one row in 
    //       order to determine whether the current row is the 
    //       last row in the result set.
    //
    //  Returns:
    //       kTRUE if the cursor is on the last row, 
    //       kFALSE otherwise.
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       return_value = rs->isLast();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 void ODBCResultSet::BeforeFirst()
 {
    // Moves the cursor to the front of the result set, just before 
    // the first row. Has no effect if the result set contains no 
    // rows.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {     
       rs->beforeFirst();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::AfterLast()
 {
    // Moves the cursor to the end of the result set, just after 
    // the last row. Has no effect if the result set contains no 
    // rows.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY
 
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {
       rs->afterLast();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetRow()
 {
    // Retrieves the current row number. The first row is number 1, 
    // the second number 2, and so on.
    //
    //  Returns:
    //       the current row number; 0 if there is no current row
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       return_value = rs->getRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 void ODBCResultSet::SetFetchDirection(Int_t /* direction */)
 {
    // Gives a hint as to the direction in which the rows in this
    // result set will be processed. The initial value is determined
    // by the TSQLStatement that produced the result set.
    // The fetch direction may be changed at any time.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY and the fetch 
    //       direction is not forward
 
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetFetchDirection()
 {
    // Returns the fetch direction for this result set.
    //
    //  Returns:
    //       the current fetch direction for this result set
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    return 0;   // not applied
 }
 
 //___________________________________________________________________
 void ODBCResultSet::SetFetchSize(Int_t rows)
 {
    // Gives the driver a hint as to the number of rows that
    // should be fetched from the database when more rows are needed 
    // for this result set. If the fetch size specified is zero, 
    // the driver ignores the value and is free to make its own
    // best guess as to what the fetch size should be. The default 
    // value is set by the statement that created the result set. 
    // The fetch size may be changed at any time.
    //
    //  Parameters:
    //       rows - the number of rows to fetch
    //  Throws:
    //       TSQLException - if a database access error occurs or the
    //       condition 0 <= rows <= GetMaxRows() is not satisfied.
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->setFetchSize(rows);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetFetchSize()
 {
    // Returns the fetch size for this result set.
    //
    //  Returns:
    //       the current fetch size for this result set
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->getFetchSize();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetType()
 {
    // Returns the type of this result set. The type is
    // determined by the TSQLStatement that created the result set.
    //
    //  Returns:
    //       kTYPE_FORWARD_ONLY, kTYPE_SCROLL_INSENSITIVE, or
    //       kTYPE_SCROLL_SENSITIVE
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {     
       return_value = rs->getType();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Int_t ODBCResultSet::GetConcurrency()
 {
    // Returns the concurrency mode of this result set. The
    // concurrency used is determined by the TSQLStatement that 
    // created the result set.
    //
    //  Returns:
    //       the concurrency type, kCONCUR_READ_ONLY or 
    //                             kCONCUR_UPDATABLE
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    Int_t return_value = 0;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {      
       return_value = rs->getConcurrency();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::RowUpdated()
 {
    // Indicates whether the current row has been updated. The
    // value returned depends on whether or not the result set 
    // can detect updates.
    //
    //  Returns:
    //       kTRUE if the row has been visibly updated by 
    //       the owner or another, and updates are detected
    //  Throws:
    //       TSQLException - if a database access error occurs
    //  See Also: 
    //       TSQLDatabaseMetaData::updatesAreDetected(Int_t)
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {
       return_value = rs->rowUpdated();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::RowInserted()
 {
    // Indicates whether the current row has had an insertion.
    //  The value returned depends on whether or not the 
    // result set can detect visible inserts.
    //
    //  Returns:
    //       kTRUE if a row has had an insertion and insertions 
    //       are detected
    //  Throws:
    //       TSQLException - if a database access error occurs
    //  See Also: 
    //       TSQLDatabaseMetaData::insertsAreDetected(Int_t)
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       return_value = rs->rowInserted();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 Bool_t ODBCResultSet::RowDeleted()
 {
    // Indicates whether a row has been deleted. A deleted row
    // may leave a visible "hole" in a result set. This method 
    // can be used to detect holes in a result set. The value 
    // returned depends on whether or not the result set can 
    // detect deletions.
    //
    //  Returns:
    //       kTRUE if a row was deleted and deletions are detected
    //  Throws:
    //       TSQLException - if a database access error occurs
    //  See Also: 
    //       TSQLDatabaseMetaData::deletesAreDetected(Int_t)
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return return_value; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {
       return_value = rs->rowDeleted();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = kFALSE;
    }
    return return_value;
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateNull( Int_t columnIndex )
 {
    // Give a nullable column a null value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    //
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateNull(columnIndex);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBoolean( Int_t columnIndex,Bool_t x )
 {
    // Updates a column with a boolean value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateBoolean(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateByte( Int_t columnIndex,Char_t x )
 {
    // Updates a column with a Char_t value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateByte(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateShort( Int_t columnIndex,Short_t x )
 {
    // Updates a column with a Short_t value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateShort(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateInt( Int_t columnIndex,Int_t x )
 {
    // Updates a column with an integer value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       rs->updateInt(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateLong( Int_t columnIndex,Long_t x )
 {
    // Updates a column with a Long_t value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       rs->updateLong(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateFloat( Int_t columnIndex,Float_t x )
 {
    // Updates a column with a Float_t value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       rs->updateFloat(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateDouble( Int_t columnIndex,
                                   Double_t x )
 {
    // Updates a column with a Double value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateDouble(columnIndex,x);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateString( Int_t columnIndex,
                                   const TString& x )
 {
    // Updates a column with a TString value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {       
       ODBCXX_STRING s = ODBCXX_STRING_C(x.Data()); 
       rs->updateString(columnIndex,s);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBytes( Int_t columnIndex,
                                  const TArrayC& x )
 {
    // Updates a column with a Char_t array value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       ODBCXX_BYTES b = ODBCXX_BYTES_C(x.GetArray(),x.GetSize());
       rs->updateBytes(columnIndex,b);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateDate( Int_t columnIndex,
                                 const TSQLDate& x )
 {
    // Updates a column with a TSQLDate value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       odbc::Date dt( x.GetYear(),
                      x.GetMonth(),
                      x.GetDay() );
     
       rs->updateDate(columnIndex,dt);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateTime( Int_t columnIndex,
                                 const TSQLTime& x )
 {
    // Updates a column with a TSQLTime value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try { 
       odbc::Time tm( x.GetHour(),
                      x.GetMinute(),
                      x.GetSecond() );
    
       rs->updateTime(columnIndex,tm);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateTimestamp( Int_t columnIndex,
                                      const TSQLTimestamp& x )
 {
    // Updates a column with a TSQLTimestamp value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try { 
       odbc::Timestamp tmstmp( x.GetYear(),
                               x.GetMonth(),
                               x.GetDay(),  
                               x.GetHour(),
                               x.GetMinute(),
                               x.GetSecond(),
                               x.GetNanos() );
    
       rs->updateTimestamp(columnIndex,tmstmp);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateAsciiStream( Int_t columnIndex,
                                        TBuffer* x,
                                        Int_t length )
 {
    // Updates a column with an ascii stream value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream
    //  Throws:
    //       TSQLException - if a database access error occurs  
 
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {         
       Int_t xl = (x->BufferSize()>length) && (length>0) ? length : x->BufferSize();
       std::istringstream* s = new std::istringstream(x->Buffer()); //
       rs->updateAsciiStream( columnIndex,(std::istream*)s,xl );
       
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBinaryStream( Int_t columnIndex,
                                         TBuffer* x,
                                         Int_t length )
 {
    // Updates a column with a binary stream value. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream   
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {   
       Int_t xl = (x->BufferSize()>length) && (length>0) ? length : x->BufferSize();
       std::istringstream* s = new std::istringstream(x->Buffer());
       rs->updateBinaryStream( columnIndex,(std::istream*)s,xl );
       
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateObject( Int_t columnIndex,TObject* x )
 {
    // Updates a column with a ROOT object. The UpdateXXX
    // methods are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream   
    //  Throws:
    //       TSQLException - if a database access error occurs
  
 #if ROOT_VERSION_CODE >= ROOT_VERSION(5,15,0)
   TBuffer *b = new TBufferFile(TBuffer::kWrite);
 #else
   TBuffer *b = new TBuffer(TBuffer::kWrite);
 #endif
    b->WriteObject(x);
    UpdateBinaryStream(columnIndex,b,b->BufferSize());
    b->DetachBuffer();
    delete b; 
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateNull( const TString& columnName )
 {
    // Updates a column with a null value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateNull(FindColumn(columnName));
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBoolean( const TString& columnName,Bool_t x )
 {
    // Updates a column with a boolean value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateBoolean(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateByte( const TString& columnName,Char_t x )
 {
    // Updates a column with a Char_t value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateByte(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateShort( const TString& columnName,Short_t x )
 {
    // Updates a column with a short value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateShort(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateInt( const TString& columnName,Int_t x )
 {
    // Updates a column with an integer value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateInt(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateLong( const TString& columnName,Long_t x )
 {
    // Updates a column with a long value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateLong(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateFloat( const TString& columnName,Float_t x )
 {
    // Updates a column with a float value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs 
 
    UpdateFloat(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateDouble( const TString& columnName,Double_t x )
 {
    // Updates a column with a double value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateDouble(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateString( const TString& columnName,
                                   const TString& x )
 {
    // Updates a column with a TString value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateString(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBytes( const TString& columnName,
                                  const TArrayC& x )
 {
    // Updates a column with a bytes array value. The update methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs 
 
    UpdateBytes(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateDate( const TString& columnName,
                                 const TSQLDate& x )
 {
    // Updates a column with a TSQLDate value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs 
 
    UpdateDate(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateTime( const TString& columnName,
                                 const TSQLTime& x )
 {
    // Updates a column with a TSQLTime value. The UpdateXXX methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs 
    
    UpdateTime(FindColumn(columnName),x);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateTimestamp( const TString& columnName,
                                      const TSQLTimestamp& x )
 {
    // Updates a column with a TSQLTimestamp value. The update methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    UpdateTimestamp(FindColumn(columnName),x);
 }   
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateAsciiStream( const TString& columnName,
                                        TBuffer* x,
                                        Int_t length )
 {
    // Updates a column with an ascii stream value. The update methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    UpdateAsciiStream(FindColumn(columnName),x,length);
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateBinaryStream( const TString& columnName,
                                         TBuffer* x,
                                         Int_t length )
 {
    // Updates a column with a binary stream value. The update methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    UpdateBinaryStream(FindColumn(columnName),x,length); 
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateObject(const TString& columnName,TObject* x)
 {
    // Updates a column with a ROOT object. The update methods
    // are used to update column values in the current row, 
    // or the insert row. The UpdateXXX methods do not update the
    // underlying database; instead the UpdateRow() or InsertRow() 
    // methods are called to update the database.
    // 
    //  Parameters:
    //       columnIndex - the first column is 1, the second is 2, ...
    //       x - the new column value
    //       length - length of stream
    //  Throws:
    //       TSQLException - if a database access error occurs
    
    UpdateObject(FindColumn(columnName),x); 
 }
 
 //___________________________________________________________________
 void ODBCResultSet::InsertRow()
 {
    // Inserts the contents of the insert row into the result set
    // and the database. Must be on the insert row when this method
    // is called.
    //
    //  Throws:
    //     TSQLException - if a database access error occurs, if 
    //     called when not on the insert row, or if not all of 
    //     non-nullable columns in the insert row have been given 
    //     a value.
 
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
 
    try {
       rs->insertRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::UpdateRow()
 {
    // Updates the underlying database with the new contents of
    // the current row. Cannot be called when on the insert row.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or if
    //       called when on the insert row
 
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->updateRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::DeleteRow()
 {
    // Deletes the current row from the result set and the underlying 
    // database. Cannot be called when on the insert row.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       if called when on the insert row.
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->deleteRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::RefreshRow()
 {
    // Refreshes the current row with its most recent value in
    // the database. Cannot be called when on the insert row. 
    // The RefreshRow() method provides a way for an application to
    // explicitly tell the driver to refetch a row(s) from the
    // database. An application may want to call RefreshRow() when 
    // caching or prefetching is being done by the driver to
    // fetch the latest value of a row from the database. The 
    // driver may actually refresh multiple rows at once if the 
    // fetch size is greater than one. All values are refetched
    // subject to the transaction isolation level and cursor 
    // sensitivity. If RefreshRow() is called after calling UpdateXXX,
    // but before calling UpdateRow(), then the updates made to the 
    // row are lost. Calling the method RefreshRow() frequently will 
    // likely slow performance.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       if called when on the insert row
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->refreshRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::CancelRowUpdates()
 {
    // Cancels the updates made to a row. This method may be
    // called after calling an UpdateXXX method(s) and before 
    // calling UpdateRow() to rollback the updates made to a row. 
    // If no updates have been made or UpdateRow() has already been 
    // called then this method has no effect.
    //
    //   Throws:
    //        TSQLException - if a database access error occurs or if 
    //         called when on the insert row
   
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       rs->cancelRowUpdates();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::MoveToInsertRow()
 {
    //  Moves the cursor to the insert row. The current cursor
    //  position is remembered while the cursor is positioned on 
    //  the insert row. The insert row is a special row associated 
    //  with an updatable result set. It is essentially a buffer 
    //  where a new row may be constructed by calling the UpdateXXX 
    //  methods prior to inserting the row into the result set. 
    //  Only the UpdateXXX, GetXXX, and InsertRow() methods may be 
    //  called when the cursor is on the insert row.
    //  All of the columns in a result set must be given a value 
    //  each time this method is called before calling InsertRow(). 
    //  The method UpdateXXX must be called before a GetXXX method 
    //  can be called on a column value.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs 
    //       or the result set is not updatable
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       rs->moveToInsertRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 void ODBCResultSet::MoveToCurrentRow()
 {
    // Moves the cursor to the remembered cursor position,
    // usually the current row. This method has no effect if the 
    // cursor is not on the insert row.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set is not updatable
    
    if(!fImp) { Destroyed(); return; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       rs->moveToCurrentRow();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::Next()
 {
    // Moves the cursor down one row from its current position. A
    // TSQLResultSet cursor is initially positioned before the first 
    // row; the first call to next makes the first row the current 
    // row; the second call makes the second row the current row, 
    // and so on.
    // 
    // If an input stream is open for the current row, a call to the
    // method next will implicitly close it. The TSQLResultSet's 
    // warning chain is cleared when a new row is read.
    //
    //  Returns:
    //       pointer to TSQLRow(kTRUE) if the new current row is valid; 
    //       null(kFALSE) if there are no more rows
    //  Throws:
    //       TSQLException - if a database access error occurs
 
    Bool_t return_value=kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->next();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value ? fRow->Set(this) : 0;
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::First()
 {
    // Moves the cursor to the first row in the result set.
    //
    //  Returns:
    //       pointer to TSQLRow(kTRUE)  if the cursor is on a valid row; 
    //       null(kFALSE) if there are no rows in the result set
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY
 
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {      
       return_value = rs->first();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value  ? fRow->Set(this) : 0;
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::Absolute( Int_t row )
 {
    // Moves the cursor to the given row number in the result set. 
    // If the row number is positive, the cursor moves to the 
    // given row number with respect to the beginning of the 
    // result set. The first row is row 1, the second is row 2, 
    // and so on. 
    //
    //  If the given row number is negative, the cursor moves to an
    // absolute row position with respect to the end of the result 
    // set. For example, calling Absolute(-1) positions the cursor
    // on the last row, Absolute(-2) indicates the next-to-last row, 
    // and so on. 
    //
    //  An attempt to position the cursor beyond the first/last row 
    // in the result set leaves the cursor before/after the first/last
    // row, respectively. 
    //
    //  Note: calling Absolute(1) is the same as calling First(). 
    //        calling Absolute(-1) is the same as calling Last().
    //
    //  Returns:
    //       pointer to TSQLRow(kTRUE)  if the cursor is on the result set; 
    //       null(kFALSE) otherwise
    //  Throws:
    //       TSQLException - if a database access error occurs or
    //       row is 0, or result set type is kTYPE_FORWARD_ONLY
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {     
       return_value = rs->absolute(row); 
    
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value  ? fRow->Set(this) : 0;
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::Relative(Int_t rows)
 {
    // Moves the cursor a relative number of rows, either positive or
    // negative. Attempting to move beyond the first/last row in 
    // the result set positions the cursor before/after the the
    // first/last row. Calling Relative(0) is valid, but does not 
    // change the cursor position. 
    //
    //  Note: Calling Relative(1) is different from calling Next() 
    //       because is makes sense to call Next() when there is 
    //       no current row, for example, when the cursor is 
    //       positioned before the first row or after the last row
    //       of the result set.
    //  Returns:
    //       pointer to TSQLRow(kTRUE)  if the cursor is on a row; 
    //       null(kFALSE) otherwise
    //  Throws:
    //       TSQLException - if a database access error occurs, 
    //       there is no current row, or the result set type 
    //       is kTYPE_FORWARD_ONLY
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
    
    try {
       return_value = rs->relative(rows);
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value  ? fRow->Set(this) : 0;
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::Previous()
 {
    // Moves the cursor to the previous row in the result set. 
    //
    //  Note: Previous() is not the same as Relative(-1)
    //       because it makes sense to call Previous()
    //       when there is no current row.
    //
    //  Returns:
    //       pointer to TSQLRow(kTRUE)  if the cursor is on a valid row; 
    //       null(kFALSE) if it is off the result set
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {
       return_value = rs->previous(); 
   
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value  ? fRow->Set(this) : 0;   
 }
 
 //___________________________________________________________________
 TSQLRow* ODBCResultSet::Last()
 {
    // Moves the cursor to the last row in the result set.
    //
    //  Returns:
    //       pointer to TSQLRow(kTRUE)  if the cursor is on a valid row; 
    //       null(kFALSE) if there are norows in the result set
    //
    //  Throws:
    //       TSQLException - if a database access error occurs or 
    //       the result set type is kTYPE_FORWARD_ONLY
 
    Bool_t return_value = kFALSE;
    
    if(!fImp) { Destroyed(); return 0; }
    odbc::ResultSet* rs = (odbc::ResultSet*)fImp;
       
    try {     
       return_value = rs->last();
 
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
       return_value = 0;
    }
    return return_value  ? fRow->Set(this) : 0;
 }
 
 //___________________________________________________________________
 void ODBCResultSet::Close(Option_t * /* option */)
 {
    // Releases this TSQLResultSet object's database and resources
    // immediately instead of waiting for this to happen when it is 
    // automatically closed. 
    //
    // Note: A TSQLResultSet is automatically closed by the 
    // statement that generated it when that statement 
    // is closed, re-executed, or is used to retrieve the next
    // result from a sequence of multiple results. A TSQLResultSet 
    // is also automatically closed when it is garbage collected.
    //
    //  Throws:
    //       TSQLException - if a database access error occurs
   
    if(!fImp) { Destroyed(); return; }
 
    try {       
       if(fMetaData) delete ((ODBCResultSetMetaData*)fMetaData); 
       if(fRow) delete fRow; 
 
       if(fImp) {
          odbc::ResultSet* imp = (odbc::ResultSet*)fImp;  
          delete  imp;
       }
    } catch(odbc::SQLException& e) {
       Throw( new TSQLException( ODBCXX_STRING_CSTR(e.getMessage()),
                                 ODBCXX_STRING_CSTR(e.getSQLState()),
                                 e.getErrorCode()) );
    }
    
    fMetaData = 0;   
    fRow = 0;
    fImp = 0;
    Destroyed();
 }

This page was automatically generated by the 2.3.7 LXR engine. The LXR team