insert into 字段太长不能换行,按回车换行提示错误?

来源:百度知道 编辑:UC知道 时间:2024/05/25 05:20:31
ry.Execute " Insert into 叶面积测定(测定日期,作物,生长期,订正系数,一长,一宽,一面积,二长,二宽,二面积,三长,三宽,三面积,四长,四宽,四面积,五长,五宽,五面积,六长,六宽,六面积,七长,七宽,七面积,八长,八宽,八面积,九长,九宽,九面积,十长,十宽,十面积,十一长,十一宽,十一面积,十二长,十二宽,十二面积,十三长,十三宽,十三面积,十四长,十四宽,十四面积,十五长,十五宽,十五面积,十六长,十六宽,十六面积,十七长,十七宽,十七面积,十八长,十八宽,十八面积,十九长,十九宽,十九面积,二十长,二十宽,二十面积,合计一,合计二,合计三,合计四) VALUES (" & Trim(Text7(k).Text) & ",'" & Trim(Text1(k).Text) & "','" & Trim(Text3(k).Text) & "'," & Trim(Text4(k).Text) & "," & Trim(Text2(k).Text) & "," & Trim(Text2(k + 24).Text) & "," & Trim(Text2(k + 48).Text) & "," & Trim(Text2(k + 6).Text) & "," & Trim(Text2(k + 30).Text) & "," & Trim(Text2(k + 54).Text) & "," & Trim(Text2(k + 12).Text) & "," & Trim(Text2(k + 36).Text) & "," & Trim(Text2(k + 60).Text) & "," & Trim(Text2(k + 18).Text) & "," & Trim(Text2(k + 42).Text) & "," & Trim(Text2(k + 66).Text) & "," & T

ry.Execute " Insert into 叶面积测定(测定日期,作物,生长期,订正系数,一长,一宽,一面积,二长,二宽,二面积,三长,三宽,三面积,四长,四宽,四面积,五长,五宽,五面积,六长,六宽,六面积,七长,七宽,七面积,八长,八宽,八面积,九长,九宽,九面积,十长,十宽,十面积,十一长,十一宽,十一面积,十二长,十二宽,十二面积,十三长,十三宽,十三面积,十四长,十四宽,十四面积,十五长,十五宽,十五面积,十六长,十六宽,十六面积,十七长,十七宽,十七面积,十八长,十八宽,十八面积,十九长,十九宽,十九面积,二十长,二十宽,二十面积,合计一,合计二,合计三,合计四) VALUES (" _
& Trim(Text7(k).Text) & ",'" & Trim(Text1(k).Text) & "','" & Trim(Text3(k).Text) & "'," & Trim(Text4(k).Text) & "," & Trim(Text2(k).Text) & "," & Trim(Text2(k + 24).Text) & "," & Trim(Text2(k + 48).Text) & "," & Trim(Text2(k + 6).Text) & "," & Trim(Text2(k + 30).Text) & "," & Trim(Text2(k + 54).Text) & "," & Trim(Text2(k + 12).Text) & "," & Trim(Text2(k + 36).Text) & "," & Trim(Text2(k + 60).Text) & "," & Trim(Text2(k + 18).Text) & "," & Trim(Text2(k + 42).Text) & "," _
& Trim(Text2(k + 66).Text) &