If I make all values to null of that column which is of type varchar and then
go for Alter, would you share the sql for it ?
On Wednesday, 22 April 2015 3:10 PM, "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
On Wed, 22 Apr 2015 09:00:18 +0000 (UTC), "Vishal Tiwari
vishuals...@yahoo.co.in [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
#yiv7283385367 #yiv7283385367 -- #yiv7283385367ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7283385367
#yiv7283385367ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7283385367
#yiv7283385367ygrp-mkp #yiv7283385367hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7283385367 #yiv7283385367ygrp-mkp #yiv7283385367ads
{margin-bottom:10px;}#yiv7283385367 #yiv7283385367ygrp-mkp .yiv7283385367ad
{padding:0 0;}#yiv7283385367 #yiv7283385367ygrp-mkp .yiv7283385367ad p
{margin:0;}#yiv7283385367 #yiv7283385367ygrp-mkp .yiv7283385367ad a
{color:#0000ff;text-decoration:none;}#yiv7283385367 #yiv7283385367ygrp-sponsor
#yiv7283385367ygrp-lc {font-family:Arial;}#yiv7283385367
#yiv7283385367ygrp-sponsor #yiv7283385367ygrp-lc #yiv7283385367hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7283385367
#yiv7283385367ygrp-sponsor #yiv7283385367ygrp-lc .yiv7283385367ad
{margin-bottom:10px;padding:0 0;}#yiv7283385367 #yiv7283385367actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7283385367
#yiv7283385367activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7283385367
#yiv7283385367activity span {font-weight:700;}#yiv7283385367
#yiv7283385367activity span:first-child
{text-transform:uppercase;}#yiv7283385367 #yiv7283385367activity span a
{color:#5085b6;text-decoration:none;}#yiv7283385367 #yiv7283385367activity span
span {color:#ff7900;}#yiv7283385367 #yiv7283385367activity span
.yiv7283385367underline {text-decoration:underline;}#yiv7283385367
.yiv7283385367attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7283385367 .yiv7283385367attach div a
{text-decoration:none;}#yiv7283385367 .yiv7283385367attach img
{border:none;padding-right:5px;}#yiv7283385367 .yiv7283385367attach label
{display:block;margin-bottom:5px;}#yiv7283385367 .yiv7283385367attach label a
{text-decoration:none;}#yiv7283385367 blockquote {margin:0 0 0
4px;}#yiv7283385367 .yiv7283385367bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7283385367
.yiv7283385367bold a {text-decoration:none;}#yiv7283385367 dd.yiv7283385367last
p a {font-family:Verdana;font-weight:700;}#yiv7283385367 dd.yiv7283385367last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7283385367
dd.yiv7283385367last p span.yiv7283385367yshortcuts
{margin-right:0;}#yiv7283385367 div.yiv7283385367attach-table div div a
{text-decoration:none;}#yiv7283385367 div.yiv7283385367attach-table
{width:400px;}#yiv7283385367 div.yiv7283385367file-title a, #yiv7283385367
div.yiv7283385367file-title a:active, #yiv7283385367
div.yiv7283385367file-title a:hover, #yiv7283385367 div.yiv7283385367file-title
a:visited {text-decoration:none;}#yiv7283385367 div.yiv7283385367photo-title a,
#yiv7283385367 div.yiv7283385367photo-title a:active, #yiv7283385367
div.yiv7283385367photo-title a:hover, #yiv7283385367
div.yiv7283385367photo-title a:visited {text-decoration:none;}#yiv7283385367
div#yiv7283385367ygrp-mlmsg #yiv7283385367ygrp-msg p a
span.yiv7283385367yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7283385367
.yiv7283385367green {color:#628c2a;}#yiv7283385367 .yiv7283385367MsoNormal
{margin:0 0 0 0;}#yiv7283385367 o {font-size:0;}#yiv7283385367
#yiv7283385367photos div {float:left;width:72px;}#yiv7283385367
#yiv7283385367photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7283385367
#yiv7283385367photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7283385367
#yiv7283385367reco-category {font-size:77%;}#yiv7283385367
#yiv7283385367reco-desc {font-size:77%;}#yiv7283385367 .yiv7283385367replbq
{margin:4px;}#yiv7283385367 #yiv7283385367ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7283385367 #yiv7283385367ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7283385367
#yiv7283385367ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7283385367
#yiv7283385367ygrp-mlmsg select, #yiv7283385367 input, #yiv7283385367 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7283385367
#yiv7283385367ygrp-mlmsg pre, #yiv7283385367 code {font:115%
monospace;}#yiv7283385367 #yiv7283385367ygrp-mlmsg *
{line-height:1.22em;}#yiv7283385367 #yiv7283385367ygrp-mlmsg #yiv7283385367logo
{padding-bottom:10px;}#yiv7283385367 #yiv7283385367ygrp-msg p a
{font-family:Verdana;}#yiv7283385367 #yiv7283385367ygrp-msg
p#yiv7283385367attach-count span {color:#1E66AE;font-weight:700;}#yiv7283385367
#yiv7283385367ygrp-reco #yiv7283385367reco-head
{color:#ff7900;font-weight:700;}#yiv7283385367 #yiv7283385367ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7283385367 #yiv7283385367ygrp-sponsor
#yiv7283385367ov li a {font-size:130%;text-decoration:none;}#yiv7283385367
#yiv7283385367ygrp-sponsor #yiv7283385367ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7283385367
#yiv7283385367ygrp-sponsor #yiv7283385367ov ul {margin:0;padding:0 0 0
8px;}#yiv7283385367 #yiv7283385367ygrp-text
{font-family:Georgia;}#yiv7283385367 #yiv7283385367ygrp-text p {margin:0 0 1em
0;}#yiv7283385367 #yiv7283385367ygrp-text tt {font-size:120%;}#yiv7283385367
#yiv7283385367ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7283385367
