General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
David,
see my reply to Mike.
>Regarding Thomas' reply, the seek/replace code is orders of magnitude faster, so in this case the benefit I would get by using scan instead of do while not eof() wouldn't be significant, I don't think. Also, in other benchmarks I've done, I've found that in loops with replaces, the replace statements contribute to the bulk of the processing time, and the looping construct time is negligible. I find the old style do while not eof() more readable. Correct me if you think I'm off base on this.
If it is more readable to you, stay with Do While Eof(). My preference is in the answer to Mike -
but timing differences probably are not that great.
But - I would still argue to get rid of the "go top" before the seek ;-)
regards
thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only