1) Create a simple TkbmMemTable with fields Enabled (Boolean) and RateCodeID (Integer),
2) Fill it with a single record with values Enabled = True,RateCodeID = 1,
3) Attach it to a TVirtualQuery, and issue the the following SQL statement:

SELECT Enabled FROM Test WHERE RateCodeID = 1

TVirtualQuery returns an empty data set.

4) If I use the TkbmMemTable's Locate() method, it finds the record. See sample test code below:

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next VirtualDAC build. The links to download VirtualDAC night build with the made fixes were sent to your email