Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Can't Add New Action Stored Procedure Call
 

Pages: 1
Designer
Can't Add New Action Stored Procedure Call
Page:1/1 

  Print all messages in this thread  
Poster Message
SimonORorke
User



Location:
Wellington, New Zealand
Joined on:
02-Apr-2004 01:43:41
Posted:
20 posts
# Posted on: 14-Jun-2004 00:05:43.  
A stored procedure that I would like to add to LLBLGen Pro does not show in the New Stored Procedures dialogue box when I click Add New Action Stored Procedure Call. I tried Add New Retrieval Stored Procedure Call just in case, but it does not show up there either.

It is a complex stored procedure for sending an email message. There are no result sets, apart from the possibility of an error message output with SQL's PRINT statement: I'm not sure if that counts as a result set or not. Has that got something to do with the problem? I would be quite happy to not capture the error message if there is one: checking the stored procedure's return value for success or failure would be good enough. I could stop the stored procedure from PRINTing error messages, or use SELECT instead of a PRINT, if either of those would solve the problem.

The only other thing I can think of that might be unusual is that the stored procedure calls a hierarchy of other stored procedures, including one that PRINTs the error messages.
  Top
Fishy
User



Location:
Medford, Oregon, USA
Joined on:
15-Apr-2004 00:58:38
Posted:
392 posts
# Posted on: 14-Jun-2004 02:55:09.  
Did you refresh the catalog?

It could be that the purpose of your life is only to serve as a warning to others.  Top
SimonORorke
User



Location:
Wellington, New Zealand
Joined on:
02-Apr-2004 01:43:41
Posted:
20 posts
# Posted on: 14-Jun-2004 05:15:33.  
No, I did not refresh the catalog. But now I can see that I made a stupid mistake. The stored procedure must have been in the New Stored Procedures dialogue box all along, even without refreshing the catalog. I must have missed it because its prefix was being stripped off in the Call Name column. The prefix is the one specified in Pattern to Strip off the Stored Procedure Names in Project Properties.
  Top
DerekLi
User



Location:

Joined on:
08-Aug-2007 20:27:45
Posted:
8 posts
# Posted on: 08-Aug-2007 20:37:34.  
I am using LLBLGen Pro 2.0.0.0 Final (Feb 14th 2007). I notice that the under the Project Menu Item, "Add new Action Stored Procedure Calls", "Add new Retrieval Stored Procedure Calls" and "Add Typed Views from Catalog" menu item are all grayed out. Confused

How can I enable them?

Thanks

Derek


  Top
DerekLi
User



Location:

Joined on:
08-Aug-2007 20:27:45
Posted:
8 posts
# Posted on: 08-Aug-2007 20:41:15.  
Sorry, I forgot to check the Stored Procedure and View on the refresh catalog form. it works fine after I check it and I am able to add stored procedure calls. EmbarrassedLaugh

Derek
  Top
Pages: 1  


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

Version: 2.1.12172008 Final.