What is the proper way to call a UDF and get the result in ELEVATEDB? Not in a script, but
straight from the application. I must use TEDBQuery like this for example:

select MyFunction('parameter') as result
FROM Configuration.DataTypes
WHERE NAME = 'Char'

to be able to get the result or is there another way?

Thanks.

Dan


All I've done in mine is specify the result type. Is this external function delphi or sql?

Roy Lambert [Team Elevate]

Dan,

<< What is the proper way to call a UDF and get the result in ELEVATEDB? Not
in a script, but straight from the application. I must use TEDBQuery like
this for example:

select MyFunction('parameter') as result
FROM Configuration.DataTypes
WHERE NAME = 'Char'

to be able to get the result or is there another way? >>

Perhaps you can tell us more about what you're trying to accomplish.  The
above technique is correct, but it sounds like you want to simply call the
function without using it in a query, etc.  Is that correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

<<Perhaps you can tell us more about what you're trying to accomplish.  The
above technique is correct, but it sounds like you want to simply call the
function without using it in a query, etc.  Is that correct ?>>

Yes, i'm just curious it this is the only way to call a function without using it in a query.

Of cource, as a alternative we can use a procedure with out parameters and TEDBStoredProc,
but is there another way to simply use a function?

Dan,

<< Yes, i'm just curious it this is the only way to call a function without
using it in a query. >>

Yes, from a client application.

<< Of cource, as a alternative we can use a procedure with out parameters
and TEDBStoredProc, but is there another way to simply use a function? >>

No, that's pretty much it (procedure call with out parameter).

--
Tim Young
Elevate Software
www.elevatesoft.com