RetrievalProcedure - Calling stored procedure issue

Posts   
 
    
Gaurav
User
Posts: 3
Joined: 11-Feb-2011
# Posted on: 11-Feb-2011 08:07:27   

The issue is with RetrievalProcedure.cs generation...

We have few stored procedures created in the DB. Few with schema 'dbo' and few with schema 'Security'.

Now whenever we re-generate LLBL, the RetrievalProcedures.cs generates all the stored procedures with Schema [Security] as prefix. Thus the stored procedures with schema dbo are also set as [Security]. [StoredProcedureName] which is wrong. This is annoying as every time LLBL is generated, one has to take care of changing this code from [Security] to [dbo].

As you can see int the attached file. There are two strored procedures. 1) GetAgedDebtor and 2) GetCustomerTransactionHistory

GetAgedDebtor has schema 'dbo' in DB and GetCustomerTransactionHistory has schema 'Security' in DB.

But both the stored procedures are prefixed with [Security]. GetAgedDebtor should be prefixed with [dbo] and not [Security].

Pls see how could this be resolved.

Attachments
Filename File size Added on Approval
RetrievalProcedureIssue.png 37,274 11-Feb-2011 08:07.45 Approved
Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 11-Feb-2011 08:17:07   

THis sounds like an old bug, which version of the designer/release date are you using?

Gaurav
User
Posts: 3
Joined: 11-Feb-2011
# Posted on: 11-Feb-2011 09:42:45   

Thanks for your quick reply...

I am using LLBLGen Pro v3.0

Regards, Gaurav Garg

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 11-Feb-2011 09:53:11   

Release date please simple_smile Appears in the caption, and in Help->About.

Gaurav
User
Posts: 3
Joined: 11-Feb-2011
# Posted on: 11-Feb-2011 09:55:53   

Version: 3.0 Final Released date: June 8th, 2010

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 11-Feb-2011 10:01:26   

That's an old release. Would you please download the latest and try again.