VB错误,求指导select cangwei,qty,storenu,outofplace from YUCHUKU w
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:英语作业 时间:2024/06/15 11:33:56
VB错误,求指导
select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or cangwei is null or qty=0 or qty='' or qty is null or storenu='' or storenu is null or outofplace='' or outofplace is null)
这句话有问题,报错标准表达式中类型不匹配
谁帮我纠纠错啊
本意是指,从YUCHUKU里查询4列是否有空值,满足条件CHUKUNU=AA123456
上面的问题我自己解决了,
有2张ACCESS表
A表字段有a,b,c,d,e(e是数字)
B表字段有f,g,h,i(i是数字)
现在我想要当A.a=B.f and A.b=B.g and A.c=B.h的时候,A的e字段减去B的i字段,然后更新掉A的e字段.
即最后结果为
A的e=e-i
这句话我要怎么写啊
select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or cangwei is null or qty=0 or qty='' or qty is null or storenu='' or storenu is null or outofplace='' or outofplace is null)
这句话有问题,报错标准表达式中类型不匹配
谁帮我纠纠错啊
本意是指,从YUCHUKU里查询4列是否有空值,满足条件CHUKUNU=AA123456
上面的问题我自己解决了,
有2张ACCESS表
A表字段有a,b,c,d,e(e是数字)
B表字段有f,g,h,i(i是数字)
现在我想要当A.a=B.f and A.b=B.g and A.c=B.h的时候,A的e字段减去B的i字段,然后更新掉A的e字段.
即最后结果为
A的e=e-i
这句话我要怎么写啊
![VB错误,求指导select cangwei,qty,storenu,outofplace from YUCHUKU w](/uploads/image/z/17590494-30-4.jpg?t=VB%E9%94%99%E8%AF%AF%2C%E6%B1%82%E6%8C%87%E5%AF%BCselect+cangwei%2Cqty%2Cstorenu%2Coutofplace+from+YUCHUKU+w)
select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or isnull(cangwei) or qty=0 or isnull(qty) or storenu='' or isnull(storenu) or outofplace='' or isnull(outofplace))
vb双引号的问题strSQL = "select * from 表1 where 编号=" & Val(Text5.Te
select*from ‘ * ’ 的意义?
select * from book limit ,
VB select case is > 2 and is < 5的表示是错误的,正确的应该怎么写?
vb 如select * from a where b=' "+###1+" '的语句怎么写才可以筛选两个词
这语句什么意思select * from [Feedbacks] where QId=3 order by case w
求高手指导用vb编大学物理演示实验
QTY CTNS N.W.G.W.MEAS 、KGS 、
select count(c) from (select b from TUserBankLogSum b group
select * from a union select * from b 能详细说下么
select max(account_id ) from(select top 5 account_id from ac
select count(*) from table1 select count(*) from table2 sele