数据库:sql server
表: table1
字段1: priceA 类型: money
字段2: priceB 类型: smallmoney sql 语句:
'update table1 set priceA='''+edit1.text+''',priceB='''+edit2.text+''''
执行这个sql语句后出错:
Disallowed implicit conversion from data type varchar to data type money......
Disallowed implicit conversion from data type varchar to data type smallmoney......我知道是sql语句类型处理的问题,但是如何写这个语句呢?谢谢!
表: table1
字段1: priceA 类型: money
字段2: priceB 类型: smallmoney sql 语句:
'update table1 set priceA='''+edit1.text+''',priceB='''+edit2.text+''''
执行这个sql语句后出错:
Disallowed implicit conversion from data type varchar to data type money......
Disallowed implicit conversion from data type varchar to data type smallmoney......我知道是sql语句类型处理的问题,但是如何写这个语句呢?谢谢!
'update table1 set priceA='+edit1.text+',priceB='+edit2.text;或者你用参数方式吧:
sqltext := 'update table1 set priceA=:pricea,priceB=:priceb';
...
query.parambyname('pricea').ascurrency := strtofloat(edit1.text);
query.parambyname('priceb').ascurrency := strtofloat(edit2.text);
query.execsql;
....