Subject Re: [firebird-php] Re: Can you run an sql script from php?
Author Lester Caine
Lutz Br├╝ckner wrote:
> willogibbo wrote:
>>One thing I can't figure is how you handle creating a trigger or
>>stored procedure with an sql statement i.e. where you have semi colons
>>in the body of what you're creating. Also how do you cope with the
>>'SET TERM' top and tail?
> there is no way to create/alter triggers or stored procedures via php's
> firebird api, or at least I didn't found one. In ibWebAdmin the isql
> commandline tools is called for this tasks.

I'm building the triggers quite happily in the bitweaver installer using
ADOdb. I have not ACTUALLY checked what happens with PHP4, but PHP5 is
running quite happily, and converts an AUTO field definition to create a
generator, trigger and the correct field set. Not tried SP, but the
CREATE TRIGGER should not be any different?

Lester Caine
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.