On Sunday, January 12, 2020 at 1:53:23 PM UTC-8, Bernhard Weichel wrote: > > 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. >
Incorrect, you can use a string, numeric, boolean as the value in a hash passed to Dataset#where (pretty much any value that Sequel can convert to SQL will work). You mentioned things didn't work with Sequel 4.49 either, but your backtrace shows use of Ruby 2.6, when you mentioned originally running your application with Ruby 1.9.3. Try using Sequel 4.49 with Ruby 1.9.3 and see if it works. If it works with Ruby 1.9.3 and not with Ruby 2.6, this is a Ruby issue and not a Sequel issue. If you continue to have problems, please create a minimal self-contained example showing the problem you are having, along with an SQL log. I do have access to Microsoft Access and should be able to debug the issue if you produce a minimal self-contained example. Thanks, Jeremy -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/348cc1e5-ebf2-4d43-93f5-bf562388062e%40googlegroups.com.
