急，加急！请教高手：ADO查询FOXPRO的问题，能连接上，查询语句日期字段匹配的问题！

[guangjian]

代码如下：
Private Sub Command1_Click()
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
On Error GoTo err
conn.ConnectionString = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=d:\fox;SourceType=DBF;"
conn.Open
rs.Open "select kprq from zyfp2 where kprq ='2003-3-12'", conn, adOpenStatic
MsgBox rs.RecordCount
rs.Close
conn.Close
Exit Sub
err:
conn.Close
MsgBox err.Description
End Sub

select kprq from zyfp2 where kprq ='2003-3-12'总是出错，如果是
select kprq from zyfp2则不出错，请问kprq ='2003-3-12'的格式是怎样的？

[guangjian]

搞定了，给大家借鉴一下：用ADO的rs.Filter = "kprq='2003-06-12'"