>>Again, do you mean the scan and seek-replace method (seems quite inefficient) or something more efficient? I was, of course, well aware of the potential solution of doing it this way, in the first place, but I was wondering if there were a "sneakier" way that I hadn't considered/come across.
>>
>>Secondly, as I said, I am not aware that you can include a select-SQL statement into an update statement in VFP7. The Help does not show you how and I don't know the proper syntax to do it, if you can (I've tried various permutations and can't get past the "unrecognised command" error.
>
>You could make grid/cursor/scan/replace looking contemporary by applying table buffering to the cursor and using GetNextModified() when 'scanning' the cursor on save point.
I guess that would be quicker than scan all and seek orig table. Good idea
Thanks
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.