I would like to add, this does not happen in Firebird super server
1.5.0.4306

Is this a bug, or a problem because a previous bug was fixed?

Thanks in advanced

Trac

--- In firebird-support@yahoogroups.com, "tractaylor"
<tractaylor@y...> wrote:

> 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