IB6.0 Bug? ALTER TABLE ALTER Fieldname

Bob McCormick

Delphi Developer

Wed, 01 Sep 2004 04:27:13 GMT

IB6.0 Bug? ALTER TABLE ALTER Fieldname

I need someone to confirm for me of a a bug in IB6.0 and also to determine
if this has been fixed in IB6.5.

If I perform the following statement on a column that has an Integer
datatype before the Alter:

ALTER TABLE PUSH_QUEUE ALTER PATIENT_ID TYPE VARCHAR(15);

It appears that the field gets changed appropriately to a VARCHAR(15), but
it also assigns a value of 17 to $254 domain. If we do a reverse engineer
on this database, the metadata will show a VARCHAR(17) in the resulting
script. NOT GOOD for keep many databases out in the field synched at the
MetaData level.

Anybody seen this and has it been fixed???

Thanks...Bob

Bob McCormick
IST

Craig Stuntz [TeamB

Delphi Developer

Sat, 04 Sep 2004 02:25:36 GMT

Re:IB6.0 Bug? ALTER TABLE ALTER Fieldname

In article <3c92595c$1_1@dnews>, b...@intuitivesoftware.com says...

Quote

> I need someone to confirm for me of a a bug in IB6.0 and also to determine
> if this has been fixed in IB6.5.

Yes, I just tried this and it appears to be fixed in IB 6.5. I
don't have 6.0.2.0 installed anywhere locally so I can't test it there.

-Craig

--
Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
Delphi/InterBase WebLog: http://delphi.weblogs.com
InterBase PLANalyzer (Free IB optimization tool):
http://delphi.weblogs.com/IBPLANalyzer

Other Threads

1. Another IB6.0 Bug? ALTER TABLE ALTER Fieldname POSITION X

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

3. CREATE TABLE vs CREATE TABLE + ALTER TABLE

4. Lock Access table prior to ALTER TABLE

5. altering the table language of an existing table

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

7. Alter table SQL for Paradox tables

8. Using Alter Table To Restructure Paradox Tables

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

10. Cannot alter PDX-Table on HD if Application is on CD-ROM