Hi All!
I've written a database application that requires me to alter procedures and tables within the *.GDB file upon each application upgrade to my clients. I've tried using IBconsole and Interactive sql but I'm looking for a more automatic procedure. Is there perhaps a component that allows me to execute scripts from within delphi? This would allow me to write a simple program to update the database. The delphi query component allows me to do simple select, input and drop commands but as soon as I do something a little more complex such as altering a procedure, it says that it can't recognize the "set term" command as its only part of the isql language.
Sorry for the long winded explanation.
I've written a database application that requires me to alter procedures and tables within the *.GDB file upon each application upgrade to my clients. I've tried using IBconsole and Interactive sql but I'm looking for a more automatic procedure. Is there perhaps a component that allows me to execute scripts from within delphi? This would allow me to write a simple program to update the database. The delphi query component allows me to do simple select, input and drop commands but as soon as I do something a little more complex such as altering a procedure, it says that it can't recognize the "set term" command as its only part of the isql language.
Sorry for the long winded explanation.