Hi,
I'm using FB 1.0.2 and the GDB is recreated every new metadata version
(almost every week).
I think the problem is related to the recursive procedure wich is used.
Here it goes the original SQL (with the erroneous where id_status = 2). I'm
still thinking why the person who wrote this SQL used field alias at all
fields, except by the id_status on the where.
I think this was the last 'old' query here. So it will not happen anymore.
Thanks.

select
cast(gen_id(GEN_ROW_ID, 1) as INTEGER) ROW_ID,
GFT.PATH,
T.ID_TAREFA,
T.ID_TAREFA_PAI,
T.ID_PROJETO,
T.NOME,
T.ID_EXECUTOR,
T.NRO_TAREFA,
T.ID_TIPO_TAREFA,
T.ID_CLASSE_TAREFA,
T.ID_STATUS,
TT.NOME NOME_TIPO,
P.NOME NOME_EXECUTOR,
PR.NOME NOME_PROJETO,
CT.NOME NOME_CLASSE
from
GET_FILHOS_TAREFA(NULL,1) GFT left outer join
TAREFA T on GFT.ID_TAREFA = T.ID_TAREFA left outer join
TIPO_TAREFA TT on TT.ID_TIPO_TAREFA = T.ID_TIPO_TAREFA left outer join
PESSOA P on P.ID_PESSOA = T.ID_EXECUTOR left outer join
PROJETO PR on PR.ID_PROJETO = T.ID_PROJETO left outer join
CLASSE_TAREFA CT on CT.ID_CLASSE_TAREFA = T.ID_CLASSE_TAREFA
where id_status = 2

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, May 05, 2003 9:48 AM
Subject: Re: [ib-support] Ambiguous field


> Hi,
>
> At May 5, 2003, 08:37, Valdir Stiebe Junior wrote:
>
> > Hi,
> > I'm using dialect 3 character set WIN1252 with the server running on a
> > Win2k.
>
> Which version of FB 1.0 are you using? Also, was this database used
> by a previous version of Interbase?
>
> When I try a similar query, to yours, I get the ambiguous field error as
> expected.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>