----- Original Message -----
From: "James" <james_027@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, December 15, 2003 6:17 PM
Subject: Re: [firebird-support] unpredictable behavior after changing field
size


> Martijn Tonies wrote:
>
> >>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.
> >
> Hi guys. Any idea?
>
> Master does tools have anything to do with my problem?

Well, probably not this problem. However, didn't you notice that
your SQL statements are like this:

SELECT "Key", "ID", "Paydate"
FROM "counterpayments"

While they could be like this:

SELECT Key, ID, Paydate
FROM Counterpayments

With regards,

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