I am attempting to use Execute SQL in a repeating field in the following way:
In Table1 I have a field (Days365) with 366 repetitions - representing every date including Feb 29th
In Table2 I have a number of records with date fields that then allows me to calculate the repetition number the date corresponds with.
I have set-up the following ExecuteSQL in my repeating field:
ExecuteSQL ( "SELECT Sum(Hours) FROM Table2 WHERE EmpID = ? AND RepNr = ? AND RecYear = ?" ; "" ; ", " ; Table1::E_ID ; Get ( CalculationRepetitionNumber ) ; Table1::Att_Year )
I have also tried Get ( ActiveRepetitionNumber ) in place of Get ( CalculationRepetitionNumber )
I'm not getting any "?'s" as a result so I'm not sure if this is a limitation of FM or is there another way to get the repetition number?