AnsweredAssumed Answered

Syntax Error ExecuteSQL

Question asked by mikeo'neil on Jan 10, 2018
Latest reply on Jan 11, 2018 by mikeo'neil

Hi Folks,

 

I need some assistance with this ExecuteSQL Calculation. The last line is where the problem is located. I tried this in the data viewer and it advises a Syntax Error that I have not been able to solve. I do not know if there is a limit on using the GTN & GFN functions or its just a simple " or )?

 

 

ExecuteSQL (

 

"SELECT COUNT ("& GFN (PT_Outcome::Type_Call) &")

 

  FROM " & GTN (PT_Outcome::Z_UID) & "

 

  WHERE ("& GFN( PT_Outcome::Type_Call) & ")  = 'Cardiac Arrest'

 

GROUP BY   ("& GFN (PT_Outcome::Shift) & ") " ; "" ; "" )

 

Thanks-Mike

Outcomes