View Incident Report

Serious

Reported By: Guenter Angerer
Reported On: 8/7/2002
For: Version 3.12 Build 1

# 1172 SQL Statements Not Allowing the Use of the Dollar Sign ($) in Column Names

The CREATE TABLE statement creates the table as expected, but the INSERT INTO fails. If I change the column 'status$' to 'status' the INSERT INTO works.

DROP TABLE IF EXISTS 'test';

CREATE TABLE 'test'
 (
 'status$'       CHARACTER(10)  NOT NULL   ,
 PRIMARY KEY ('status$')
);

INSERT INTO 'test' ( status$ ) VALUES ( 'Test');

Resolution

Fixed Problem on 8/8/2002 in version 3.13 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap