John:

>>Are you saying the SP somehow knows what fields have changed and only gets >>those fields passed as parameters, without extra code at the client end?

No. Its the job of the data access class framework (VFP subclasses of the cusor and data environment objects) that take care of all this kind of stuff. Once they have determined the necessary course of action, they pass as parameters to the SP only the values that have changed or a primary key only in the case of a delete.


Regards
Charlie