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/-/y3XgeQgUrB8J. 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.
