还是昨天那个Access,彻底服了,人家把字段名命名为"End"然后甩手走了,让我收拾这个烂摊子
解决办法与带空格的字段一样,就是利用 [ ] 把字段括起来
比如:
INSERT INTO A ( [End] ) VALUES ('2012-12-27')
顺便把Access关键字列出来,以免以后犯同样错误
-A ADD ALL Alphanumeric ALTER AND ANY Application AS ASC Assistant AT AUTOINCREMENT Avg -B BETWEEN BINARY BIT BOOLEAN BY BYTE -C CHAR,CHARACTER COLUMN CompactDatabase CONSTRAINT Container Count COUNTER CREATE CreateDatabase CreateField CreateGroup CreateIndex CreateObject CreateProperty CreateRelation CreateTableDef CreateUser CreateWorkspace CURRENCY CurrentUser -D DATABASE DATE DATETIME DELETE DESC Description DISALLOW DISTINCT DISTINCTROW Document DOUBLE DROP -E Echo Else End Eqv Error EXISTS Exit -F FALSE Field,Fields FillCache FLOAT,FLOAT4,FLOAT8 FOREIGN Form,Forms FROM Full FUNCTION -G GENERAL GetObject GetOption GotoPage GROUP GROUP BY GUID -H HAVING -I Idle IEEEDOUBLE,IEEESINGLE If IGNORE Imp IN INDEX Index,Indexes INNER INSERT InsertText INT,INTEGER,INTEGER1,INTEGER2,INTEGER4 INTO IS -J JOIN -K KEY -L LastModified LEFT Level Like LOGICAL,LOGICAL1 LONG,LONGBINARY,LONGTEXT -M Macro Match Max,Min,Mod MEMO Module MONEY Move -N NAME NewPassword NO Not Note NULL NUMBER,NUMERIC -O Object OLEOBJECT OFF ON OpenRecordset OPTION OR ORDER Orientation Outer OWNERACCESS -P Parameter PARAMETERS Partial Password PERCENT PIVOT PRIMARY PROCEDURE Property -Q Queries Query Quit -R REAL Recalc Recordset REFERENCES Refresh RefreshLink RegisterDatabase Relation Repaint RepairDatabase Report Reports Requery RIGHT -S SCREEN SECTION SELECT SET SetFocus SetOption SHORT SINGLE Size SMALLINT SOME sql StDev,StDevP STRING Sum -T TABLE TableDef,TableDefs TableID TEXT TIME,TIMESTAMP TOP TRANSFORM TRUE Type -U UNION UNIQUE UPDATE USER -V VALUE VALUES Var,VarP VARBINARY,VARCHAR -W WHERE WITH Workspace -X Xor -Y Year YES YESNO