I have old code with that works just fine in FB1.53

IB_Query:



SELECT A.ANIMALIDENTIFICATION, A.ANIMALNAME, A.ANIMALREGISTRATIONNUMBER,

A.ANIMALHERDSTATUS, A.ANIMALDOB, A.ANIMALGENDER, A.ANIMALTAGCOLOUR,

A.ANIMALID, S.ANIMALFIRSTSIREDATE, S.ANIMALSIRESTATUS

FROM ANIMAL A, ANIMALACTIVESIRES S

where A.ANIMALGENDER = 'M'



KeyLinks pane:

ANIMAL.ANIMALIDENTIFICATION=NAT.NATSIREIDENTIFICATION



JoinLinks Pane:

ANIMAL.ANIMALID = ANIMALACTIVESIRES.ANIMALSIREID



Used to work perfectly in FB1.53



Since migration for FB2

Get Error: 335544569



ISC MESSAGE: Dynamic SQL Error SQL error code = -206 Column unkown
ANIMAL.ANIMALID At line 6,column14.



**************************************



If I then change join links pane to:

A.ANIMALID = S.ANIMALSIREID



And change Keylinks pane to:

KeyLinks pane:

A.ANIMALIDENTIFICATION=NAT.NATSIREIDENTIFICATION



I then get error:

FiledName: Animalactivesires.animalfisrtsiredate not found.

This field definitely exists!!



Previously using Animal. instead of A. was acceptable in the Joinlinks etc,
but now appears not to work with other queries of mine aswell.



These are all IB_Queries.



Has something changed.

What must I do now.



When I check my other queries no hassles.



It only appears to pop up these errors when using JOIN LINKS!!



Was 1.53 more leniant towards possible poor coding practices, and if so,
please point out my poor coding practice, I will appreciate this.

I checked Helens book, and could not come up with any issues.



Any help will be appreciated.



Regards



Adrian



[Non-text portions of this message have been removed]