I relaxed alias checking by editing Firebird.conf file:

> > change -> #RelaxedAliasChecking = 0
> > to -> RelaxedAliasChecking = 1

and then I do get the ambiguous field problem..
the problem is, I don't know how to fix it, as the field- and table-
names are extracted from a table and the sql is generated with
GetValueList (where the sql errors appear).. :(




--- In firebird-support@yahoogroups.com, "Hans" <hhoogstraat@...>
wrote:

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