>No, it has more records, I tested this, it works in VFP environment, but doesn't in compiled version.

If this is done in a program in default DS, then it could be difference in IDE settings and VFP exe if not explicitly specified.

Take a look at SET ANSI and SET DELETED.