[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQR 4407

You don't need, and can't have, a "&" for a field in the "where" clause or
the "order by" clause of the select statement that has that table in the
"from" clause.

-----Original Message-----
From: Chrisman, Dan: [mailto:Daniel.E.Chrisman@conocophillips.com]
Sent: Tuesday, July 29, 2003 11:16 AM
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