bug report

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