RE: [sqr-users] (SQR 4008) Unknown function or variable error...

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

Strange.

Since the do will only be executed if the where conditions are met, you could 
try it another way:

begin-select on-error=9999-sql-error
a2.EMPLID
    do proc_whatever
from  PS_ADM_INTERESTS a2
where a2.EMPLID = $emplid and
      a2.ACAD_CAREER = $AcademicCareer and
      $academiccareer <> 'UG'
end-select

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


-----Original Message-----
From: Marc Pechaitis [mailto:marcpechaitis@softwarearmada.com]
Sent: Thursday, August 07, 2003 4:18 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] (SQR 4008) Unknown function or variable error...


Hello all,
I am trying to use the following code:
 
let $Exist = 'NO'
 
begin-select on-error=9999-sql-error
a2.EMPLID
         let $Exist = 'YES'
from  PS_ADM_INTERESTS a2
where a2.EMPLID          = $emplid
  and a2.ACAD_CAREER     = $AcademicCareer
end-select
 
      if $Exist = 'YES' and $AcademicCareer <> 'UG'
         (removed code for readability)
     end-if
 
 
and am receiving the following error:
 
   (SQR 4008) Unknown function or variable in expression: 'ug'
      if $ExistEmplid = 'YES' and $AcademicCareer <> 'UG'
 
Errors were found in the program file.
 
SQR: Program Aborting.

Any help is appreciated!
Thanks,
Marc

_______________________________________________
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