Is it possible to access data from the database within a UDF?

By: Borland Staff

Abstract: Although it is possible to access data from a UDF, it is not recommended.

Problem:
Is it possible to access data from the database within a UDF?

Solution:
/*******************************************************************************/
Note: The information in this article applies to InterBase v5.x
/********************************************************************************/



Although it is possible to access data from a UDF,  it is not recommended.

The purpose of UDF's is to perform short, discrete non-database operations
on atomic values.   Which is why UDF's have names like upper() and round() or
substr() etc. These operations manipulate the contents of a field and return
an adjusted value. They are often computationally intensive, but all the
data they require is passed as parameters.

If your needs don't fall into the above scenario then UDF's are not likely
to be the solution.

source:listserver

Server Response from: ETNASC03