>I want to write a VFP stored procedure to add and update a record.
>
>My concern is that there are lots of fields in the table, and to write a SQL UPDATE
>command in a stored procedure would require a parameter for each field.
>
>Is there a simpler way to do this?

You could send a single object to your stored procedure where object has members for the ones you want to update. ie:

use customer
cursorsetprop("buffering",5,"customer")
go 5

oRec = CREATEOBJECT("empty")
ADDPROPERTY(oRec,"Company","My Company")
ADDPROPERTY(oRec,"Contact","My Contact")

gather name oRec
go 7
gather name oRec
browse
tablerevert(.t.,"customer")
use

Cetin