AnsweredAssumed Answered

ExecuteSql Command

Question asked by Jason_Farnsworth on Mar 2, 2015
Latest reply on Mar 2, 2015 by BruceHerbach

I have a Executesql calculation I am trying to make work and I am going in circles with it


I am currently using


ExecuteSQL ( " SELECT CTR_Warning_Type


WHERE Letter_AGE = 1 " ; "..." ; ""  )


Which gives me a list of all "Warning Types" across all jobs that meet the Letter_Age = 1 requirement. I am performing this calculation in a job table, Field.


What I would like to realize is...


Only the "Warning Types" for that job (not all jobs) that meet the Letter_Age = 1 requirement.


What am I doing wrong? Should I not be using this via a Field Calculation?


Thanks in advance,


Jason Farnsworth