Subject Re: [firebird-php] Calling php function from sql
Author Lester Caine
Uwe Grauer wrote:

> I wouldn't try something like Php as UDF.
> A UDF is just for small thinks you can't do with internal Functions.
> What are you trying to do?

The PHP library of functions can be made available just as if they were
Firebird built in functions. So some of the date handling or string
processing functions could be used in an SQL statement. It's not
something that should be too difficult to do, and I think Ard was
heading that way. So when a port of an application from another engine
needs some 'funny' function, it's probably already available in the PHP
library and we can use it.

> How to open a Transaction for diferent connections:
> Pseudocode:
> con1.StartTransaction()
> con2.StartTransaction()
> Transactions work on connections.
> So what are your Problems?

Anatol is looking for two phase commit, where the transaction covers
both connections. Not something I've tried myself.
Apparently there is a problem when you add the second connection to
ibase_trans :(

Lester Caine
L.S.Caine Electronic Services