View Incident Report

Serious

Reported By: Chris R. Timmons
Reported On: 7/16/2001
For: Version 2.11 Build 1

# 818 Using Column Names in VALUES Clause in INSERT SQL Statement Causes Error

Inserting a character value which has the same name as the colum it is being inserted into results in:

"DBISAM Engine Error # 11949 SQL error - Internal error: Column '<name>' specified illegally".

Occurrs for both CHAR and BLOB(0,1) column types.

CREATE TABLE "TEST.DAT" (NAME CHAR(50), NOTES BLOB(0,1))

// This works OK.
INSERT INTO Test (Name, Notes) VALUES ("Hello", "World!")

// This throws the 11949 error on the Name column.
INSERT INTO Test (Name, Notes) VALUES ("Name", "World!")

// This throws the 11949 error on the Notes column.
INSERT INTO Test (Name, Notes) VALUES ("Hello", "Notes")

Resolution

Fixed Problem on 7/20/2001 in version 2.12 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap