• Access关键字问题


     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

  • 相关阅读:
    PT100高精度测温电路 AD623+REF3030(转)
    STM32|4-20mA输出电路(转)
    串口通讯数据处理算法分析与实现(转)
    stm32_CAN总线知识(转)
    图像的灰度级和动态范围(转)
    图像bayer格式介绍以及bayer插值原理CFA(转)
    用oracle建表,必须注意Oracle 关键字(保留字)
    爬虫的定向爬取与垂直搜索
    开源的网络爬虫以及一些简介和比较
    SQL中的等号、IN、LIKE三者的比较
  • 原文地址:https://www.cnblogs.com/astar/p/1284085.html
Copyright © 2020-2023  润新知