Hey guys,
I'd like to let you know you have a great product and i love using it. I
noticed that when you add muliple foreign keys in the "Create Table" wizard,
the SQL string generated does not put a comma between the different foreign
keys. For instance, the log reads:
9/16/2001 10:08:22 PM - SQL (hedge): CREATE TABLE
"component_container_assign" ("c_cont_id" int4 NOT NULL, "row" int2 NOT
NULL, "column" int2 NOT NULL, "l_comp_id" int4 NOT NULL, "group_id" int2 NOT
NULL, "row_span" int2 NOT NULL, "col_span" int2 NOT NULL, PRIMARY KEY
("c_cont_id", "row", "column"), CONSTRAINT "c_cont_ass_c_id_fk" FOREIGN KEY
("c_cont_id") REFERENCES "component_containers" ("c_cont_id") ON DELETE
CASCADE ON UPDATE CASCADE INITIALLY IMMEDIATECONSTRAINT
"c_cont_ass_comp_id_fk" FOREIGN KEY ("l_comp_id") REFERENCES
"layout_components" ("l_comp_id") ON DELETE CASCADE ON UPDATE CASCADE
INITIALLY IMMEDIATE)
when it should read:
9/16/2001 10:09:48 PM - SQL (hedge): CREATE TABLE
"component_container_assign" ("c_cont_id" int4 NOT NULL, "row" int2 NOT
NULL, "column" int2 NOT NULL, "l_comp_id" int4 NOT NULL, "group_id" int2 NOT
NULL, "row_span" int2 NOT NULL, "col_span" int2 NOT NULL, PRIMARY KEY
("c_cont_id", "row", "column"), CONSTRAINT "c_cont_ass_c_id_fk" FOREIGN KEY
("c_cont_id") REFERENCES "component_containers" ("c_cont_id") ON DELETE
CASCADE ON UPDATE CASCADE INITIALLY IMMEDIATE, CONSTRAINT
"c_cont_ass_comp_id_fk" FOREIGN KEY ("l_comp_id") REFERENCES
"layout_components" ("l_comp_id") ON DELETE CASCADE ON UPDATE CASCADE
INITIALLY IMMEDIATE)
with the comma between the IMMEDIATE and the CONSTRAINT on the third line
from the bottom. I hope this helps, and keep up the good work.
Mike
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp