I think you need to use "START" everywhere, both in the table definition
and also within your triggers/selects (well, I don't know enough to tell
for certain whether triggers could continue to work or not, I just
assume they need to be changed). So, unless you have some good reason, I
think it could easily be as much hassle keeping "START" as your
fieldname as it would be to replace it with RESTART (assuming this isn't
a reserved word). Of course, some third party tools can automatically
add double quotes around the field name, and those could keep on working
as before.

Sorry,
Set

jimmaguire1949 wrote:

> It is "START", sorry, did not mean it was lowercase.
>
> --- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@...>
> wrote:
>> jimmaguire1949 wrote:
>> > I have a table with a column named "start" (unfortunately). I've
> used
>> > it in 1.5 and 2.0.4.13130 in windows, but it fails in 2.1. Can't use
>> > it in selects or triggers.
>> >
>> > Is there any way to avoid renaming it? I've tried surrounding it
> with
>> > quotes: "start" but it makes no difference. I've reverted to 2.0 in
>> > the meantime.
>> >
>>
>> Try renaming to "START" (all UpperCase).
>>
>> --
>> Aage J.