Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
start broswe
- Thread starter ceeja
- Start date
you are at the same place where you started! start sets the ponter to 1st rec. read next actually reads it (and re-positions the pointer to 2nd rec). ReadPrev reads 1st rec again by repositioning pointer. Now we are at the start; so next read-next reads 1st rec!
gregsimpson
Programmer
- Apr 18, 2002
- 521
ceeja,
start sets the pointer to the record.
READ NEXT reads the record and sets the pointer to the next record.
Issuing the READ PREVIOUS will read the same record again, as it's the record previous to the pointer. This effectively puts you back you your start position as regards the pointer.
Not surprisingly, the next READ NEXT reads the same record for a third time.
Cheers
Greg
start sets the pointer to the record.
READ NEXT reads the record and sets the pointer to the next record.
Issuing the READ PREVIOUS will read the same record again, as it's the record previous to the pointer. This effectively puts you back you your start position as regards the pointer.
Not surprisingly, the next READ NEXT reads the same record for a third time.
Cheers
Greg
- Status
Similar threads