On Thursday, March 20, 2014 3:44:55 PM UTC-7, Hillary Hueter wrote:
>
> In order into insert into a table i need to be able to set the following
> settings:
>
> SET QUOTED_IDENTIFIER ON
>
> SET ANSI_NULLS ON
>
> I've been looking through the documentation for both the sequel adaptor
> and tinytds, but i don't see a way to set this either within the insert
> statement or globally (preferred).
>
>
>
You want to do this in an after connect proc:
DB = Sequel.connect(..., :after_connect=>lambda{|c| c.execute('SET QUOTED
IDENTIFIER ON'); c.execute('SET ANSI_NULLS ON')})
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
