Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Next and Previous
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00426536
Message ID:
00427275
Vues:
19
>Because I'm scanning, I didn't want to be jumping around for fear of confusing VFP. Do you think I'm safe in doing this:
>
>SELECT myTable
IF !BOF()
>  SKIP -1
>  lcPrev = mytable.field
   ENDIF
ENDIF
SKIP  && back to original
IF !EOF()  && in case you started at EOF()
>  SKIP
   IF !EOF()
>     lcNext = mytable.field
   ENDIF
>  SKIP -1  && back to original record
* I suppose you meant to say lcCurrent instead of lcNext
> * lcNext = mytable.field
>  < do stuff here using current record plus the stuff gathered from other
>   records >

>
>Obviously, I need code to check for the ends of the table, but I wanted to keep it simple for the example. Can I do that without the SCAN losing track of where it is?
>

I don't see why you want a SCAN Michelle. Will that work?
>Thanks,
>
>Michelle
>
>
>>Why don't you want to move the record pointer? If you are using Optimistic Table buffering, it shouldn't matter.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform