Hi

I assume just like any other reserved word define it as "ROWS".
Although you will always need to reference it that way as well.

A better option would be to have a different fieldname internally ans
display it as Rows, i.e. SELECT xxx AS "Rows".

--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Ray Jenkins wrote:

> We have an upgrade issue... Our old software used a column named ROWS. We
> found out the error of our ways a couple of years ago and phased out this
> column.
>
> We are now moving to Firebird 2.0, and have the issue that those older
> clients want to add and use a column named ROWS.
>
> Is there anyway during an upgrade, (where part of the customers machines
> will be running our new software and some the old) that we could allow a
> column named ROWS in a Firebird 2.0 server install.
>
> Thanks in advance
>
> Ray
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
>