jrenfrew

ExecuteSQL select variable for repeating field

Discussion created by jrenfrew on Aug 10, 2012
Latest reply on Aug 10, 2012 by 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

Outcomes