Subject In a Firebird UDF, can you establish a connection back to the database?
Author Steve
Sub: In a Firebird UDF, can you establish a connection back to the
database?


Using: Delphi 2010, Firebird 2.5, UniDac 3.50

I'm writing a Firebird UDF that needs to be able to execute a stored
procedure. The stored procedure is based on a simple SELECT statement.

UniDac data access library is being used for creating a connection back to the database.

However when executing the function in Firebird (after having
successfully declared it in the database), the system freezes.

I am certain that it freezes at the point where the connection to
database is being made.


So my question is:

Is it possible (ie. allowed) for (the code inside) a UDF to establish a connection to the database?