4 Replies Latest reply on Jan 7, 2014 12:12 PM by philmodjunk

    ExecuteSQL error

    c.wagner1

      Title

      ExecuteSQL error

      Post

           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?

            

           Thanks