HnD | It thinks a retrieval is an action, Page 1

It thinks a retrieval is an action

Posts

Ian
User

Posts: 511
Joined: 01-Apr-2005

# Posted on: 29-Apr-2006 00:03:44

Hi,

I have a sp which LLBLGen designer is convinced is an action proc when it is in fact a retrieval proc. The sp is SELECT'ing from a table variable. That's a retrieval isn't it?

Cheers, I.

bclubb
User

Posts: 934
Joined: 12-Feb-2004

# Posted on: 29-Apr-2006 02:32:01

Can you post the sp and which DB you are using? As long as you are returning a resultset it should be recognized as a retrieval.

JimHugh
User

Posts: 191
Joined: 16-Nov-2005

# Posted on: 29-Apr-2006 19:25:26

You can change the number of resultsets in the Catalog Explorer which will automatically change the type from action to resultset.

See the following thread:

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