UC知道vb数据库设计
来源：百度知道 编辑：UC知道 时间：2024/06/05 06:14:23
Private Sub Command1_Click()
Dim rs As adodb.Recordset
Set cmd = New adodb.Command
cmd.ActiveConnection = cn
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and lx='96304' "
cmd.Parameters(0).Value = Text1.Text
Set MSHFlexGrid1.DataSource = cmd.Execute
End Sub
我想把语句“ "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and bj='96208' "也添加进去该怎么做”
具体
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and (lx='96304' or bj='96208') "这个是可以查询，但问题是他把查询后的2种数据合到一起，怎么能分开显示：96304的一块，96208的一块呢
Dim rs As adodb.Recordset
Set cmd = New adodb.Command
cmd.ActiveConnection = cn
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and lx='96304' "
cmd.Parameters(0).Value = Text1.Text
Set MSHFlexGrid1.DataSource = cmd.Execute
End Sub
我想把语句“ "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and bj='96208' "也添加进去该怎么做”
具体
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and (lx='96304' or bj='96208') "这个是可以查询，但问题是他把查询后的2种数据合到一起，怎么能分开显示：96304的一块，96208的一块呢
楼上错了,应该把 lx='96304' or bj='96208' 加括号.就是:
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and (lx='96304' or bj='96208') "
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and lx='96304' "
换成：
cmd.CommandText = "select count (*) as 呼入次数,sum (jc) as 市话通话次数 from jf where ks >? and lx='96304' or bj='96208' "