Damian Dowling wrote:

>
> At 07:44 08/08/2001, you wrote:
> >Is there a reason why you can't have your application make a connection to
> >the other database through the client, as usual?
> >
> >regards,
> >Helen
>
> I need to be able to log updates to another DB and was hoping to do it in
> Stored Procedures - it would make the solution more portable to other
> server platforms. Looks like i am stuck with UDFs.
>

I wasn't actually being serious when I suggested using a UDF.

Using a UDF is not the way to handle logging. The connection (and txn)
for a UDF is outside the transaction control of the main application.
Have you thought about how you will handle rollbacks? And what about
the performance drag of instantiating a connection every time?

If you need this sort of logging I would suggest that you investigate
http://www.iblogmanager.com. Alternatively, for a 'fuller' solution,
IBReplicator from http://http://www.replication.co.za would work -
although it is designed as an industrial strength replication solution,
so might be more than you need.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further