On Fri, Jan 14, 2011 at 2:57 AM, Petr Jakeš <petr.jakes@tpc.cz> wrote:
Yes  we are using addColumn method and it works great (Firebird SQL). 

The other question still remains: "How to find if the table was updated already". We are maintaining hundreds of the databases with the same structure on different machines and we were not sure where the table was already updated and where not.

The code I listed is more complicated, but it's mainly there to achieve a similar goal (it has a few more tricks though). Yours might be better, as a matter of programming philosophy: yours is "it's better to ask forgiveness" while mine is "look before you leap".


Imri Goldberg
http://plnnr.com/ - automatic trip planning
-- insert signature here ----