Spectrum Spatial (SSA/LIM)

 View Only

  • 1.  Reserved Words

    Posted 10-07-2022 07:10
    Hello
    Has anyone got an up-to-date list of Reserved Words that you need to avoid using in table structures, please?

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------


  • 2.  RE: Reserved Words

    Employee
    Posted 10-07-2022 07:44
    You can ask MapInfo Pro (since v2021):

    Print SessionInfo(SESSION_INFO_TOKENS_RESERVED)

    Will print a list of all the reserved words to the Message window


    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------



  • 3.  RE: Reserved Words

    Posted 10-07-2022 08:59
    Are these MapBasic Reserved Words?
    This is in relation to uploading data into the Spectrum Repository.
    I know of those such as CONNECT,CREATE,CURRENT,DATE,DECIMAL,DEFAULT,DELETE,DESC,DISTINCT, etc.

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------

    Original Message


  • 4.  RE: Reserved Words

    Employee
    Posted 10-14-2022 02:21
    The only thing related to Spectrum Spatial I could find was this: Are there any reserved words in Spectrum Spatial?

    Every database probably has a good list of words to avoid even though many databases these days could still use these if you were wrapping these words in quotes or similar. Here's a long list of words for MS SQL Server Transact SQL.

    I know that's not exactly what you were asking for but it's as close as I can get

    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------

    Original Message


  • 5.  RE: Reserved Words

    Posted 10-14-2022 03:57
    Thanks Peter
    It is one of those checks that Spectrum does when you 'upload' a table to the Repository.
    And when it fails the check, you need this to refer to...

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------

    Original Message


  • 6.  RE: Reserved Words

    Posted 11-01-2022 12:36
    'Distance' is a reserved word too (found out the hard way).
    -- Steve

    ------------------------------
    Steve Wallace
    Florida Farm Bureau Insurance
    ------------------------------

    Original Message


  • 7.  RE: Reserved Words

    Posted 11-13-2022 17:05
    Edited by Duri Bradshaw 11-13-2022 17:07
    Not a compete or current list but these are the ones I try avoid, I'm not sure where the list came from but I have found it useful.
    • Access
    • Add
    • All
    • Alter
    • And
    • Any
    • Arraylen
    • As
    • Asc
    • Audit
    • Between
    • By
    • Char
    • Check
    • Cluster
    • Column
    • Comment
    • Compress
    • Connect
    • Create
    • Current
    • Date
    • Decimal
    • Default
    • Delete
    • Desc
    • Distinct
    • Drop
    • Else
    • Exclusive
    • Exists
    • File
    • Float
    • For
    • From
    • Grant
    • Group
    • Having
    • Identified
    • Immediate
    • In
    • Increment
    • Index
    • Initial
    • Insert
    • Integer
    • Intersect
    • Into
    • Is
    • Level
    • Like
    • Lock
    • Long
    • Maxextents
    • Minus
    • Mode
    • Modify
    • Noaudit
    • Nocompress
    • Not
    • Notfound
    • Nowait
    • Null
    • Number
    • Of
    • Offline
    • On
    • Online
    • Option
    • Or
    • Order
    • Pctfree
    • Prior
    • Privileges
    • Public
    • Raw
    • Rename
    • Resource
    • Revoke
    • Row
    • Rowid
    • Rowlabel
    • Rownum
    • Rows
    • Select
    • Session
    • Set
    • Share
    • Size
    • Smallint
    • Sqlbuf
    • Start
    • Successful
    • Synonym
    • Sysdate
    • Table
    • Then
    • To
    • Trigger
    • Uid
    • Union
    • Unique
    • Update
    • User
    • Validate
    • Values
    • Varchar
    • Varchar2
    • View
    • Whenever
    • Where
    • With


    ------------------------------
    Duri Bradshaw
    Spatial IT Consultant
    Insight GIS
    ------------------------------

    Original Message


  • 8.  RE: Reserved Words

    Posted 11-15-2022 12:04
    Nice one Duri - thanks

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------

    Original Message