Hi Tamas.

I'd say that you are selecting the data from different tables.

When you do the select on it's own VFP is searching the path for the bp_eng table to select the data from and the one it finds is the one you expect. When you execute this prg with all the code in it, VFP will select from the bp_eng.dbf that is already open, regardless of whether it's on the path or not.

I expect that if you check the paths of the tables it's selecting from you will find that they are different. Or you can remove the when clauses so that all the records are selected, look at the result and see that the data is different and that when your select produces no results it's because the data you have has nothing to select.

Ian Simcock.



>I enclosed the complete content of the prg.
>