>So the Docs in Foxpro for SCOPE really need a warning note saying
>
>
The use of RECORD in any SCOPE clause (REPLACE, LOCATE, GO, SCAN etc) will ignore any FILTER setting>
>Try this one...
>USE Foxuser AGAIN
>SET FILTER TO RECNO() # 10
>SCAN RECORD 10
> ? RECNO()
>ENDSCAN
>USE
>* LOL
>
>I bet you never tried RECORD on a SCAN!
I used only the Next n clause, though. I had some code which changed the foreign key on a bunch of child record, so the fastest I could do was
set order to fk
seek cFk
calc min(recno()), max(recno()) to mn, mx while fk=cFk
set orde to 0
go mn
scan next mx-mn+1
repl fk with cNewFk
ends
set order to fk
Didn't bother to put the <pre> tag here, this is off-the-top-of-my-head pseudocode anyway.
>Hey, "Pal" is fine. We don't really use "mate". Sounds like sex to me :-)
And talking about sex, I was amazed that on any form (and I've had the displeasure of filling few hundred of those in recent years) when there's the "Sex" label, you only get to choose between "male" and "female", there's no choice of "yes".