Re: return result set in SPs and using MyODBC

2005-08-22 Thread Gleb Paharenko
Hello. Information from this thread might be helpful: http://lists.mysql.com/mysql/187580 Shaghayegh Sahebie <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --] > > > hi all, > how can we have a select satement in an SP?(i want to return

return result set in SPs and using MyODBC

2005-08-22 Thread Shaghayegh Sahebie
hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives the error:"procedure foo can't return a result set in the given c