Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > FAQ > General FAQ> My Retrieval Procedure is treated like Action Procedure at LLBLGen Pro Designer
 

Pages: 1
General FAQ
My Retrieval Procedure is treated like Action Procedure at LLBLGen Pro Designer
Page:1/1 

  Print all messages in this thread  
Poster Message
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
7920 posts
# Posted on: 08-Dec-2008 05:24:18.  
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.
David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
7920 posts
# Posted on: 28-Feb-2012 03:38:08.  
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).


David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.