>Albert,
>
>I've not tested SQL update on memos, nor via ODBC. You could run a quick test using the code I posted to Fred.
>
>And whoa! I just tested it with exclusive off in VFP6 and reuse goes down the crapper. I'll report this to MS immediately.
>
>>In my testing, it only reuses for a replace, not update and not through ODBC. And only when exclusive use is on. Have you seen different results?
Just saw your note on EXCLUSIVE affecting the results. That is correct, with EXCLUSIVE ON, I match your results, with EXCLUSIVE OFF, you get mine. Thanks for the in-depth analysis. BTW, WHICH version of VFP6 are you running?