TODBCStatement

class TODBCStatement : public TSQLStatement

    protected:

           Bool_t BindColumn(Int_t ncol, short sqltype, unsigned int size)
           Bool_t BindParam(Int_t n, Int_t type, Int_t size = 1024)
      long double ConvertToNumeric(Int_t npar)
      const char* ConvertToString(Int_t npar)
           Bool_t ExtractErrors(short retcode, const char* method)
             void FreeBuffers()
            void* GetParAddr(Int_t npar, Int_t roottype = 0, Int_t length = 0)
           Bool_t IsParSettMode() const
           Bool_t IsResultSet() const
             void SetNumBuffers(Int_t isize, Int_t ilen)

    public:

                          TODBCStatement(SQLHSTMT stmt, Int_t rowarrsize, Bool_t errout = kTRUE)
                          TODBCStatement(const TODBCStatement&)
                  virtual ~TODBCStatement()
           static TClass* Class()
             virtual void Close(Option_t* = "")
            virtual Int_t GetBufferLength() const
         virtual Double_t GetDouble(Int_t npar)
      virtual const char* GetFieldName(Int_t nfield)
            virtual Int_t GetInt(Int_t npar)
           virtual Long_t GetLong(Int_t npar)
         virtual Long64_t GetLong64(Int_t npar)
            virtual Int_t GetNumAffectedRows()
            virtual Int_t GetNumFields()
            virtual Int_t GetNumParameters()
      virtual const char* GetString(Int_t npar)
           virtual UInt_t GetUInt(Int_t npar)
        virtual ULong64_t GetULong64(Int_t npar)
          virtual TClass* IsA() const
           virtual Bool_t IsNull(Int_t)
           virtual Bool_t NextIteration()
           virtual Bool_t NextResultRow()
          TODBCStatement& operator=(const TODBCStatement&)
           virtual Bool_t Process()
           virtual Bool_t SetDouble(Int_t npar, Double_t value)
           virtual Bool_t SetInt(Int_t npar, Int_t value)
           virtual Bool_t SetLong(Int_t npar, Long_t value)
           virtual Bool_t SetLong64(Int_t npar, Long64_t value)
           virtual Bool_t SetNull(Int_t npar)
           virtual Bool_t SetString(Int_t npar, const char* value, Int_t maxsize = 256)
           virtual Bool_t SetUInt(Int_t npar, UInt_t value)
           virtual Bool_t SetULong64(Int_t npar, ULong64_t value)
             virtual void ShowMembers(TMemberInspector& insp, char* parent)
           virtual Bool_t StoreResult()
             virtual void Streamer(TBuffer& b)
                     void StreamerNVirtual(TBuffer& b)

Data Members

    protected:

                              SQLHSTMT fHstmt                
                                 Int_t fBufferPreferredSize  
      TODBCStatement::ODBCBufferRec_t* fBuffer               
                                 Int_t fNumBuffers           
                                 Int_t fBufferLength         number of entries for each parameter/column
                                 Int_t fBufferCounter        used to indicate position in buffers
                       unsigned short* fStatusBuffer         
                                 Int_t fWorkingMode          1 - setting parameters, 2 - reading results, 0 - unknown
                          unsigned int fNumParsProcessed     contains number of parameters, affected by last operation
                          unsigned int fNumRowsFetched       indicates number of fetched rows

________________________________________________________________________

  SQL statement class for ODBC

  See TSQLStatement class documentation for more details

________________________________________________________________________

constructor

destructor

 Close statement

 process statement

get number of affected rows

 Store result of statement processing.
 Results set, produced by processing of statement, can be stored, and accessed by
 TODBCStamenet methoods like NextResultRow(), GetInt(), GetLong() and so on.

return number of fields

return field name

next result row

 Extract errors, produced by last ODBC function call

run next iteration

return number of parameters

set number of buffers

 Free allocated buffers

 Bind result column to buffer. Allocate buffer of appropriate type

 Bind query parameter with buffer. Creates buffer of appropriate type

 Get parameter address

convert to numeric type

convert to string

 Verifies if field value is NULL

get parameter as integer

get parameter as unsigned integer

get parameter as Long_t

get parameter as Long64_t

get parameter as ULong64_t

get parameter as Double_t

get parameter as string

 Set NULL as parameter value
 If NULL should be set for statement parameter during first iteration,
 one should call before proper Set... method to identify type of argument for
 the future. For instance, if one suppose to have double as type of parameter,
 code should look like:
    stmt->SetDouble(2, 0.);
    stmt->SetNull(2);

set parameter as Int_t

set parameter as UInt_t

set parameter as Long_t

set parameter as Long64_t

set parameter as ULong64_t

set parameter as Double_t

set parameter as string