Hi,
Can anybody point me in the direction of an discussion that i have read here.
The discussion was about the best way to get a next value from a table (autonumbering table) that was bulletproof solid tested.
I have seen the code that was written by Jeff Moden on this topic but i can't seem to find it anymore
Me needs :
i have an autonumerbering table with several columns, each column holding the last used value for a certain item, like , invoicenbr, transportnr, ticketnbr tec..
i want a procedure that can get me the last value of a desired columns without the possibility of any other routine getting the same number at the same time and this with a minimal time of locking, have to be lightning fast 🙂
Tnx in advance,
Eddy