RE: [sqr-users] Columns names and expressions must be unique or be given unique pseudonyms

["Bill Winkfield" <bwinkfield@gia.edu>]

You will need to remove the commas from the column names, which are not
valid within your sqr select.


-----Original Message-----
From: Marc Pechaitis [mailto:marcpechaitis@softwarearmada.com] 
Sent: Thursday, September 04, 2003 10:01 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Columns names and expressions must be unique or be
given unique pseudonyms

The following sql statement:
 

begin-procedure STF068-CHECK-EXIST-GEN-MATLS
 
let $Procedure = 'STF068-CHECK-EXIST-GEN-MATLS'
 
#debugb show 'in STF068-CHECK-EXIST-GEN-MATLS'
!verify that the existing data will not be overwritten with blanks
begin-select on-error=9999-SQL-ERROR
 
GM_GET1.NAME,
GM_GET1.TITLE,
GM_GET1.DESCR_EXT_ORG,
GM_GET1.COUNTRY,
GM_GET1.ADDRESS1,
GM_GET1.ADDRESS2,
GM_GET1.CITY,
GM_GET1.STATE,
GM_GET1.POSTAL,
GM_GET1.PHONE
 
 move &GM_GET1.NAME          to $ExistName
 move &GM_GET1.TITLE         to $ExistTitle
 move &GM_GET1.DESCR_EXT_ORG to $ExistExtOrg
 move &GM_GET1.COUNTRY       to $ExistCountry
 move &GM_GET1.ADDRESS1      to $ExistAddress1
 move &GM_GET1.ADDRESS2      to $ExistAddress2
 move &GM_GET1.CITY          to $ExistCity
 move &GM_GET1.STATE         to $ExistState
 move &GM_GET1.POSTAL        to $ExistPostal
 move &GM_GET1.PHONE     to $ExistPhone
 
 ! check that the incoming AY data is not blank.
 ! if it is, use the existing data.
 
 if IsBlank($SuspNameFull) ! ie was blank
  let $SuspNameFull = $ExistName
 end-if
    
 if IsBlank($SuspRecomTitle) ! ie was blank
  let $SuspRecomTitle = $ExistTitle
 end-if
 
 if IsBlank($SuspRecomExtOrg) ! ie was blank
  let $SuspRecomExtOrg = $ExistExtOrg
 end-if
    
 if IsBlank($SuspRecomCountry) ! ie was blank
  let $SuspRecomCountry = $ExistCountry
 end-if
    
 if IsBlank($SuspRecomAddr1) ! ie was blank
  let $SuspRecomAddr1 = $ExistAddr1
 end-if
    
 if IsBlank($SuspRecomAddr2) ! ie was blank
  let $SuspRecomAddr2 = $ExistAddr2
 end-if
    
 if IsBlank($SuspRecomCity) ! ie was blank
  let $SuspRecomCity = $ExistCity
 end-if
    
 if IsBlank($SuspRecomState) ! ie was blank
  let $SuspRecomState = $ExistState
 end-if
    
 if IsBlank($SuspRecomPostal) ! ie was blank
  let $SuspRecomPostal = $ExistPostal
 end-if
    
 if IsBlank($SuspRecomPhone) ! ie was blank
  let $SuspRecomPhone = $ExistPostal
 end-if
    
from PS_GENL_MATERIALS GM_GET1
where GM_GET1.EMPLID = $Match_Emplid
and GM_GET1.STF_AY_EXTSYSID = $RECMID
 
end-select
end-procedure

 
 
Is generating the following errors:
 

Error in include file "u:\sqr\stf068.sqc" on line 1092:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.NAME,
 
Error in include file "u:\sqr\stf068.sqc" on line 1093:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.TITLE,
 
Error in include file "u:\sqr\stf068.sqc" on line 1094:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.DESCR_EXT_ORG,
 
Error in include file "u:\sqr\stf068.sqc" on line 1095:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.COUNTRY,
 
Error in include file "u:\sqr\stf068.sqc" on line 1096:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.ADDRESS1,
 
Error in include file "u:\sqr\stf068.sqc" on line 1097:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.ADDRESS2,
 
Error in include file "u:\sqr\stf068.sqc" on line 1098:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.CITY,
 
Error in include file "u:\sqr\stf068.sqc" on line 1099:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.STATE,
 
Error in include file "u:\sqr\stf068.sqc" on line 1100:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.POSTAL,
 
Error in include file "u:\sqr\stf068.sqc" on line 1101:
   (SQR 3719) Columns names and expressions must be unique or be given
unique pseudonyms (&name).
GM_GET1.PHONE
 
Errors were found in the program file.
 
SQR: Program Aborting.

 
 
 
 
Would anyone be able to point me in the right direction towards why?

_______________________________________________
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