Dear All<BR><BR>I have an amend screen to update a customers details using SQL server.<BR><BR>I have used "pessimistic" locking when retreiving the record, but I need to<BR>be able to test what state the record is at the server, so that anyone else<BR>trying to retrieve the same record can be taken to a "read only" view of the<BR>record.<BR><BR>Any help would be greatly appreciated.<BR><BR>Cheers<BR>