3 Replies Latest reply: Jun 11, 2012 12:49 PM by Kent Shook RSS

    One field throwing error during reload

    Kent Shook

      Hi folks,

       

      Got one that's baffling me.

       

      Here's the code:

       

      AllOpenPoints:

      SQL SELECT

          BatchId

          ,DivisionSKey

          ,ValidateEvent

      FROM log.BusinessValidateEvents order by BatchID Desc;

       

      Let vLatestBatch=FieldValue('BatchID',1);

       

      CurrentOpenPoints:

      NoConcatenate Load BatchId,

          DivisionSKey,

          ValidateEvent

      Resident AllOpenPoints where BatchID='$(vLatestBatch)';

       

      For some reason, I'm getting a "Field Not Found" error for BatchID every time I try to use it. However, it *is* pulling in data successfully! I've gotten nothing useful by running it in debug mode, I copied and pasted the code into a text editor to ensure there weren't any invisible characters around the field name... What could be causing this?

       

      Thanks,

       

      Kent