AnsweredAssumed Answered

ExecuteSQL error

Question asked by c.wagner1 on Jan 7, 2014
Latest reply on Jan 7, 2014 by philmodjunk


ExecuteSQL error


     Hi Guys,

     I have an error in this code, but can't find it.  

     ValueCount ( ExecuteSQL (

         "SELECT \"k_measurementID\"

         FROM coverMeasurements

         WHERE \"fk_lineItemID\" =?

         AND \"userID\" =?";

     ""; ""; ""; "") )

     The expected result is an integer reflecting the number of records where fk_lineItemID and userID are both empty.  Using my sample data the result returned is 0.  If I go to the coverMeasurements layout and preform a find with == in both these fields I get 18 results.  Does anyone see my error?