My_Query = ""
If Not txtName.Text = "" Then My_Query = My_Query & " 姓名 like " & "( '" & txtName.Text & "%')"
If Not cmbSex.ListIndex = -1 Then My_Query = My_Query & " AND 性别 =" & " '" & cmbSex.Text & "'"
adoQuery.RecordSource = "SELECT * FROM 专家资料 WHERE " & My_Query & " ORDER BY ID"
用上面的查询,当只输入姓名时没有问题,但同时输入性别就会报错,什么没有操作苻之类得。
多种条件综合查询要怎么做啊!哪位大侠给个范例好么!
If Not txtName.Text = "" Then My_Query = My_Query & " 姓名 like " & "( '" & txtName.Text & "%')"
If Not cmbSex.ListIndex = -1 Then My_Query = My_Query & " AND 性别 =" & " '" & cmbSex.Text & "'"
adoQuery.RecordSource = "SELECT * FROM 专家资料 WHERE " & My_Query & " ORDER BY ID"
用上面的查询,当只输入姓名时没有问题,但同时输入性别就会报错,什么没有操作苻之类得。
多种条件综合查询要怎么做啊!哪位大侠给个范例好么!
解决方案 »
- 应用程序的宏为标准exe程序,思路?
- 50分在线问:data Report控件中能对Label标签控件赋值吗?
- 关于较复杂存储过程,如何执行并返回VB中MSHFLEXGRID控件中显示结果?
- 看看!看不看随你!!!!!!!!!
- 关于base64编码的问题
- VB打印
- 关于记录集,这个问题我不清楚,还望高手指点!!!!!!!
- 为什么一个控件在我的程序中显示宽度300,在别人的程序中只显示宽度几十???是哪个属性决定的?谢!
- 急:8004005:缺少更新或刷新的键列信息。
- 在VisData中正常通过但在程序中不能通过,为什么
- 高分求Addflow 4.2 版本 控件正式版 哪位有啊。分不够再加。
- 刚用VB的一个小问题,求大家帮帮忙!挺急的!在线等!
"select * from d_log where b_dhhm='" & rz_b_dhhm & "' and b_rq='" & v_day & "' and b_receive_time='" & rz_b_receive_time & "' and b_dzzs='" & rz_b_dzzs & "'"rz_b_dhhm,v_day,rz_b_receive_time,rz_b_dzzs等变量已事先声明
my_Query = ""If Trim(txtName.Text) <> "" Then
my_Query = " 姓名 like " & "'%" & txtName.Text & "%'"
End IfIf Trim(my_Query) <> "" And Trim(cmbSex.Text) <> "" Then
my_Query = my_Query & " AND 性别 =" & "'" & cmbSex.Text & "'"
ElseIf Trim(my_Query) = "" And Trim(Combo1.Text) <> "" Then
my_Query = " 性别 =" & "'" & cmbSex.Text & "'"
ElseIf Trim(my_Query) = "" And Trim(cmbSex.Text) = "" Then
MsgBox "请输入查询条件"
Exit Sub
End If