RE: [sqr-users] SQR 4407

[Bill Beckner <Bbeckner@icc.edu>]

Just remove the '&' from your WHERE and ORDER BY clauses...they're not
needed there..

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"Failure is not an option...it comes bundled with the software."


-----Original Message-----
From: Chrisman, Dan: [mailto:Daniel.E.Chrisman@conocophillips.com] 
Sent: Tuesday, July 29, 2003 1:16 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR 4407


get the following error when I compile my program,  The field is in the
table definition correctly.  What am I doing wrong?

(SQR 4407) Referenced variables not defined:

  &tk_tsc.amount


here is the code.

 move ' ' to $shift_code
begin-select
TK_TSC.shift_code             &shift_code

 move &shift_code to $shift_code

from TK_TESS_SHIFT_CODES TK_TSC
where &TK_TSC.amount = #old_diff
order by &TK_TSC.amount
end-select


Daniel E. Chrisman
Senior Analyst
Ponca City Refinery
ETN 442.5654
DDE 580.767.5654

_______________________________________________
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