Question: My retrieval stored procedure are treated like action procedure when refreshing the catalog at LLBLGen Pro Designer. How can I make it Retrieval Procedure?

Solution:

• Open your .lpg file.
• Expand the Catalog Explorer toolbar. This toolbar generally is placed at the right side of the LLBGen Designer.
• Locale your stored procedure and expand it.
• Expand the "Number of resulsets" node.
• Right click at the "#0" node and click "Change value" option. Or press [F2].
• Set the value to 1.

For v3.x the solution is slightly different. There are two options:

A. Let LLBLGen to determine the resulset When refresh your relational model from database, there is a step where you can specify the stored procedures for which the resulset relational data model has to be determined. Select all SP's or just those you want that LLBGen automatically determines the resulset(s). For more info read Relational Model Data Retrieval Wizard.

B. Specify the number of resulsets manually. If you don't want to go on option (A), or if for some reason the resulset info can't be retrieved (i.e. too complex SP), you can specify the number of resulsets manually:

• Open your .llblgenprojh file.
• Expand the Catalog Explorer toolbar. This toolbar is generally placed at the right side of the LLBGen Designer.
• Locate your stored procedure.
• Right click at the SP node and click on 'Select Number of Resulsets' option, then select the appropriate number of resulsets (0, 1, 2 or more).