2 Replies Latest reply on Aug 10, 2012 5:37 AM by jrenfrew

    ExecuteSQL select variable for repeating field

    jrenfrew

      SQL clever people...

       

      Is there a way to get just one repetition of a repeating field by passing a variable in a SQL statement?

       

       

      I have tried

      ExecuteSQL( SELECT "field"[?] ....... ; ""; ""; "1" )

       

      ExecuteSQL( SELECT "field"[?] ....... ; ""; ""; 1 )

       

      Let(

      $i = 1 ;

      ExecuteSQL( SELECT "field"[$i] ....... ; )

       

      None of which work

       

      This is to do with trying NOT to hard code all repetitions, in case this solution adds one later

       

      I can always do

       

      GetValue ( ExecuteSQL( SELECT "field", "field"[1],"field"[2] ....... ; "¶" ; "" ) ; $i ) but would be nicer to do it inside SQL