Rob Diamant Posted March 12, 2021 Share Posted March 12, 2021 How do you lookup a key value and add one For example, I have an order and want to lookup the last line item number used and increment it for my insert. Of course if it is a new order, it should return zero. I do not want to use any row counts, since the line numbers may not match the number of rows. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now