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