At 12:51 AM 16/12/2003 +0800, you wrote:

>Martin Dew wrote:
>
> >Can you post on here the metadata of your table and any triggers on that
> >able also please. It may help.
> >
> >
>hi
>here is the metadata ...
>
>CREATE TABLE "counterpayments" (
> "Key" INTEGER,
> ID INTEGER,
> "Paydate" DATE,
> "Type" CHAR(3),
> "Mode" CHAR(3),
> "Amount" NUMERIC(15,2),
> "Bank" VARCHAR(10),
> "CheckNo" VARCHAR(20),
> "CheckDate" DATE,
> "DocID" INTEGER
>);
>
>I have no trigger that is related to the type field of this table

Do you have any cascading foreign keys referencing this column?

/heLen