>>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?
>
>>P.S.> the fastest way I found on replacing a field like this is:
>> OPEN TABLE ONE ORDER 'UNIQUE TAG' IN 0
>> OPEN TABLE TWO IN 0
>> SET RELATION TO 'UNIQUE TAG' INTO ONE
>> REPLACE ALL ONE.FIELD WITH 'SOMETHING'
>
>Are you sure this works? :)
>
>Vlad
Since Barbara told you where to look for the warning. I won't
But the code with the relationship has work fine for me. I
found it is faster than doing a
SCAN
seek
replace
endscan
Charles
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers