Version 5.1.31 Community (Win32)
I created a trigger named TC_Products_Date_Trigger on the table TC_Products. I typed in SHOW CREATE TRIGGER tc_products_date_trigger; and this came back at me: ERROR 1602 (HY000): Corrupted TRG file for table `subtable_usa`.`tc_products` I almost jumped out of my skin. Then I typed in SHOW CREATE TRIGGER TC_Products_Date_Trigger; and that worked just fine. I didn’t find any bug reports that seemed relevant, but I can’t believe I’m first one to stumble on this. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: <mailto:je...@gii.co.jp> je...@gii.co.jp Web site: <http://www.the-infoshop.com/> www.the-infoshop.com