Subject Re: [ib-support] Funny problem
Author Paul Schmidt
Thanks to Ann and Martjin for a hand with this problem, in the immortal words of
Homar Simpson D'oh!!!!!!

>Dear List:
>
>I have a domain:
>
>CREATE DOMAIN "D_BICHAR_31" AS VARCHAR(31)
>CHARACTER SET WIN1252 COLLATE PXW_INTL850;
>
>And a field:
>
>DNAME D_BICHAR_31
>
>Yet I can't put 30 characters worth of data in this field, any idea
>as to why?

Because some idiot (me) created a after insert trigger on this table that copies the
field's value to another table.field which is only 20 chars wide, so it was this insert
that was causing the problem. Okay now lets see if my barber can make what's
left look presentable......







Paul Schmidt, President
Tricat Technologies
paul@...
www.tricattechnologies.com