Hi,

Before I want to implement it, I would like to know if llblgen pro handles stored procedures returning variable amount of recordsets back. I mean, in the LLBLGen application you can type the amount of recordsets the SP returns, does this really matter?

Based on usersettings the sp can return from 4 up to 10 recordsets... Since in the code the function will just return a dataset in that case, I just want to know the importance of the amount of recordsets returned...

Gr.,

G.I.

Just make sure the # of resultset is set to 2 or higher in the catalog explorer and it should be fine. (on sqlserver, on oracle you have a fixed # of return sets, one per output ref cursor parameter)

Thanks, it's working perfectly (using MS SQL Server)