Hello:

I am running firebird 1.5 (1.5.2.4731). I am trying to run this
query and it gets the error "No Current Record for Fetch Operation".
I found if I move 2 of the joins to the end, it seems to work. Here
is a segment of the sql



Select ......

From Income I

Left Outer Join Lookup_Codes L2 On (I.Hud_Income_Code = L2.Code_Id)
Left Outer Join Lookup_Codes L1 On (I.Income_Type = L1.Code_Id)
Inner Join VHousehold H On (I.Household_Members_SysId =
H.Household_Members_SysId)
Inner Join VProperty Pr On (Pr.Property_SysId = H.Property_SysId)
Inner Join Verifications V On (V.Verf_Item_SysId = I.Income_SysId
and V.Verification_Type = 1463)
Left Outer Join Verf_Entities E On (V.Verf_Entity_SysId =
E.Verf_Entity_SysId)
Left Outer Join People P On (E.People_SysId = P.People_SysId)
Left Outer Join VEmployee Ve On (Ve.Employee_SysId =
Pr.Manager_Employee_SysId)
Left Outer Join Lookup_Codes L3 On (L3.Code_Id =
Ve.Employee_Type_Code)
..................................

If I move the top two Left outer join statements to the bottom like
the following:

Inner Join VHousehold H On (I.Household_Members_SysId =
H.Household_Members_SysId)
Inner Join VProperty Pr On (Pr.Property_SysId = H.Property_SysId)
Inner Join Verifications V On (V.Verf_Item_SysId = I.Income_SysId
and V.Verification_Type = 1463)
Left Outer Join Verf_Entities E On (V.Verf_Entity_SysId =
E.Verf_Entity_SysId)
Left Outer Join People P On (E.People_SysId = P.People_SysId)
Left Outer Join VEmployee Ve On (Ve.Employee_SysId =
Pr.Manager_Employee_SysId)
Left Outer Join Lookup_Codes L3 On (L3.Code_Id =
Ve.Employee_Type_Code)
Left Outer Join Lookup_Codes L2 On (I.Hud_Income_Code = L2.Code_Id)
Left Outer Join Lookup_Codes L1 On (I.Income_Type = L1.Code_Id)
..........................

This runs fine. It will also run if I change the left outer joins to
inner joins.


Does this make any sense to anyone?


Thanks
Trac