Office中国论坛/Access中国论坛

标题: 求救：ACCESS中的一个无法执行的SQL语句！ [打印本页]

作者: qdwind 时间: 2003-5-28 22:25
标题: 求救：ACCESS中的一个无法执行的SQL语句！
在ACCESS里执行如下SQL语句：
update aaa set a1='x',a2='x',a3='x',a4='x',a5='x',a6='x',a7='x',a8='x',a9='x',a10='x',a11='x',a12='x',a13='x',a14='x',a15='x',a16='x',a17='x',a18='x',a19='x',a20='x',a21='x',a22='x',a23='x',a24='x',a25='x',a26='x',a27='x',a28='x',a29='x',a30='x',a31='x',a32='x',a33='x',a34='x',a35='x',a36='x',a37='x',a38='x',a39='x',a40='x',a41='x',a42='x',a43='x',a44='x',a45='x',a46='x',a47='x',a48='x',a49='x',a50='x',a51='x',a52='x',a53='x',a54='x',a55='x',a56='x',a57='x',a58='x',a59='x',a60='x',a61='x',a62='x',a63='x',a64='x',a65='x',a66='x',a67='x',a68='x',a69='x',a70='x',a71='x',a72='x',a73='x',a74='x',a75='x',a76='x',a77='x',a78='x',a79='x',a80='x',a81='x',a82='x',a83='x',a84='x',a85='x',a86='x',a87='x',a88='x',a89='x',a90='x',a91='x',a92='x',a93='x',a94='x',a95='x',a96='x',a97='x',a98='x',a99='x',a100='x',a101='x',a102='x',a103='x',a104='x',a105='x',a106='x',a107='x',a108='x',a109='x',a110='x',a111='x',a112='x',a113='x',a114='x',a115='x',a116='x',a117='x',a118='x',a119='x',a120='x',a121='x',a122='x',a123='x',a124='x',a125='x',a126='x',a127='x',a128='x'

将出现错误：“定义了过多字段”。但只要把最后一个字段去掉（a128='x'），就可正常执行，这是不是说明ACCESS中执行SQL语句有字段限制（不能多于127个字段）？如果我有更多的字段怎么办？难道只能分多条语句执行吗？

[附]创建以上测试表aaa的SQL语句：

CREATE TABLE aaa (
a1 varchar (10),
a2 varchar (10),
a3 varchar (10),
a4 varchar (10),
a5 varchar (10),
a6 varchar (10),
a7 varchar (10),
a8 varchar (10),
a9 varchar (10),
a10 varchar (10),
a11 varchar (10),
a12 varchar (10),
a13 varchar (10),
a14 varchar (10),
a15 varchar (10),
a16 varchar (10),
a17 varchar (10),
a18 varchar (10),
a19 varchar (10),
a20 varchar (10),
a21 varchar (10),
a22 varchar (10),
a23 varchar (10),
a24 varchar (10),
a25 varchar (10),
a26 varchar (10),
a27 varchar (10),
a28 varchar (10),
a29 varchar (10),
a30 varchar (10),
a31 varchar (10),
a32 varchar (10),
a33 varchar (10),
a34 varchar (10),
a35 varchar (10),
a36 varchar (10),
a37 varchar (10),
a38 varchar (10),
a39 varchar (10),
a40 varchar (10),
a41 varchar (10),
a42 varchar (10),
a43 varchar (10),
a44 varchar (10),
a45 varchar (10),
a46 varchar (10),
a47 varchar (10),
a48 varchar (10),
a49 varchar (10),
a50 varchar (10),
a51 varchar (10),
a52 varchar (10),
a53 varchar (10),
a54 varchar (10),
a55 varchar (10),
a56 varchar (10),
a57 varchar (10),
a58 varchar (10),
a59 varchar (10),
a60 varchar (10),
a61 varchar (10),
a62 varchar (10),
a63 varchar (10),
a64 varchar (10),
a65 varchar (10),
a66 varchar (10),
a67 varchar (10),
a68 varchar (10),
a69 varchar (10),
a70 varchar (10),
a71 varchar (10),
a72 varchar (10),
a73 varchar (10),
a74 varchar (10),
a75 varchar (10),
a76 varchar (10),
a77 varchar (10),
a78 varchar (10),
a79 varchar (10),
a80 varchar (10),
a81 varchar (10),
a82 varchar (10),
a83 varchar (10),
a84 varchar (10),
a85 varchar (10),
a86 varchar (10),
a87 varchar (10),
a88 varchar (10),
a89 varchar (10),
a90 varchar (10),
a91 varchar (10),
a92 varchar (10),
a93 varchar (10),
a94 varchar (10),
a95 varchar (10),
a96 varchar (10),
a97 varchar (10),
a98 varchar (10),
a99 varchar (10),
a100 varchar (10),
a101 varchar (10),
a102 varchar (10),
a103 varchar (10),
a104 varchar (10),
a105 varchar (10),
a106 varchar (10),
a107 varchar (10),
a108 varchar (10),
a109 varchar (10),
a110 varchar (10),
a111 varchar (10),
a112 varchar (10),
a113 varchar (10),
a114 varchar (10),
a115 varchar (10),
a116 varchar (10),
a117 varchar (10),
a118 varchar (10),
a119 varchar (10),
a120 varchar (10),
a121 varchar (10),
a122 varchar (10),
a123 varchar (10),
a124 varchar (10),
a125 varchar (10),
a126 varchar (10),
a127 varchar (10),
a128 varchar (10),
)

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)