Class DBI::DBD::ODBC::Statement
In: lib/dbd/odbc/statement.rb
Parent: DBI::BaseStatement

Methods

bind_param   cancel   column_info   convert_row   execute   fetch   fetch_scroll   finish   new   rows  

Public Class methods

Public Instance methods

bind_param(param, value, attribs)

See DBI::BaseStatement#bind_param. This method will also raise DBI::InterfaceError if param is not a Fixnum, to prevent incorrect binding.

column_info()

See DBI::BaseStatement#column_info. These additional attributes are also supported:

  • table: the table this column came from, if available.
  • nullable: boolean, true if NULL is accepted as a value in this column.
  • searchable: FIXME DOCUMENT
  • length: FIXME DOCUMENT
  • unsigned: For numeric columns, whether or not the result value is signed.
fetch_scroll(direction, offset)

See DBI::BaseStatement#fetch_scroll.

ODBC has a native version of this method and the constnats in the ODBC driver themselves are supported. If you‘d prefer to use DBI constants (recommended), you can use these which map to the ODBC functionality:

  • DBI::SQL_FETCH_FIRST
  • DBI::SQL_FETCH_LAST
  • DBI::SQL_FETCH_NEXT
  • DBI::SQL_FETCH_PRIOR
  • DBI::SQL_FETCH_ABSOLUTE
  • DBI::SQL_FETCH_RELATIVE
rows()

See DBI::BaseStatement#rows.

For queries which DBI::SQL.query? returns true, will explicitly return 0. Otherwise, it will return the row processed count.

Private Instance methods

convert_row(row)

convert the ODBC datatypes to DBI datatypes

[Validate]