Module: AssOle::Snippets::Shared::Query

Defined in:
lib/ass_ole/snippets/shared.rb

Overview

Snippet for worcking with 1C Query object

Instance Method Summary collapse

Instance Method Details

#query(text, temp_tables_manager = nil, **params) ⇒ WIN32OLE

Returns 1C query object

Returns:

  • (WIN32OLE)


67
68
69
70
71
72
73
74
# File 'lib/ass_ole/snippets/shared.rb', line 67

def query(text, temp_tables_manager = nil, **params)
  q = newObject('Query', text)
  q.TempTablesManager = temp_tables_manager || temp_tables_manager()
  params.each do |k,v|
    q.SetParameter(k.to_s,v)
  end
  q
end

#temp_tables_managerWIN32OLE

Returns 1C TempTablesManager

Returns:

  • (WIN32OLE)


78
79
80
# File 'lib/ass_ole/snippets/shared.rb', line 78

def temp_tables_manager
  newObject 'TempTablesManager'
end