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

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

There may be something missing in your presentation of the problem.  You
show us code that says "if $Exist = 'YES'" but the error message says "if
$ExistEmplid = 'YES'".  Either it is referring to another part of the
program, or your cut-and-paste to your e-mail message isn't right.  I also
would like to see the first line of code you removed for readability.  It
could be that the SQR compiler is combining it with "$AcademicCareer <>
'UG'".

-----Original Message-----
From: Marc Pechaitis [mailto:marcpechaitis@softwarearmada.com]
Sent: Thursday, August 07, 2003 2: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