Hello Everyone;
I have a foreign key I'm trying to create to cascade a delete and I
keep getting the message "General error;-8030 POS(1) Column must be
indexed.".
Table "FTP-COMPANY" has two comlumns, id_company and nm_company, PK is
id_company.
Table "FTP-CONTACT" has id_company, id_contact, nm_contact, PK id_company,
id_contact.
I want when the id_company is deleted in table "FTP-COMPANY" for all
contacts in table "FPC-CONTACT" to be deleted. Below is the command I'm
trying to use to create the FK. I've tried creating an index on
FTP-Contact, but get "Integrity constraint violation;250 POS(1) Duplicate
secondary key." when I try to create it.
I'm sure I'm doing something obvious wrong, but so far I've been too thick
to get whatever it is from the docs.
ALTER TABLE "DBA"."FTP-COMPANY" FOREIGN KEY "FK-CONTACT" ("ID_COMPANY")
REFERENCES "DBA"."FTP-CONTACT" ("ID_COMPANY") ON DELETE CASCADE
Thanks - Billy Willoughby
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
