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/