How do you prevent a scan from skipping records
If I have a table with an index on a character
field 'cfield'. During the scan I update the
cfield, with the index on of course, this changes
the postion of the record in the table. The scan goes
to the next record, but the next record has changed
because the cfield was updated. Does this make sense? lol.
How do you stop this from happening.
Thanks,
Dan