Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scan...EndScan still a problem?
Message
De
12/12/2001 21:04:10
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
12/12/2001 17:34:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00589532
Message ID:
00593677
Vues:
40
>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".

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform