Hi, use explicit field names like:
SELECT
MAX(NUMERO)+1 Field_1
FROM
SALES_ORDER

Slavek






I use Delphi 6.
I've just upgraded to FB2.1 from FB1.5

In this very simple query:

SELECT
MAX(NUMERO)+1

FROM
SALES_ORDER

when I defined the fields, with FB 1.5 the default name of the field was F_1
now when I open the query I get the error "Field F_1 not found"
I've just deleted the field and added it again. The default name with FB2.1
is "add" and now I can open the query with out problems... I'm curious about

it... I've read the release notes but found nothing about it.

Thanks in advance for your kind help

-sergio



__
.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=94567/stime=1212180165/nc1=3848643/nc2=4025338/nc3=5286675>




[Non-text portions of this message have been removed]