Subject Re: Updating databases
Author afoc_nz
--- In ib-support@yahoogroups.com, Milan Babuskov <albis@e...> wrote:
> afoc_nz wrote:
> > I am creating an application (in Java) and need a method of updating
> > the database (i.e. changing table structure add /removing triggers
etc).
> >
> > Most of this sort of stuff is simple to manage through JDBC with
> > simple SQL statements. What has got me stuck is how to create
> > triggers/procedures from within the application. Every thing I've
> > tried so far has resulted in "token unknown" errors.
> >
> > Has anyone been able to do this sort of thing? If so, how???
>
> I don't know about Java, but I do it with PHP all the time. Can you
post
> some of the statements that failed?
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net

Thanks for the offer, but I've just managed to fix it. I got
frustrated enough to go over all of the code that I used to generate
the DDL for all the differenct objects (e.g. tables, generators,
triggers etc) and found a glitch in one of my classes. I think I'll
go and hide in the corner now...