Hi,
I ran into an interesting problem. Here is the code with the strange results.


SELECT filename.field_1;
FROM filename;
WHERE filename.field_2 = m.condition ;
ORDER BY filename.field_2 INTO ARRAY my_array


The problem is that the array being created by this code contains BOTH FIELD_1 and FIELD_2 information, interspersed in the same column. Very weird. I haven't noticed the error before, so I don't know if it's just some environmental setting that is wrong.

I am able to recreate this problem with both Fox 2.6 DOS and WIN, however, the code performs correctly in VFP 6 and the beta of VFP 7.

At this point, it looks like FoxPro 2.6 cannot handle ordering an array on a field not in the array. If I including the field in the select, I get the expected results, but lots of other code depends on the array having a single column

If you could tell me how to change somthing in the environment, or somewhere to get the SELECT to give the expected results (an array ordered on field_2, containing data only from field_1) I would be greatful.

If you know for certain that this is a bug in fox 2.6 I would also be greatful to know that.

If not, I can think of several work arounds, but thanks for you time anyway.

Thanks.

Daniel