class tibdatabase {
 friend class tibquery;
 protected:
  char * DatabaseName;
  isc_db_handle           DB;                   /* database handle */ 

// ---------------------
 
  char *  dpb;
  char dpb_buffer[ 256 ];
  short dpb_length;
  long status[ 20 ];
  string *LastError;
//  string *tables  //<- to do
// ---------------------
 
 public:

  long sql_code;

  tibdatabase();
  virtual ~tibdatabase();
  virtual void connect(char *aDataBaseName, char * user, char * password, char *role);
  virtual void reconnect();
  virtual void disconnect();
  virtual char * lasterror() {return *(*LastError);}
  virtual void print_table_names();
};

class tibquery {
 protected:
  tibdatabase *db;
  isc_stmt_handle         stmt;                 /* statement handle */ 
  isc_tr_handle           trans;                /* transaction handle */ 
  XSQLDA    ISC_FAR *     sqlda;
  string *LastError;

  long status[ 20 ];
  long statement_type;

  int selected;
  char *databuf;
  unsigned int bsize;

  unsigned int dsqlsize;

  int get_field_idx(char *name);

 public:
  long sql_code;
  char *dsql;
//  long op_code;
  virtual int fetch();
  tibquery(tibdatabase * DataBase);
  virtual ~tibquery();
  virtual void set_database(tibdatabase * DataBase);
  virtual int runQuery(char * mask,...);
  virtual char * lasterror() {return *(*LastError);}
  virtual  XSQLDA * getsqlda() {if (!selected) return NULL;else return sqlda;}
  virtual  int get_column_info(struct columninfo *buf,int no);
  virtual  int get_column(struct ibcolumn *buf,int no);

  virtual  int get_fields_count() {if (!selected) return - 1 ; else return sqlda->sqld;}

  virtual long getByIdxAsInteger(int);
  virtual  long getByNameAsInteger(char *);

  virtual  double getByIdxAsNumber(int);
  virtual  double getByNameAsNumber(char *);

  virtual  char * getByIdxAsString(int);
  virtual  char * getByNameAsString(char *);

  virtual  time_t getByIdxAsTimestamp(int);
  virtual  time_t getByNameAsTimestamp(char *);

  virtual  timeval getByIdxAsTimestamp2(int);
  virtual  timeval getByNameAsTimestamp2(char *);

  virtual int print_blob(char *,int);

  virtual int isnull(char * field);
  virtual int isnull(int idx);

// -------------------------------------------
 
};