You still have not supplied the SQL statement that is causing the
error. It will have SKAAP.FAMILIE_ID at column 86 of line 1 of the
statement. It is the one without a plan because Firebird cannot
prepare the statement.



--- In firebird-support@yahoogroups.com, "ulrickebester"
<umeinhof@...> wrote:

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