Hi!
Nice to know that variable assignment and updating are in the same lock so no conflicts between users. Thanks!
>There's a cleaner way. You can use UPDATE to increment and fetch the value without have to explicitly manage the locks:
>
>UPDATE id
>SET @nnid = idval, idval = idval + 1
>WHERE keyname = @tcKeyWord
>
>-Mike
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.