Hi Barbara;
Thanks for your time and attention. I'm trying to write a generic routine that will work in all cases, whether using VFP tables or SQL server as the data store. As a rule, the underlying VFP tables are NOT buffered and are NEVER accessed directly - all communication is handled through views. If there's an update conflict, I revert and requery and go at it again.
I'm just trying to understand what's happening under the covers - This may be one of those occasions where I have to branch the logic and handle native differently that SQL, but I hate to do that. Especially when it sounds like it should work first time, every time, when I read through the Online help.
It's starting to feel like a SOLID wall.
Thanks again!
~Erik Folley