I have some stored procedures which merely retrieve data and are being classified as action procedures.

I've read and used this forum post. It correctly solves my problem.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3593

It says to go into the catalog explorer and change it so that the number of resultsets is greater than 1.

This works well.

The only problem now is that everytime I refresh my catalog it puts the stored procedures back into the action procedures. Is there some way to permanently tell LLBLGen that they are retrieval procedures.

Thanks, Brendan

Hi Brendan.

I can't reproduce your issue. Did you changed the parameters of the SP in database before refresh?

What is you LLBLGen version and runtime libraries version? (http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7725)

What's your designer build nr? Please specify the info as stated in the guidelines for this forum, as otherwise we're in the dark and can't help you solve this issue: your problem sounds like a bug which was solved some time ago, but without knowing which version you're using we can't give you proper advice.

Thanks, daelmo.

You're right it only does it when I change the parameters of one of them. I guess that makes sense why it would have to then re-evaluate what type of sproc it is.

Thanks, Brendan