急急急急，（诚信永远在线）

[feixuehu]

rs.Execute "insert into qyy (ID,OA,FEE_CODE,MO,MO_NUMBER,SENT_TEXT,SET_TIME,LAST_SENT_TIME)values ('" & id & "','" & Text1.Text & "',0," & 7777 & ",3," & aaaaaa & ",' to_date('2003-10-1,''yy-mm-dd') ',' to_date('2003-10-1,''yy-mm-dd') ') "
提示缺少表达式？？？？？
为什么

[yoki]

rs应该是cn吧(dim cn as new adodb.connection)
cn.Execute "insert into qyy (ID,OA,FEE_CODE,MO,MO_NUMBER,SENT_TEXT,SET_TIME,LAST_SENT_TIME)values ('" & id & "','" & Text1.Text & "',0," & 7777 & ",3,'" & aaaaaa & "','" & to_date('2003-10-1,''yy-mm-dd') & "','" & to_date('2003-10-1,''yy-mm-dd') &"')"

[WangPengAn]

Rs.Execute "insert into qyy (ID,OA,FEE_CODE,MO,MO_NUMBER,SENT_TEXT,SET_TIME,LAST_SENT_TIME)values" _
& "('" & ID & "','" & Text1.Text & "',0," & 7777 & ",3,'" & aaaaaa _
& ",'" & to_date("2003-10-1", "yy-mm-dd") & "','" & to_date("2003-10-1", "yy-mm-dd") & "')"

試一下﹐行不行

[feixuehu]

小马哥，按你的方法还是不行

[feixuehu]

我想我还是要学习.net：
我用了你的方法，但出现：sub or function not defined的错误

[WangPengAn]

to_date 是什么東西!~

[feixuehu]

在pb日期转换函数啊

[WangPengAn]

pb 啊﹐不知道也

aaaaaa 是定義嗎

[feixuehu]

字符串，随便写的