Hi,

I have as SP which performs all kind of actions. It includes a cursor and three temptables. In the end I want to retrieve all the records of the last temptable. In my query analysers this look perfect. I get one resultset. But when I want to attach the StoredProc in my LLBLGen project, first I couldn't find it. That was because LLBLGen 'saw' the SP as an action SP instead of a retrieval SP.

How can I make clear that this SP is a retrieval SP instead of an Action SP? I need the resultset. The Action SP only returns an integer value.

In the Catalog Explorer -> browse to the procedure by clicking open catalog -> schema -> stored procedures. THen click open the node of the stored procedure and you should see a node #0. Right-click it and select Change from the context menu. You then can change it to 1 or 2 or another value. (but 1 or 2 are sufficient).

After you've done that, you can add it as a retrieval procedure.

Hint: the Catalog Explorer is usually located on the right side of the window

Hi Walaa,

Thanks for the info. That worked.