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