VFP 6.0

Regarding RECORD OPTIMISTIC, my question is if no one else is looking at the same record in the network and the end-user attempts to update the changes, this would AUTOMATICALLY lock the record and then update the data. Would it still remain LOCKED and thus, I would have to issue UNLOCK command?

If someone is looking at the record and the other end-user attempt to update that record, would that still update the record without any error or warning? Just that the person that is viewing the data would have the "old" data and once the person leaves the record and come back, it will be updated then.

I am still having trouble trying to set the VFP 6.0 Options to make all my projects allow the end-user to jump around the fields in a form (or grid or browse or whatever) and not be bothered with each "Field validation" that would not let the end-user leave that field until it is correct (meaning can not be left blank and then come back, or typing something weird and then come back). The MS book says "In the Table tab of the Table Designer, enter the rule and error message you want in the Rule and Message boxes.", where's that? I want to do record-level validation.

Lastly, opinions, is this the general way for "business-like" applications?

Chuck