Hi Dudes,

I have two installations of II 2.6/0305 (axp.osf/00) with patch 10993
applied.

I have created a database on one and used the same script to create
the database on the other. All of which worked perfectly well - with the
exception of adding the constraints.

The only difference between the two installations - and its a biggy - is
that one uses uppercase column names (sql92 compliant?).

On the one with lowercase names:
alter table current_name
       add constraint pk_current_name PRIMARY KEY (id_number)
       with INDEX = BASE TABLE STRUCTURE

works like a dream.

On the other (with uppercase table and column names), the same
command is greeted with:
E_US0F0A line 1, Syntax error on 'STRUCTURE'.  The correct syntax
is:
   ALTER TABLE tablename
        ADD [CONSTRAINT constraint_name] constraint_clause
      | DROP CONSTRAINT constraint_name RESTRICT | CASCADE
      | ADD [COLUMN] columnname format [default_clause]
[null_clause]
   [column_constraint]
  | DROP [COLUMN] column_name RESTRICT | CASCADE

I can only assume the uppercase column names is beating this. I've
tried experimenting with the case of the names but to no avail.

Anyone got any idea? or an IDEA? or what about an iDeA?

Martin Bowes
--
Random Titus Quote #22:
No problem is so big and difficult that it can't be blamed on somebody
else.