RE: [sqr-users] Error 3719 and 4407

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

Hi,

I had all the aliases setup correctly, and was not using the variable $name 
anywhere else, it was that I had this too as one of the select fields -
.......................................................
.......................................................
nvl(decode(d.ethnic_group, '1', 'White', '2', 'Black', '3', 'Hispanic', '4', 
'Asian', '5', 'Am. Indian', '6', 'N/A'), ' '),
.......................................................
.......................................................

Prob. one of the special chars in this statement was causing the prob.
It's fixed now.

Thanx all u guys,
Abhay.
>From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
>Reply-To: sqr-users@sqrug.org
>To: "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Error 3719 and 4407
>Date: Mon, 23 Feb 2004 14:32:33 -0800
>
>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

_________________________________________________________________
Oscar fever is on! It's Hollywood's biggest party. 
http://server1.msn.co.in/sp04/oscars/index.asp Get all the dope here.

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