>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