>How would I determine whether I need to use optimistic or pessimistic row buffering?
>
>Thanks
>Nick Patel

Nick,

IMHO, I think you can always use optimistic table bufering (Mode 5), If you need to lock any record you can LOCK-it, and you have full manual control over the process, I don't want automatic incontroled stufs.