Subject RE: [firebird-support] Changing column type
Author Rick DeBay
I just checked the dependencies table, and the PRODUCTID field is not in
the table, so this won't work. However, trying to delete the field from
the table yields:

Column PRODUCTID from table CLAIMSPAIDREVERSED is referenced in view


-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Wednesday, October 13, 2004 3:59 PM
Subject: Re: [firebird-support] Changing column type

Hello Rick, Milan,

> DBW updates, as far as I can tell, using standard DDL. It was what I
> was using when I got the error.
> I was hoping to avoid the massive recreate :-)

Indeed, Database Workbench only uses standard DDL to update
column types. Doing otherwise might result in data-loss errors.

Rick, in your case, I suggest adding two new columns, one with
the right type and one with the current same type. Transfer the
data. Update RDB$DEPENDENCIES to point to the new column
of the same type. Drop the old column. Rename the new column
with the new type to have the old name, update
RDB$DEPENDENCIES again to hold the old name and drop
the dummy column.

Of course, all after a backup :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
Upscene Productions

Yahoo! Groups Links