RE: [sqr-users] SQR 3719

["Wood, Stuart" <Stuart.Wood@tfn.com>]

Move your if statements out of the first column, this column is reserved for
fields being selected.

 if isnull(&TK_Emp.People_Soft_Id)
  move &TK_Emp.Emp_id to $h_Emp_Num                                     !DC
<--- get the error on this line
 else
  move &TK_Emp.People_Soft_id to $h_Emp_Num                             !DC
<---- get an SQR3701 on this line 
 endif                                                                   !DC

Hope this helps,

Stu

-----Original Message-----
From: Chrisman, Dan: [mailto:Daniel.E.Chrisman@conocophillips.com]
Sent: Monday, July 28, 2003 10:46 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR 3719


I keep receiving SQR 3719 error on the following code.  I am trying to
modify an SQR program to check for an Emp_num.

begin-procedure Process-Pay-Period

  move   0                  to #Nbr_Of_Empls
  move   '      '           to $h_Emp_Num

begin-SELECT -B10000
TK_Emp.Emp_Id
TK_Emp.Emp_SS
TK_Emp.People_Soft_Id                                                !DC
TK_Emp.Emp_Last_Name||','||TK_Emp.Emp_First_Name &TK_Emp.FullName
TK_Emp.Emp_WorkLocation
B.Work_Lunch_Hrs_Mult
B.Work_Lunch_Pay_Hours
B.Work_Min_CallOut_Hours
B.Work_CallOut_Mult
B.Work_Meal_Allowance

if isnull(&TK_Emp.People_Soft_Id)
  move &TK_Emp.Emp_id to $h_Emp_Num                                     !DC
<--- get the error on this line
else
  move &TK_Emp.People_Soft_id to $h_Emp_Num                             !DC
<---- get an SQR3701 on this line 
endif                                                                   !DC
  move &TK_Emp.Emp_Id            to $h_Emp_Id                           !DC 
  move &TK_Emp.Emp_SS            to $h_SSN
  move &TK_Emp.FullName          to $h_Name
  move &TK_Emp.Emp_WorkLocation  to $h_Emp_WorkLocation
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