ALTER TABLE Problem

Hi,

- I tried to execute following SQL alter table PRICEGROUP add FOREIGN KEY
("PARENT") REFERENCES "PRICEGROUP" ON DELETE CASCADE

this gives an error ALTER TABLE: column "PARENT" referenced in foreign key
constraint does not exist (7) while I'm sure that the column exists and is
Non null. I'm using version 7.2 on linux redhat 7.2

- I also tried some ODBC stuff. Here I've seen that the S.... result codes
are not correct. Most of the time it simply return S1000 which is a
general error code.

and not a specific code. e.g. when you want to create a table that already
exists it should return the correct error. ( same for an index, etc... )

Regards,

Dirk Jacobs