stored procedures not recognized as retrievalprocedure

Posts   
 
    
HcD avatar
HcD
User
Posts: 214
Joined: 12-May-2005
# Posted on: 15-May-2006 15:50:13   

Hi,

our application makes use of stored procedures for certain functions, most of them are Actionprocedures, only a few of them Retrieval . This worked quite well untill now. We have a few quite complex procedures (that internally call "exec" on other procedures) that are recognized as ActionProcedure (thus returning no recordset). When we execute the SP in the query analyzer we correctly get the resulting recordset. (some SP's even return more then 1 recordset).
It has something to do with internally calling other SP's i think, because it's these that actually return the recordset ..how can i make LLBL recognized this ?

using: SQL2000 LLBLgen 1.0.2005.1 VS.net 2003

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 16-May-2006 07:41:18   

Please refer to the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3593