> 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

Change your database tool settings to avoid those nasty
delimited identifiers. You are making things harder on yourself.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com