>>Just a note: microsoft says that a recno() might work on
>>select - sql statements but they are not supported in any way
>>and may or may not work in the furture. So it is a use at your
>>own risk command. So most programmers tend not to use them
>>for compatiblty reasons.
>
>Where do they say this? How come I missed it?
Vlad, it's in the Help (VFP5, SELECT-SQL, near the bottom:
*** Begin HELP Quote
Be careful when using, in join conditions, functions such as DELETED( ), EOF( ), FOUND( ), RECCOUNT( ), and RECNO( ), which support an optional alias or work area. Including an alias or work area in these functions might yield unexpected results. SELECT doesn’t use your work areas; it performs the equivalent of USE ... AGAIN. Single-table queries that use these functions without an optional alias or work area will return proper results. However, multiple-table queries that use these functions — even without an optional alias or work area — might return unexpected results.
*** End HELP Quote
"If all else fails, try reading the directions....."
Barbara