vb.net操作Access中是关键字的字段

还是昨天那个Access,彻底服了,人家把字段名命名为"End"然后甩手走了,让我收拾这个烂摊子

SQL语句到这里就出错....想办法解决吧

解决办法与带空格的字段一样,就是利用 [ ] 把字段括起来

比如:

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!