| Subject | Re: [firebird-support] How To Change Column DataType From Varchar To Integer ? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2015-04-22T09:40:12Z |
On Wed, 22 Apr 2015 09:00:18 +0000 (UTC), "Vishal Tiwari
vishualsoft@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
conversion isn't done at ALTER time, but when the field is queried or
updated. This means that Firebird cannot ensure that current values are
convertible to INTEGER, and therefor the conversion is not allowed.
Mark
vishualsoft@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
> Is there no Alter like SQL available ?There is, but it doesn't support conversion from (VAR)CHAR to INTEGER. The
conversion isn't done at ALTER time, but when the field is queried or
updated. This means that Firebird cannot ensure that current values are
convertible to INTEGER, and therefor the conversion is not allowed.
Mark