3 Replies Latest reply on Feb 21, 2013 9:28 AM by philmodjunk

    Repeat Fields and ExecuteSQL



      Repeat Fields and ExecuteSQL



           I'm trying to create a calculation field that repeats twelve times ( one for each month ), by using the new sql function:


           T=ExecuteSQL ( 
           "SELECT sum(Total)
            FROM Details
            WHERE \"Year\"=? and \"Month\"=? and CID=? and HC=?"
            ; "" ; "" ; Details::sYear;Get ( CalculationRepetitionNumber );CID;HC)];
           This only gives answer in first rep and zeros in all others. The Extend function only seems to work directly with fields.
           Any Ideas?