Class | Sequel::ODBC::Dataset
In: | lib/sequel/adapters/odbc.rb
Parent: | Sequel::Dataset

### Methods

fetch_rows

### Constants

BOOL_TRUE | = | '1'.freeze
BOOL_FALSE | = | '0'.freeze
ODBC_DATE_FORMAT | = | "{d '%Y-%m-%d'}".freeze
TIMESTAMP_FORMAT | = | "{ts '%Y-%m-%d %H:%M:%S'}".freeze

### Public Instance methods

fetch_rows(sql) {|hash| ...}

[Source]

         # File lib/sequel/adapters/odbc.rb, line 95
     95:       def fetch_rows(sql, &block)
     96:         execute(sql) do |s|
     97:           i = -1
     98:           cols = s.columns(true).map{|c| [output_identifier(c.name), i+=1]}
     99:           @columns = cols.map{|c| c.at(0)}
    100:           if rows = s.fetch_all
    101:             rows.each do |row|
    102:               hash = {}
    103:               cols.each{|n,i| hash[n] = convert_odbc_value(row[i])}
    104:               yield hash
    105:             end
    106:           end
    107:         end
    108:         self
    109:       end

[Validate]