View Incident Report

Minor

Reported By: Johnnie Norsworthy
Reported On: 7/8/2004
For: Version 4.08 Build 1

# 1780 Including a Space in an ALTER TABLE Column Name Breaks IF NOT EXISTS Clause

The following SQL statement works fine when "Field" does not exist. But when the field has been created once and I rerun the query, I get:

DBISAM Error #10038 Invalid or duplicate field name "Field" specified for the table xxx

ALTER TABLE xxx
ADD IF NOT EXISTS "Field " VARCHAR (10);

Resolution

Fixed Problem on 7/10/2004 in version 4.09 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap