SELECT * FROM UDF?

Posts   
 
    
aol
User
Posts: 20
Joined: 24-Aug-2006
# Posted on: 12-Sep-2006 16:20:52   

Hello

I would like to be able to do something like the following:

SELECT * FROM my_udf(param)

using the generated code. Is this possible? I have been searching the forum, and I haven't been able to find out how to do it. I have a feeling that it is not possible, but again, I'm not sure.

Regards Anders

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 12-Sep-2006 17:29:32   

Table udf's aren't supported at the moment, just scalar UDF calls.

Frans Bouma | Lead developer LLBLGen Pro
aol
User
Posts: 20
Joined: 24-Aug-2006
# Posted on: 13-Sep-2006 15:22:57   

Thank you for the answer.

I'm sorry to hear that, but then I will just have to find some other way to solve my problem.

I hope that it is something that will be implemented in a future version.

Regards Anders

Posts: 1268
Joined: 10-Mar-2006
# Posted on: 14-Sep-2006 19:59:45   

You can create a view, then map that view in LLBLGen...

aol
User
Posts: 20
Joined: 24-Aug-2006
# Posted on: 18-Sep-2006 11:50:06   

WayneBrantley wrote:

You can create a view, then map that view in LLBLGen...

That would be nice, but is there a way for me to pass a parameter to the UDF using a view?

Regards Anders

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 18-Sep-2006 18:38:53   

That would indeed be difficult.

Frans Bouma | Lead developer LLBLGen Pro