Subject RE: [firebird-support] Re: Add a field and assign values
Author Gustavo
This is part of an update process that runs when I install a new version of my application. So, if I can't assign values to the new field, I don't want the new field to exist. That's why I want to rollback both the ALTER TABLE and the UPDATE if the second fails.

I know I can simply backup the database before begining the update process, but I wanted to know if I can do it anyway.


----- Mensaje original -----
De: Adam
Enviado: Lunes, 22 de Agosto de 2005 20:37
Asunto: [firebird-support] Re: Add a field and assign values

> I want to do both statements inside the same transaction without
a commit after the first one, because if something goes wrong during
the second statement, I want to rollback the ALTER TABLE too. Is there
a way to do this?

No, nasty things can happen.

Out of curiousity, why would you need to rollback DDL if a DML change
did not go through?



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at



a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]