Alan McDonald wrote:

>> Alan McDonald wrote:
>>>> I think we do need to be more pro-active in both the PHP driver
>>>> development as
>>>> well as ADOdb.
>>> there's a lot of work, Lester - to make this xml stuff work properly.
>> I think that was the conclusion that the bitweaver guy's came to
>> - just USING
>> it across multiple databases. So THEY decided to avoid it for any
>> database :)
>>
>> While it is a 'standard' ( well actually on of those
>> non-standards since it
>> does not ACTUALLY standardise anything :) ) I still think it's
>> being miss used
>> in many places.
>
> it's not the XML, it's the ADOdb driver. It's just not up to it yet. e.g.
> you need to be able to ALTER TABLE ALTER COLUMN - which FB doesn't support
> (not default values and null flags) so you'd need to turn all that into some
> pretty fine scripting to get the same result. There's probably tons of other
> stuff. I can get DB creation no worries. But upgrading the application is
> real nasty so far.

That was the approach I took with many of the porting attempts.
I built the base database manually, and then simply added scripts rather than
using some of the novel update methods.
I'm going to have similar problems with bitweaver, but at least the R2 base is
a lot easier to build on, converting an R1 Firebird site to R2 would be
painful, which is why I've been using and advising R2 for Firebird :)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird Foundation Inc. - http://www.firebirdsql.org/index.php