高考问答忍者神龟3李奥纳多演员:VB中进行SQL查询
来源：百度文库 编辑：高考问答 时间：2024/04/28 03:12:57
rs.Open "select * from registrecords where registor='" & Trim(txtemployeeid.Text) & "' and registtime>'" & dtpfrom.Value & "' and registtime<'" & dtpto.Value & "'", conn, adOpenStatic, adLockReadOnly
因registtime是日期时间型,所以查询结果中没有dtpto.value(格式属性为shortdate)这天的,
我把上句改为rs.Open "select * from registrecords where registor='" & Trim(txtemployeeid.Text) & "' and registtime>'" & dtpfrom.Value & "'and registtime<'" & dateadd(day,1,dtpto.Value) & "'", conn, adOpenStatic, adLockReadOnly
查询是显示错误信息框"参数不可选"!
那这语句应怎么改才符合查询要求?
因registtime是日期时间型,所以查询结果中没有dtpto.value(格式属性为shortdate)这天的,
我把上句改为rs.Open "select * from registrecords where registor='" & Trim(txtemployeeid.Text) & "' and registtime>'" & dtpfrom.Value & "'and registtime<'" & dateadd(day,1,dtpto.Value) & "'", conn, adOpenStatic, adLockReadOnly
查询是显示错误信息框"参数不可选"!
那这语句应怎么改才符合查询要求?
select * from A where 唯一字段 not in (select 唯一字段 from B)