帮忙找错
Private Sub Command1_Click()
Adodc1.RecordSource = "select STCD sum(isnull(DRP,0)) as DRP From ST_PPTN_R Where between tm='" + DTPicker2.Value + " " + Text3.Text + ":00:00' and tm='" + DTPicker3.Value + " " + Text4.Text + ":00:00'" Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1.Recordset
DataGrid1.Refresh
End Sub
[解决办法]
会不会是DTPicker Value格式的问题?
[解决办法]
"select stcd,drp as data,tm as tm_ from st_pptn_r
where
tm >= '".$tm_begin."' and
tm <= '".$tm_end."'"