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
?