[RBASE-L] - RE: [BULK] [RBASE-L] - Re: Lookup Variables in Timer

[Charles Parks]

I have changed the variable name but seem to be getting the same result.

SELECT AllowIn, OkayToBeInBGU, KeepStaffOutBGURecNo  +
      INTO fAllowIn INDICATOR fiAllowIn, +
      fOkayToBeInBGU INDICATOR fiOkayToBeInBGU, +
      fKpStfOutBGURecNo INDICATOR fiKpStfOutBGURecNo +
      FROM KeepStaffOutBGU +
      WHERE ForceOut = .fForceOut

I'm using V-8.


________________________________
From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig
Posted At: Tuesday, October 28, 2008 11:40 AM
Posted To: RB7-L
Conversation: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
Subject: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
Importance: Low

<<
 SELECT AllowIn, OkayToBeInBGU, KeepStaffOutBGURecNo  +
      INTO fAllowIn INDICATOR fiAllowIn, +
      fOkayToBeInBGU INDICATOR fiOkayToBeInBGU, +
      fKeepStaffOutBGURecNo INDICATOR fiKeepStaffOutBGURecNo +
      FROM KeepStaffOutBGU +
      WHERE ForceOut = .fForceOut
>>

Charles:

The variable name "fKeepStaffOutBGURecNo" exceeds the R:Base limitation of 
eighteen characters, and is probably causing the SELECT statement to fail.  
Presumabely your're seeing the value in the other variables that you 
initialized elsewhere.
--
Larry