Re: [SQLObject] Altering/updating a database

[Imri G. <lor...@gm...>]

On Fri, Jan 14, 2011 at 2:57 AM, Petr Jakeš <pet...@tp...> 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".

Cheers,
Imri

-- 
Imri Goldberg
--------------------------------------
http://plnnr.com/ - automatic trip planning
http://www.algorithm.co.il/blogs/
--------------------------------------
-- insert signature here ----