SQL="UPDATE aaa SET aaadate='" & now & "'"
rs.Open SQL, Conn,adOpenDynamic, adLockBatchOptimistic但是會提示錯誤﹕
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.可是我查詢記錄集﹐更新記錄﹐updatebatch就可以,為什么呢?
rs.Open SQL, Conn,adOpenDynamic, adLockBatchOptimistic但是會提示錯誤﹕
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.可是我查詢記錄集﹐更新記錄﹐updatebatch就可以,為什么呢?
sql = "update aaa set aaadate = "& now &""
不行﹐我試了
我的sql語句是這樣的
update aaa set aaadate='2003/4/9 下午 02:05:57' where isnull(aaadate,'1')='1'
SQL="UPDATE aaa SET aaadate='" & format( now,"yyyy-mm-dd ") & "'"
rs.Open SQL, Conn,adOpenDynamic, adLockBatchOptimistic就可以了