Is TYPE a reserved word ???? Not sure if FB uses that as a reserved
word.


-----Original Message-----
From: James [mailto:james_027@...]
Sent: 15 December 2003 16:52
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] unpredictable behavior after changing
field size

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



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/