RE: [sqr-users] Error 3719 and 4407

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

I prefer to use the original (default) column names, so that people reading
the program can relate back to the database tables.  The combination of
errors 3719 and 4407 suggest a close look at the "from" clause of that
select.  Did you put the aliases on each table you used?  Are you using JCT
somewhere else?  Try JCT1 and JCT2.

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu]
Sent: Monday, February 23, 2004 2:02 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Error 3719 and 4407



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

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