OK - thanks Jeremy. I'll look into Database#synchronize as you mention.
Thanks again, Stu On Tuesday, 2 October 2012 18:20:03 UTC+1, Jeremy Evans wrote: > > On Tuesday, October 2, 2012 3:11:02 AM UTC-7, Stu Gray wrote: > >> Hi all, >> >> I asked this question on Stack Overflow yesterday, but maybe it's better >> to come direct to you guys. >> >> In MS SQL Server a stored procedure can return an integer value called a >> return >> code<http://msdn.microsoft.com/en-us/library/ms190778%28v=sql.105%29.aspx> >> to >> indicate the execution status of a procedure. >> >> Does Sequel support this? >> >> The value returned from my_stored_proc.call() does not match the integer >> I am returning in SQL. Is there some other way to access this? >> >> Thanks! >> >> Stu >> >> >> http://stackoverflow.com/questions/12674874/stored-procedure-return-codes-in-sequel-ruby-orm >> >> >> > Unfortunately, Sequel's support for stored procedures is fairly limited. > I don't believe it supports return codes or in/out variables. It's > designed similarly to the prepared statement support, where delete/update > returns the number of affected rows, and select yields rows. > > If Sequel's support doesn't meet your needs, use Database#synchronize to > get to the underlying database connection, and operate directly on that > using the connection's API (which depends on the driver in use). > > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/nau4BO1IpywJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
