SELECT
(MAX(NUMERO)+1) AS NUEVO
FROM
SALES_ORDER

On Fri, May 30, 2008 at 4:41 PM, Sergio H. Gonzalez <
shg_sistemas@...> wrote:

> 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
>
>
>

--
Ing (Eng) Fernando J. Buitrago Clausell
Cell: 809-805-8343
Tel : 809-274-5353
CUBA y Republica Dominicana


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