[sqr-users] Error 3719 and 4407

["abhay sachar" <sachar_abhay@hotmail.com>]

I have this code -

SELECT
J.Action_Reason
J.Company
N.Name
JCT.DESCR  !JobTitle
J.Effdt
J.Reg_Temp
J.Full_Part_Time
J.Empl_Class
J.CompRate
J.Comp_Frequency
J.Step
PDF.Sex
PDF.BirthDate
PAH.Address1
PAH.Address2
PAH.City
PAH.State
PAH.Postal                                                       !Change SP 
02/26/99
J.Action
DT.DESCR        !DeptName
E.Hire_Dt
E.Rehire_Dt
DT.Deptid                              !Added for sqr viewer. (vlm)
    !Added AS 022004
     Let $JobTitle = &JCT.DESCR
     Let $DeptName = &DT.DESCR
     Let $Company = &J.Company
    !End - Added AS 022004
    EVALUATE &J.Action
    WHEN = 'HIR'
................................
................................

Then, I am printing these as -
  PRINT &N.Name                      (+1,  1)
  PRINT $Out                       ( 0, 35)
  PRINT &J.Reg_Temp                  ( 0, 48)
  PRINT &J.Full_Part_Time            ( 0, 55)
  PRINT &J.Empl_Class                ( 0, 66)
................................
................................


I keep getting error -
Error on line 251:
   (SQR 3719) Columns names and expressions must be unique or be given 
unique pseudonyms (&name).
     Let $JobTitle = &JCT.DESCR
(SQR 4407) Referenced variables not defined:

  &dt.descr
  &j.action
  &d.ethnic_group
  &pdf.sex
  &pdf.birthdate
  &pah.address1
  &pah.address2
  &pah.address2
  &pah.city and so on.............


Pl. help.

-Abhay.

_________________________________________________________________
Post Classifieds on MSN classifieds. http://www.sulekha.com/msnclassifieds 
Buy and Sell on MSN Classifieds.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users