我用的是ACCESS数据库,有两个表:TRAP和TYPE
用以下的语句查询就出错
dim source as date
dim numberss as integer
source=03-5-7
numberss=50
Set rs= db.OpenRecordset("select trap.msg,type.index from trap,type where
trap.datetime=source and type.index=numberss")在数据库中,日期型的字段怎样用变量操作呀,还有整型,字符串等等,请赐教
用以下的语句查询就出错
dim source as date
dim numberss as integer
source=03-5-7
numberss=50
Set rs= db.OpenRecordset("select trap.msg,type.index from trap,type where
trap.datetime=source and type.index=numberss")在数据库中,日期型的字段怎样用变量操作呀,还有整型,字符串等等,请赐教
trap.datetime=#"+source+"# and type.index=numberss")
dim numberss as integer
source=#03-5-7#
numberss=50
Set rs= db.OpenRecordset("select trap.msg,type.index from trap,type where
trap.datetime= " & source & "and type.index= " & numberss &"")
可以看看这段代码没错的.
你的答案没有参考价值!
trap.datetime=#" & source & "# and type.index=" & numberss & ")