WB15 - Can someone explain why the first method works, but not the second?

Can anyone explain to me why method #1 doesn't work? I know for a fact that there are records that match the query, (I checked it in the hyperfile control center, plus, it works with method #2 below) but I always get a return result of 0 for method #1.

Method #1
HExecuteQuery(QRY_Clients_GetActive)
FOR ALL QRY_Clients_GetActive
//Search for Active Memberships for Client
bDone is boolean = HExecuteQuery(QRY_Memberships_Active_ByDatesNotStatusFlag_withParamContactID,hQueryDefault,...
QRY_Clients_GetActive.GUIDHFContact,Today())
IF bDone = True THEN
i is int = HNbRec(QRY_Memberships_Active_ByDatesNotStatusFlag_withParamContactID)
Trace(i) //Should sometimes return >0, but it doesn't
END
END

Here is the sql code of QRY_Memberships_Active_ByDatesNotStatusFlag_withParamContactID:
SELECT
HFMemberships.GUIDHFMemberships AS GUIDHFMemberships,
HFMemberships.GUIDHFContact AS GUIDHFContact,
HFMemberships.dStartDate AS dStartDate,
HFMemberships.dEndDate AS dEndDate,
HFMemberships.bMembership_Dropped AS bMembership_Dropped
FROM
HFMemberships
WHERE
HFMemberships.bMembership_Dropped 1
AND HFMemberships.dStartDate {ParamTodaysDate}
AND HFMemberships.GUIDHFContact = {ParamContactID}



Method #2 (This method works just fine)
HExecuteQuery(QRY_Clients_GetActive)
FOR ALL QRY_Clients_GetActive
FOR EACH HFMemberships WHERE GUIDHFContact = QRY_Clients_GetActive.GUIDHFContact
IF HFMemberships.dStartDate Today() AND

HFMemberships.bMembership_Dropped 1 THEN
Trace("WE'VE GOT A WINNER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!")
BREAK
ELSE
Trace("0")
END
END
END

I see these two methods as the same, but they don't work the same. Any help would be greatly appreciated.