>>>I worry now that this isn't optimized since it's using LIKE (it's now a substring search).
>>
>>Somebody might call me on this, but I don't think the ODBC driver uses Rushmore anyway.
>
>I hope it does.... I was thinking that it wouldn't take that much to inlude Rushmore since Jet is included in the Access ODBC engine. Of course, that's all speculation on my part.
>
>Also, I when I do my SQL update (see our long thread on 'Am I Misusing Tableupdate?') from VFP remote view to a VFP table, the status bar says 'updated 1 record in 0.00 seconds', only Rushmore says that, right?
I think the UPDATE command says that, but if you are getting result times of 0.00 seconds, it sounds like it is being optimized.
Erik Moore
Clientelligence