Corrupted TRG file?

Corrupted TRG file?

am 21.12.2010 18:41:53 von Jerry Schwartz

------=_NextPart_000_009D_01CBA10C.72F48CA0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Version 5.1.31 Community (Win32)

=20

I created a trigger named TC_Products_Date_Trigger on the table =
TC_Products.

=20

I typed in=20

=20

SHOW CREATE TRIGGER tc_products_date_trigger;

=20

and this came back at me:

=20

ERROR 1602 (HY000): Corrupted TRG file for table =
`subtable_usa`.`tc_products`

=20

I almost jumped out of my skin. Then I typed in

=20

SHOW CREATE TRIGGER TC_Products_Date_Trigger;

=20

and that worked just fine. I didnâ€=99t find any bug reports that =
seemed relevant, but I canâ€=99t believe Iâ€=99m first one to =
stumble on this.

=20

Regards,

=20

Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

E-mail: jerry@gii.co.jp=20

Web site: www.the-infoshop.com

=20


------=_NextPart_000_009D_01CBA10C.72F48CA0--