VB脚本中where的构造来源以及构造思想?

来源:百度知道 编辑:UC知道 时间:2024/06/07 13:08:15
Private Sub cmdQuery_Click()
Dim Sqlstr As String
Dim whrStr As String
Dim feeC As Double
Dim znjC As Double

Dim rstRg As New ADODB.Recordset
'拼Where 语句
whrStr = getWhrStr()
'取得网格的数据
Sqlstr = "select * from feels " & whrStr & " "
'MsgBox Sqlstr
If rsdg.State = 1 Then
rsdg.Close
End If
rsdg.Open Sqlstr, gCnn, adOpenStatic, adLockOptimistic
'Debug.Print Sqlstr
Set rsdg = getQueryData(Sqlstr)
Set dgexp.DataSource = rsdg

Sqlstr = " select sum(feeMoney),sum(Ecount) from feels " & whrStr & " "
If rstRg.State = 1 Then
rstRg.Close
End If
rstRg.Open Sqlstr, gCnn, adOpenStatic, adLockBatchOptimistic
txtCount = Format(rstRg.Fields(0), "####0.00") & " "
txtCountA = rstRg.Fields(1) & " "
rstRg.Close

MsgBox " 数据查询完成,共" & rsdg.RecordCount & " 条

问题没说明! 怎么给你回答!

whrStr = "where 1 = 1 " 这一句初始条件字串,以供后面判断连接其它条件。而 where 1=1 在任何表中都识别。后面就根据界面交互加条件连接。