现在的位置: 首页 > 综合 > 正文

Access关键字问题

2012年12月23日 ⁄ 综合 ⁄ 共 3378字 ⁄ 字号 评论关闭

 Access关键字问题

以前都遇到过这样的问题,曾经把表字段名写成了Access里的关键字了,进行UDATE,INSERT的时候一直出错,而查不到错误。

郁闷了好大会才明白过了。加上[]就行了,但我看还是改了最好~~

以下是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

 

抱歉!评论已关闭.