Subject | Basic Question - When do you register the UDF? |
---|---|
Author | Phil Scadden |
Post date | 2002-04-30T21:27:21Z |
I have a lot of stored procedures which use one function (bin_xor) from
ib_udf. However I am struggling with when/how I register the function.
At moment, I manually run the ib_udf.sql. However, I am distributing an
application with Firebird embedded in it and really want this function
available. Does the script have to run when Firebird is started on the
machine, or does it have to be run only once. Where is the registration
information stored? In a system table? In that case, can I register it on
a blank database and distribute it with the app (the tables and stored
procedures are created dynamically as required by the app). Help!
thanks for your patience with this basic query.
----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
41 Bell Rd South, PO Box 30368, Lower Hutt, New Zealand
Ph +64 4 5704821, fax +64 4 5704603
ib_udf. However I am struggling with when/how I register the function.
At moment, I manually run the ib_udf.sql. However, I am distributing an
application with Firebird embedded in it and really want this function
available. Does the script have to run when Firebird is started on the
machine, or does it have to be run only once. Where is the registration
information stored? In a system table? In that case, can I register it on
a blank database and distribute it with the app (the tables and stored
procedures are created dynamically as required by the app). Help!
thanks for your patience with this basic query.
----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
41 Bell Rd South, PO Box 30368, Lower Hutt, New Zealand
Ph +64 4 5704821, fax +64 4 5704603