MAIN.DBF库中:
CDATE BAR
2003-06-15 3194
2003-06-15 3194
2004-05-17 11543
2004-05-21 11543
. .
. .
. .
我想选择>2003-06-15的所有记录,找高手来解决!!!!!!
程序如下:
Option Explicit
Dim strpath As String
Dim datetime As Date
Private Sub Form_Load() strpath = "Provider=MSDASQL.1;Persist Security Info=False;DSN=main;UID=;"
strpath = strpath + "SourceDB=D:\3000\TEST\数据1.dbc;SourceType=DBC;Exclusive=No;"
strpath = strpath + "BackgroundFetch=Yes;Collate=Machine;" Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
conn.ConnectionString = strpath
conn.Open
Dim sqlcmd As New ADODB.Command
sqlcmd.ActiveConnection = conn.ConnectionString
datetime = "2003-06-15"
sql = "select * from main where cdate>'应该怎么写啊'" ←这边SQL语句出错
rs.Open sql, conn, adOpenStatic, adLockReadOnly
msgbox rs.recordcount
rs.Close
conn.Close
End Sub
CDATE BAR
2003-06-15 3194
2003-06-15 3194
2004-05-17 11543
2004-05-21 11543
. .
. .
. .
我想选择>2003-06-15的所有记录,找高手来解决!!!!!!
程序如下:
Option Explicit
Dim strpath As String
Dim datetime As Date
Private Sub Form_Load() strpath = "Provider=MSDASQL.1;Persist Security Info=False;DSN=main;UID=;"
strpath = strpath + "SourceDB=D:\3000\TEST\数据1.dbc;SourceType=DBC;Exclusive=No;"
strpath = strpath + "BackgroundFetch=Yes;Collate=Machine;" Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
conn.ConnectionString = strpath
conn.Open
Dim sqlcmd As New ADODB.Command
sqlcmd.ActiveConnection = conn.ConnectionString
datetime = "2003-06-15"
sql = "select * from main where cdate>'应该怎么写啊'" ←这边SQL语句出错
rs.Open sql, conn, adOpenStatic, adLockReadOnly
msgbox rs.recordcount
rs.Close
conn.Close
End Sub
解决方案 »
- MSChart 大量数据显示不清该如何解决.怎样分屏显示求指教
- text控件中能否输入红桃、黑桃、草花、方块的图标?
- VB怎么调用vc写的dll.非标准的
- 在本机如何取得数据库服务器上的系统时间
- 数据库高手来请进,喜欢数据库的来看看!
- VB自动设置PHOTOSHOP历史记录的路径
- 我想自己画窗体的标题栏和边框(即非客户区),应该捕获哪些Windows消息?
- 请问何为Hook,ring0?
- 请问各位高手如何获得某年某月的第一天和最后一天。
- 这里有多少人是在软件公司做产品呀,具体做什么呢
- 如何使用listview列表项目或treeview节点的OLE拖动?
- 【问】好喜欢系统的文件夹浏览框,如果能够自己用就好了?
sql = "select * from main where [cdate]>'" & datetime & "'"
sql = "select * from main where [cdate]>'" & datetime & "'"
一般dbf的查询要写上.dbf,在main后面加上.dbf试试datetime =CDate("2003-06-15")
sql = "select * from main.dbf where [cdate]>'" & datetime & "'"