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.

Gustavo

----- Mensaje original -----
De: Adam
Para: firebird-support@yahoogroups.com
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?

Adam





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

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

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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


------------------------------------------------------------------------------




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