Code: Select all
SELECT Factor FROM OutworkInput
WHERE EstimateID =(SELECT EstimateID FROM MainJobDetails WHERE JobNo = '[Job.NameProper]') AND
Code NOT IN ('LF_FREIGHT_01', 'LF_FREIGHT_02','LF_FREIGHT_03', 'LF_FREIGHT_04','E_INSTALL','DIG_PRO_CLICK')
Displays 1 for the test file with Outwork. Displays "SQL statement executed successfully but returned no value or information" for files with no outwork. - This is what I expect as so in both cases it's executing and working, giving me the value I'm looking for or nothing.
You can see the errors start as soon as I OK. The black non-error message was produced when I was in the build window, the red errors start as soon as I OK.
Subsequently I never receive a 1 so always have a false