Hi,

I'm trying to make a query like the following :

SELECT myFields 
FROM myTable 
WHERE MyFieldId = MyFunction(
(SELECT MyOtherId 
FROM MyOtherTable 
WHERE myFields = MyVariable)
)

I don't know how to put a subquery in a DBFunctionCall :

new DBFunctionCall("MyFunction({0})", new object[](??????????????????));

Thanks for your help.

I never tried something like that. What if you pass the query string to the param?

Odd requirement, as the function should do the select, you shouldn't pass in the result of the select to the function. (besides that, the function should accept a parameter but of what type?)

With the query string, it works but I want to make that with LLBLGEN because it's not a good idea to put directly SQL code in my DAL...

Vonziz wrote:

With the query string, it works but I want to make that with LLBLGEN because it's not a good idea to put directly SQL code in my DAL...

Please read my post above. You should have a scalar query which produces the value based on input, and that input is then passed to the function. So the function isn't receiving a set, but does the sql itself.

I have to make this kind of query because i've got a constraint with a clob field.

Before calling my function, i have to convert a string variable (length > 4000) from my Business Layer into a Clob variable in my Oracle side, that's why I use a temporary table and I make a select from this temporary table for my function call.

Any idea to solve this problem with LLGLGEN?

Before calling my function, i have to convert a string variable (length > 4000) from my Business Layer into a Clob variable in my Oracle side, that's why I use a temporary table and I make a select from this temporary table for my function call.

Couldn't this function do the first select and the conversion.....(the entire logic)?

Otherwise I see no other way but to pass the SQL string as the function parameter.

The function can't make that because this is a package of functions from an editor and I can't change any code. That's why my problem is so complex. ^^

Then you'll have to pass pass the SQL string as the function parameter.