How big is the database if you back it up. What version of IB/FB are you
using ?

I expect there is something going on in a trigger etc.. Try taking a
copy of all triggers from that table, then remove them from that table,
and then retry the insert statement and see what that does... Atleast
that will eliminate a trigger problem if the table has no triggers on
it..

-----Original Message-----
From: Martin Dew [mailto:martin.dew@...]
Sent: 15 December 2003 17:15
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] unpredictable behavior after changing
field size

I think that would have something to do with the dialect of your
database, it is expecting you to use "" around the fieldnames and tables
like...

SELECT "Key", "ID", "Paydate"
FROM "Counterpayments"

But I might be wrong, I am not much of a IB/FB guru.


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

Hi
I didn't notice but just now both of you have almost the same name :-)

Martin
I have no store procedure also ... :-(


Martijn

But if I try this

SELECT Key, ID, Paydate
FROM Counterpayments

Iam getting an error.

What should be the right way?








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/






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/