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