>would you not be better of making code an integer(autoinc) field?
>
>How can I do it ?
>
>if this is a multi user app is there not a (very small) risk of two people updating the table at the same time and getting the same code value ?
>
>Yes it's an application that might have up to 5 computer in a network
>Is there any risk ?
>would you not be better of making code an integer(autoinc) field?
>
>How can I do it ?
>
>if this is a multi user app is there not a (very small) risk of two people updating the table at the same time and getting the same code value ?
>
>Yes it's an application that might have up to 5 computer in a network
>Is there any risk ?

see http://msdn2.microsoft.com/en-us/library/aa976850(VS.71).aspx

there is a risk that two or more users go through that code at the same time and end with the same value for max(code).

n