You run into the ambiguous field query problems

Like select cousin from, without telling from which parental side

----- Original Message -----
From: "ulrickebester" <umeinhof@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, November 06, 2008 11:47 PM
Subject: [firebird-support] Re: Interbase to Firebird conversion, Delphi


> The fields I get the error on..
>
> the sql selects the fields from a table which contains records
> referencing other tables and fields within them. (the user sets up
> some indices and the data for them is referenced in different tables)
>
> these sql errors weren't present when the db was in interbase, it
> only occurred after I converted it to firebird. i am using firebird
> embedded 2.1.1..
>
>
> --- In firebird-support@yahoogroups.com, "Michel Veerman"
> <m.veerman@...> wrote:
>>
>> I see no reference to either FAMILIE_ID or GEBOORTE_STATUS_ID (the
>> fields on which you received an error).
>>
>> So it seems that the query that gives you trouble is never sent to
> the
>> database.
>>
>> Or am I missing something?
>>
>> Kind regards,
>> Michel.
>>
>> ________________________________
>>
>> Van: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com] Namens ulrickebester
>> Verzonden: donderdag 6 november 2008 15:14
>> Aan: firebird-support@yahoogroups.com
>> Onderwerp: [firebird-support] Re: Interbase to Firebird conversion,
>> Delphi
>>
>>
>>
>> I got it :)
>>
>> I get:
>>
>> /* SQL */
>>
>> <<<snap>>>
>>
>>
>> /* SQL */
>> select SKAAP.GEBOORTEDATUM from SKAAP where SKAAP.skaap_id is not
>> null and ((skaap.moeder_id = '25966') or (skaap.vader_id
>> = '25966')) order by skaap.skaap_nommer_jaar
>> DESC,skaap.skaap_nommer_volg,skaap.skaap_nommer_stoet;
>>
>> /* PLAN */
>> PLAN SORT ((SKAAP INDEX (XMOEDER, XVADER)))
>>
>> /* SQL */
>>
>> /* PLAN */
>>
>> and the last plan is not visible when I get the error
>> ?
>>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>