Hi all,

I have a questions,

When I set filter to 2 fields on a table. I get 16 records, this is when I do in command window.

When I set the same filter in a program with the same table I get only 4 records.

I have set the delete off and exact off.

Any idea why this could happen?

thanks.