>>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.
Or you can have an extra field in the cursor which would indicate, that record was updated.
If it's not broken, fix it until it is.
My Blog