Hello I'm running LLBL 2.5. I have a sp that is run a dynamically generated sql statement. The sp is basically exec('Select * from foo') - there is some business logic before it to get the select just right - but I can't get LLBL to recognize this sql - I look at the schema browser and it sees but thinks it has 0 result sets. And when the GUI does add it it wants to do so as an Action procedure. Any ideas?
Please go to the Catalog Explorer (in the right side of the screen), and navigate to the specified SP, click open the Amount Resultsets node, you'll see '#0', select it, RightClick-> alter it and set it to 1 or 2.
