sybase中数据类型转换问题

zxp19821005

tcc表中， dir、downtilt_electr和ANT_total_under_ANGLE等字段为float型。
1、执行以下语句时
update tcc set dir =convert(float,45),downtilt_electr =convert(float,4),ANT_total_under_ANGLE =convert(float,4)
提示：
Number (257) Severity (16) State (1) Server (BOCODT) Implicit conversion from datatype 'FLOAT' to 'VARCHAR' is not allowed.  Use the CONVERT function to run this query.
          
2、执行以下语句时
update tcc set dir =45,downtilt_electr =4,ANT_total_under_ANGLE =4
提示：
Number (257) Severity (16) State (1) Server (BOCODT) Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed.  Use the CONVERT function to run this query.

3、执行以下语句时
update tcc set dir =cast(45 as float),downtilt_electr =cast(4 as float),ANT_total_under_ANGLE =cast(4 as float)       
提示：
Number (257) Severity (16) State (1) Server (BOCODT) Implicit conversion from datatype 'FLOAT' to 'VARCHAR' is not allowed.  Use the CONVERT function to run this query.

请问各位大虾，我该如何写这个语句？   

Eisen

update tcc set dir =convert(varchar(10),convert(float,45)),downtilt_electr =convert(varchar(10),convert(float,4)),ANT_total_under_ANGLE =convert(varchar(10),convert(float,4))

zxp19821005

Eisen 发表于 2012-05-14 17:25
update tcc set dir =convert(varchar(10),convert(float,45)),downtilt_electr =convert(varchar(10),conv ...

不行啊，大虾~~~
1        Number (257) Severity (16) State (1) Server (BOCODT) Implicit conversion from datatype 'VARCHAR' to 'FLOAT' is not allowed.  Use the CONVERT function to run this query.          
2         (42000)          
3        Number (257) Severity (16) State (1) Server (BOCODT) Implicit conversion from datatype 'VARCHAR' to 'FLOAT' is not allowed.  Use the CONVERT function to run this query.          
4         (42000)          

baiynije

先弄清楚你要更新字段的數據類型，再做相應的轉換。

zxp19821005

对不起了 各位大虾~~~
是我自己搞错了~~~
前两个字段是float，最后一个是varchar~~~
谢谢各位了~~~