Access保留字(页 1) - ACCESS - 编程论坛

燃燒发表于 2006-9-15 02:20

Access保留字

Access 2002/2003
-A ADD ALL Alphanumeric ALTER AND ANY Application AS ASC Assistant 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

燃燒发表于 2006-9-15 02:20

-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 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 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
以及以下标点符号 . / * ; : ! # & - ? "
$

燃燒发表于 2006-9-15 02:21

Access 2000
-A ADD ALL Alphanumeric ALTER AND ANY Application AS ASC Assistant 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 NULL NUMBER, NUMERIC -O Object OLEOBJECT OFF ON OpenRecordset OPTION OR ORDER Orientation Outer OWNERACCESS
-P Parameter PARAMETERS Partial PERCENT PIVOT PRIMARY PROCEDURE Property -Q Queries Query Quit

燃燒发表于 2006-9-15 02:21

-R REAL Recalc Recordset REFERENCES Refresh RefreshLink RegisterDatabase Relation Repaint RepairDatabase Report Reports Requery RIGHT -S SCREEN SECTION SELECT) SET SetFocus SetOption SHORT SINGLE 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

以及以下标点符号 . / * : ! # & - ? ; "
$

勇者RX 发表于 2006-9-15 18:25

这些保留字的具体作用是什么?[em06]

燃燒发表于 2006-9-16 02:14

保留字是系统定义的函数,命令,超作等 .. 每个保留字都有不同的作用 用户可以根据需要调用 也可以定义自己新的函数(或类) 还有就是,用户定义的变量名,类名,函数名等,不能和保留字一样 .. [em01]

booo 发表于 2006-9-16 07:25

还真够多的。

页: [1]

编程论坛's Archiver

Access保留字