RE: [sqr-users] Error 3719 and 4407

["Knapp, Richard" <KnappR@umsystem.edu>]

Instead of letting SQR use its default column names, add your own.  Make sure 
they are different from all other column names in your program.  The problem is 
with another procedure that has a column called &name.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of abhay sachar
Sent: Monday, February 23, 2004 3:24 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error 3719 and 4407


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

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