Reported By: Ole Willy Tuv Reported On: 11/22/2000 For: Version 2.04 Build 1
# 662Brackets Around Column Names in SQL Statements are Not Consistent In Functionality According to OLM (Online Manual) enclosing keywords inside brackets is legal DBISAM syntax, however this is not always true currently.
CREATE TABLE MyTable (ID INTEGER)
{ This syntax works }
ALTER TABLE MyTable ADD 'Primary' BOOLEAN
{ This syntax works }
ALTER TABLE MyTable ADD MyTable.Primary BOOLEAN
{ This syntax gives an #11949 error }
ALTER TABLE MyTable ADD [Primary] BOOLEAN
ResolutionFixed Problem on 11/23/2000 in version 2.05 build 1