for your info, I tried to debug the line in question. rec[:"Nr"] yields a
numerical value. But i have the impression that the where clause only works
with strings, but not with numericals or booleans.
From: P:/OptigemBridge/obdev/03_OptigemBridge/10_Sources/mediator_og_vr.rb
@ line 133 :
128: rec[:job_de] = fields_bemerkung[:job_de]
129: rec[:job_en] = fields_bemerkung[:job_en]
130:
131: # process the visibility
132: visibility = VISIBLE_ROLES["#default"][1]
=> 133: require 'pry';binding.pry
134: visibility_rec =
ogdb.person_category().where(:"Personen-Nr" => rec[:"Nr"]).all
135: visibility_rec = visibility_rec.select { |f|
VISIBLE_ROLES.keys.include? f[:"Kurzname"] } # must be visible at all
136: visibility_rec = visibility_rec.map { |f|
VISIBLE_ROLES[f[:"Kurzname"]] } # determin the visibility
137: visibility_rec = visibility_rec.sort_by { |f| f.first
}.first # sort by the weight and take the strongest
138: visibility = visibility_rec[1] unless
visibility_rec.nil? # take the name
[1] pry(main)>
[2] pry(main)> visibility_rec =
ogdb.person_category().where(:"Personen-Nr" => rec[:"Nr"]).all
Sequel::DatabaseError: WIN32OLERuntimeError: (in OLE method `Execute': )
OLE error code:80040E14 in Microsoft JET Database Engine
Interner Fehler bei OLE-Automatisierung
HRESULT error code:0x80020009
Ausnahmefehler aufgetreten.
from
P:/OptigemBridge/tools_26/Ruby26-x86/lib/ruby/gems/2.6.0/gems/sequel-4.49.0/lib/sequel/adapters/ado.rb:166:in
`method_missing'
Caused by WIN32OLERuntimeError: (in OLE method `Execute': )
OLE error code:80040E14 in Microsoft JET Database Engine
Interner Fehler bei OLE-Automatisierung
HRESULT error code:0x80020009
Ausnahmefehler aufgetreten.
from
P:/OptigemBridge/tools_26/Ruby26-x86/lib/ruby/gems/2.6.0/gems/sequel-4.49.0/lib/sequel/adapters/ado.rb:166:in
`method_missing'
[3] pry(main)> rec[:"Nr"]
=> 16644
[4] pry(main)>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/53b213fd-0598-49cf-9b2f-deba4deae75c%40googlegroups.com.
