Hi,

> insert into "counterpayments"("Key", ID, "Paydate", "Type", "Amount")
> values (gen_id("gen_counterpayments",1), 630, '12/16/2003', 'CSH', 100)
>
> and the result is ... the error still occur. I try to double check the
> DLL and it says that the "Type" is char(3) ...
>
> whats wrong with this one?

Any triggers that declare variables of CHAR(2) on that table?

Or triggers that use the CHAR(2) value to insert/update other
tables?

With regards,

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