How to update fields of a table without commit between every ALTER TABLE

Michael Adamovic

Delphi Developer

Sat, 26 Jun 2004 20:12:38 GMT

How to update fields of a table without commit between every ALTER TABLE

Hi there,

I'm using Interbase Server Version 5.6 with Delphi 5 + IBX 4.52.

I try to change the length of a field with the following commands :

ALTER TABLE ADDRESS ADD ADR_TEMP VARCHAR (128)
UPDATE TABLE ADDRESS SET ADR_TEMP=ADR_EMAIL
ALTER TABLE ADDRESS DROP ADR_EMAIL
ALTER TABLE ADDRESS ADD ADR_EMAIL VARCHAR (128)
UPDATE TABLE ADDRESS SET ADR_EMAIL=ADR_TEMP
ALTER TABLE ADDRESS DROP ADR_TEMP

If I don't COMMIT the first command the second command fails with the
errormessage <Conversion error on sting "somestring" >.
If I commit each command everything works fine, but I want to commit the
changes only if all commands do work. Is there a way to do that ?

Thanks in advance ..

Michael Adamovic

Other Threads

1. Add field to a table programatically?(Alter table)

2. CREATE TABLE vs CREATE TABLE + ALTER TABLE

3. Updating a table with a field from another table using Interbase

4. Updating a field from one table from another table

5. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

6. IB6.0 Bug? ALTER TABLE ALTER Fieldname

7. Alter table before an update

8. How to commit Updates to Detail table ?

9. How to commit Updates to Detail table ?

10. Lock Access table prior to ALTER TABLE