Posted by [IP Address: 66.72.150.195] 'Meera' on May 18, 2001 at 15:12:17 EST:

I wrote a mutliple Report program But I seem to be getting this error, could any one help me out . Thanks

The code:

Begin-Select
C.Emplid
C.Plan_Type
C.Effdt
D.Dependent_Benef

Move 'Y' To $Term
Do Print_Terminated_Dependents
Show 'Dep Term found =' &D.Dependent_Benef
'for Employee ' &C.Emplid

From Ps_Health_Benefit C, Ps_Health_Dependnt D

Where C.Emplid = A.Emplid
And C.Plan_Type = A.Plan_Type
And C.Emplid = D.Emplid
And C.Plan_Type = D.Plan_Type
And C.Effdt = D.Effdt
And C.Effdt = (Select Max(E.Effdt From Health_Benefit E
Where C.Emplid = E.Emplid
And C.Plan_Type = E.Plan_Type
And C.Effdt < &A.Effdt)
And D.Dependent_Benef Not In
(Select F_Dependent_Benef
From Health_Dependent F
Where C.Emplid = F.Emplid
And C.Plan_Type = F.Plan_Type
And C.Effdt < &A.Effdt
End-Select !This is line 153

The Error:
Error on line 153:
(SQR 3716) Error in SQL Statement

Follow Ups:

• For Sweat Shop Patrol Meera 10:34:38 6/05/01 EST (0)
• Classic Example if H1B's with no real skills! Sweat Shop Patrol 22:10:26 5/31/01 EST (0)
• Re: SQR Select Statement problem Rebecca 16:38:34 5/18/01 EST (2)
  • Re: SQR Select Statement problem Meera 10:05:39 5/22/01 EST (1)
    • Re: SQR Select Statement problem Rebecca 14:47:25 5/23/01 EST (0)

Post a Followup