查询代码是:
sCmd = "SELECT CondimentGroupID, CondimentGroupName,CondimentGroupName+'^'+cstr(CondimentGroupID) As UsageValue
FROM CondimentGroup"ERROR是:Function masterdata.cstr does not exist.但是在ACCESS数据库下面可以查询.
请问是什么问题?
sCmd = "SELECT CondimentGroupID, CondimentGroupName,CondimentGroupName+'^'+cstr(CondimentGroupID) As UsageValue
FROM CondimentGroup"ERROR是:Function masterdata.cstr does not exist.但是在ACCESS数据库下面可以查询.
请问是什么问题?
Function masterdata.cstr does not exist.
masterdata库中没有Cstr函数
这个错误说cstr函数不存在,
也就是说转换字符串ms sql server 要用cast 而不是cstr
不过也是一个意思,你去查查MYSQL的字符转换函数,改一下也就是了.
sCmd = "SELECT CondimentGroupID, CondimentGroupName,CondimentGroupName+'^'+cstr(CondimentGroupID) As UsageValue
FROM CondimentGroup"
改为:
sCmd = "SELECT CondimentGroupID, CondimentGroupName,conat(CondimentGroupName,'^',cast(CondimentGroupID,char(25))) As UsageValue
FROM CondimentGroup"