AnsweredAssumed Answered

ExecuteSQL Modification

Question asked by laguna92651 on Dec 26, 2018
Latest reply on Dec 27, 2018 by beverly

I have a script that I am using to do some plotting with C3. I duplicated the script to create a different chart. The original Set Variable works fine but when I change the table from STG_Stages_Interview to EST_Estimates the script step could no longer return a year. I don't see what else could have changed or be required, seems like a straight forward change. Any ideas?

 

Original Statement

Set Variable [$YearMax; Value: ExecuteSQL ( "SELECT Max(\"Year\") FROM STG_Stages_Interview";"";"" )]

 

New Statement

Set Variable [$YearMax; Value:ExecuteSQL ( "SELECT Max(\"Year\") FROM EST_Estimates";"";"" )]

Outcomes