Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> Return Temporary Tables from LLBLGen
 

Pages: 1
LLBLGen Pro Runtime Framework
Return Temporary Tables from LLBLGen
Page:1/1 

  Print all messages in this thread  
Poster Message
Viresh
User



Location:
Ahmedabad, India
Joined on:
28-Jan-2008 08:52:54
Posted:
31 posts
# Posted on: 24-Jul-2008 12:24:47.  
Hi,

I'm having one stored procedure which is something like following:

CREATE PROCEDURE [dbo].[TEST]
@TESTID INT
AS
BEGIN

        CREATE TABLE #TMP        
                                (
                 A DATETIME null

        )

        
        SELECT * FROM #TMP

        DROP TABLE #TMP
END

As you can see, it returns temporary table from SP. Now when I generate DAL using LLBL it's showing this Sp as ActionStoredProcedure instead of Retrieval. I want to use this as Retrieval. Please guide me what's wrong?

Regards,

Viresh Shah
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14572 posts
# Posted on: 24-Jul-2008 14:29:27.  
In the LLBLGen Pro Designer, go to the catalog explorer (in the far right side of the screen) -> 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.


  Top
Viresh
User



Location:
Ahmedabad, India
Joined on:
28-Jan-2008 08:52:54
Posted:
31 posts
# Posted on: 24-Jul-2008 14:40:19.  
Thanks Walaa. It worked. :-)
Regards,

Viresh Shah
 
Top
Pages: 1  


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

Version: 2.1.12172008 Final.