大家好,请看下面vb语句
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '"& -% &"' and AccountNo_mc<'" & 3999& "'"
为什么系统提示 :编译错误,% 无效的字符
我有把上面的语句改为:
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '"& - &"%' and AccountNo_mc<'" & 3999& "'"
为什么系统提示 :编译错误,& 缺少表达式我有把上面的语句改为:
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '& - &%' and AccountNo_mc<'" & 3999 & "'"
虽然系统不报错,但得到的结果是NULL
请大家帮忙呀!
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '"& -% &"' and AccountNo_mc<'" & 3999& "'"
为什么系统提示 :编译错误,% 无效的字符
我有把上面的语句改为:
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '"& - &"%' and AccountNo_mc<'" & 3999& "'"
为什么系统提示 :编译错误,& 缺少表达式我有把上面的语句改为:
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '& - &%' and AccountNo_mc<'" & 3999 & "'"
虽然系统不报错,但得到的结果是NULL
请大家帮忙呀!
数值
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '& - &%' and AccountNo_mc<3999 "
字符
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '& - &%' and AccountNo_mc<'3999' "
2.有符合条件的记录么?
Setup_SQL = "select sum(Balance) from Set_up_Balance_sheet_items_child_info where Balance like '& cc &%' and AccountNo_mc<3999 "