View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 11/22/2000
For: Version 2.04 Build 1

# 662 Brackets 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

Resolution

Fixed Problem on 11/23/2000 in version 2.05 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap