Good Day Experts!
I have been tasked with creating a VB.Net version of some VB6 code. It is conceptually simple but I am not sure how to attain it in VB.Net. I have a SQL table with 1 field that is numeric...it is NextOrderID.
I have to Select that NextOrderID to use but then Update in the same statement for the next person to use.
Is there a simple way to do this all in one statement?
Please ask questions as I probably didn't explain it very well.