Not using buffering. I'm not sure how that would help?

What I'm trying to do is this:

SELECT myTable
SCAN
  lcPrev = < field from previous record >
  lcNext = < field from next record >
  < do stuff here using current record plus the stuff gathered from other
   records >
ENDSCAN

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
SCAN
  SKIP -1
  lcPrev = mytable.field
  SKIP 2
  lcNext = mytable.field
  SKIP -1
  lcNext = mytable.field
  < do stuff here using current record plus the stuff gathered from other
   records >
ENDSCAN

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?

Thanks,

Michelle


>Why don't you want to move the record pointer? If you are using Optimistic Table buffering, it shouldn't matter.