Just try it out in your favourite ISQL tool ... Alter Table MyTable Alter MyIntField Type WhatEver;
If it doesn't work, then ... 1. Alter Table and Add a new column 2. copy the data from int col to new col 3. drop the int col 4. reposition the new column.
May be possible in one small script.
Cheers, Craig.
Tracey Maule wrote:
Hi
It seems it is not possible to modify a field type (from integer to decimal) in interbase (firebird) without dropping the field and adding it.
Is this correct?
Tracey
Software Developer / Web Master
Logis
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
(027) 213-1065
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
