I am trying to learn the ExecuteSQL step and its not going too well. I am trying to use this to SUM and COUNT some number fields in a database rewrite. What I would like to do is to Set a Global Field with a COUNT of values contained in a field. The contents in this number field contains a null, zero, or a 1 for a value. I also have a calculation field that contains either a zero or a 1 that I would like to SUM.
Table name: Pt_Follow_Up
Field Name: Cardiac_Alert_n
Field Name: CNT_ROSC
I have created a script to Set a field with the below ExecuteSQL step but receive a “?”.
ExecuteSQL ( "SELECT COUNT PT_Follow_Up::Cardiac_Alert_n"; COUNT(PT_Follow_Up::Cardiac_Alert_n) ; "" ; "" ; "")
ExecuteSQL ( "SELECT SUM PT_Follow_Up::CNT_ROSC"; SUM(PT_Follow_Up::CNT_ROSC) ; "" ; "" ; "")
What am I missing…?
I have looked through some examples but have not found a decent explanation or examples.