Subject Re: [ib-support] Re: Connect to DB from Procedure ??
Author Damian Dowling
OK - I should have put more though into my last email, i will try to
explain the situation.

I have a problem, but because of a Nondisclosure Agreement i cannot discuss
the design outside of the dev group, so i am going to try to explain the
problem without explaining the design, here goes.

We have Database A - changes to A will require that changes are made to
Databases B, C, D, .......... etc. Our program will be used to make the
changes to Database A, but there are 3rd party programs that can make
changes to Database A.

The problem is that Databases B, C, D, etc must be updated no matter the
source of the changes to Database A. I had hoped that it could be done in
Stored Procedures as it would make rollbacks easier.

I think that the only solution is to use a UDF.

Thanks - and sorry for the confusion.

Damian Dowling
IT Manager
Pallas Foods Ltd

Phone: + 353 69 20200
Fax: + 353 69 20201
Email: it-manager@...