How do I instruct SQL server to lock a specific record, return the data to VFP, and then cater for transaction management?

Clearly, the data will be returned from SQL in the form of a temporary cursor/table, and therefore I have to explictly return the new values to SQL in the form of a stored procedure. This will be a major irritation as some of these tables have 300-400 fields in them.

Also, does this means that record locking would have to be a manual process, i.e. I'd have to use a flag in the SQL database to say "record locked", and reset the flag when the changes have been written back?

Regards

Derek