John:

Here is a very simple example of an update SP on SQL Server. The data class (VFP client) will generate the field values as parameters and pass it into the SP as a comma delimited string.


CREATE PROCEDURE spUpdateSomeTable(
@primarykey_sometable int,
@field1 varchar(30),
@field2 char(5),
@field3 datetime)
AS
update SomeTable set
field1 = @field1,
field2 = @field2,
field3 = @field3
where primarykey_sometable = @primarykey_sometable

Regards,
Charlie