AnsweredAssumed Answered

ExecuteSQL Funky Results

Question asked by 4cardsman on Dec 21, 2017
Latest reply on Dec 21, 2017 by beverly

ExecuteSQL

("Select Count(ContestantTender)  from PlayTables, PSession Where FKSessionID = SessionID And PlayDate = ?  And TimeOfDay = ? "; "" ;"" ; GetAsDate (GetValue ($$Date ; $Counter)) ; $Shift )

returns incorrect results.  The count is wrong.
If I leave out Count and just query for ContestantTender, it returns the correct number of results.  I can use PatternCount to extract the correct count, but it is slow.  Is the select statement incorrect?

 

 

 

Outcomes