RE: [sqr-users] Error 3719 and 4407

["the dragon" <ceprn@hotmail.com>]

You have the same selected columns somewhere in your program.

do a search using your editor.

clarl 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

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.

_________________________________________________________________
Click, drag and drop. My MSN is the simple way to design your homepage. 
http://click.atdmt.com/AVE/go/onm00200364ave/direct/01/

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