Subject Re: [ib-support] Connect to DB from Procedure ??
Author Helen Borrie
At 09:20 AM 08-08-01 +0100, you 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.

Why?
If your app opens a connection to another DB, why can't it pass parameters from your main database to a stored proc on the other database? I really DON'T recommend a UDF to implement this, especially if you are planning to port it cross-platform.

Helen

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________