7,763
社区成员
发帖
与我相关
我的任务
分享看看这个查询语句
Dim Aweight As Single
Aweight = 100.78
select * from s_goods where [重量] > " + Aweight + " order by [型号]"
报告出错：类型不匹配
为什么？
说明：[重量] 类型 single
Aweight = 100.78
select * from s_goods where [重量] > " + Aweight + " order by [型号]"
报告出错：类型不匹配
为什么？
说明：[重量] 类型 single
...全文
请发表友善的回复…
发表回复
nobody_am 2002-07-10
- 打赏
- 举报
原来如此，谢谢各位
griefforyou 2002-07-10
- 打赏
- 举报
在VB中,字符串之间可以用 + 或 & 来连接,但是如果类型不同的话,就要用 &
它自动会将非字符串型转为字符串型!
它自动会将非字符串型转为字符串型!
griefforyou 2002-07-10
- 打赏
- 举报
把+换成 &
Dim Aweight As Single
Aweight = 100.78
select * from s_goods where [重量] > " & Aweight & " order by [型号]"
Dim Aweight As Single
Aweight = 100.78
select * from s_goods where [重量] > " & Aweight & " order by [型号]"
westneverwin 2002-07-10
- 打赏
- 举报
select * from s_goods where [重量] > " + Aweight + " order by [型号]"
改为
select * from s_goods where [重量] > " & Aweight & " order by [型号]"
改为
select * from s_goods where [重量] > " & Aweight & " order by [型号]"
