Nick Austen

ExecuteSQL - using a variable as target select from field

Discussion created by Nick Austen on Aug 15, 2016
Latest reply on Aug 16, 2016 by Nick Austen

Hi all

I've been following Soliant Consulting's dynamic charting tutorial (http://www.soliantconsulting.com/blog/2014/05/dynamic-charting-filemaker)

Very useful technique!

 

My question is - can i use a variable as in ExecuteSQL in the following way to dynamically choose which column to select from? (using the same structure as in the posting above here):

 

Let ([_Row = 1;

_Item = GetValue (GLOBALS::g_ModelsToShow ; _Row );

$_Measure = GLOBALS::g_MeasureToShow

];

ExecuteSQL("

SELECT $_Measure

FROM Forecast_Data

WHERE ModelName = ?

ORDER BY MonthNumber"

;"";"";_Item)

)

Outcomes