我查询access数据库下面这条语句在access里好用有结果SELECT sum(m.sss) as zhzh FROM [SELECT DISTINCT yfk as sss FROM T_htb WHERE ( htid like 1234)]. AS m到了VB里面我换成的变量传入同样的值为什么就查询不出结果了?SELECT sum(m.sss) as zhzh FROM [SELECT DISTINCT yfk as sss FROM T_htb
WHERE ( htid like ' " & chHth & " ')]. AS m我用Text1.text=Rs!zhzhRs!zhzh的值是null这是怎么回事?
WHERE ( htid like ' " & chHth & " ')]. AS m我用Text1.text=Rs!zhzhRs!zhzh的值是null这是怎么回事?
而你在 Like 后面用了单引号,成文本型了
数据类型不符合
如果是是integer或long,则好像不用双引号
请帮忙谢谢
有什么区别??
谢谢
'%" & chHth & "%'"
" & Trim(chhth) & "和' " & trim(chHth) & " '
有什么区别??
谢谢