>Actually, I heard that sometimes RV's can be faster than SPT because TABLEUPDATE() is a low-level VFP function creating all your SQL update commands for you. In the time it takes for you to create your SQL update strings and all the other things TABLEUPDATE() does you could be worse off. I've never compared the two, just something to think about.
>
>Charlie


We wrote a routine which mimics the TABLEUPDATE (because we are not using RV's). What we found was that if varied. The smaller the set of updates, the faster our routine was over TABLEUPDATE. When you got into updating thousands of rows, the TABLEUPDATE became faster.

GeneS