I have an error in this code, but can't find it.
ValueCount ( ExecuteSQL (
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?