Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Next and Previous
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00426536
Message ID:
00427275
Views:
18
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform