BTW, I got an invitation for a 30 days course on this topic (~$170 for members, ~$200 for non-members) by Kalen Delaney. Just thought I'll pass it on also
http://www.vconferenceonline.com/event/home.aspx?id=418

>I want to introduce some form of locking (or alternative if locking is not best practise) to ensure that Two users dont update same Table/Tables at the same time.
>
>I have the following VFP code which has worked fine .... would be interested on how this would be coded in TSql
>
>Do while .T.
> Sele MyAlias
> If Flock()
> && Do some processing which needs exclusive use of the table
> Sele MyAlias
> Replace MyField with MyValue Or Append Blank and Replace etc depending on circumstances
> Unlock
> Exit
> Else
> Wait Window "Please wait ... waiting to Lock MyAlias" Nowait
> Endif
>Enddo
>Wait Clear
>
>Would be interested on what code is required to replicate the above functionality in TSql or C#
>
>Tia
>Gerard