Hi Bob
Do you mean mean something like this?
SELECT bigtable
SEEK particularvalue
DO WHILE FOUND()
REPLACE numericfield WITH newvalue IN bigtable
SEEK particularvalue
ENDDO
or this...
SELECT bigtable
SET ORDER TO 0
REPLACE numericfield with newvalue FOR numericfield = particularvalue IN bigtaqble
Since you have an index on numericfield, Rushmore Optimization should kick in. It won't be as fast as the seek, but it should be close since there're fewer lines of code than the seek method.
>sergey,
>
>I would like to follow your suggestion but the table in quetsion is very large and I have a program that is seeking groups of records indexed by a particular value in the index field - if i do a search in physical order rather than in index order the process will take 10 times longer, which is why I was looking for a means to stop the table index being updated until the whole process is finished.