How to get Next Customer Invoice id from database ?

Question

2.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hello all there,

How i can get an invoice id for my POS next Customer each time i submit my order. I have a field name ID in SQL that is auto increment. But it is generating on the time of submission of database while i need Invoice id on POS on completion of previous customer.

Thanks in advance

Jazaib

Posted 11-Jun-13 11:32am

Jaa Zaib

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-Jun-13 17:36pm

It all depends on how you define "next customer". Next — in what sequence? And, is is single user database? If not, you might be in trouble. Apparently, the user identity should be related to the workflow of the person using the UI. When a user is created, it always have the ID.
—SA

PIEBALDconsult 11-Jun-13 18:02pm

"i need Invoice id on POS on completion of previous customer."

No, you don't. How do you know there'll even be a next customer?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2013-06-11T11:48:00

Solution 1

You cannot reliably get the "next" id from the database in a multiuser system.

Think about it. You have 2 clients going to the database at the same time. Each gets the "next" id from the table. They both try to commit a new invoice to the table. One will work and the other will fail because the ID is already in use.

Posted 11-Jun-13 11:48am

Dave Kreskowiak

Comments

Jaa Zaib 11-Jun-13 17:55pm

Hay Thanks for replying.
Yes i have multi user system. Same problem i am facing when trying to insert records in sales tables. how i can get ride of the problem ??
Thanks

Dave Kreskowiak 11-Jun-13 18:44pm

There is no solution. You cannot get the next record ID. Period.

The only way to get the nxt ID reliably is to insert an invoice.

Ron Beyer · Accepted Answer · 2013-06-11T12:00:00

Solution 2

You could insert a blank record in your database, then use that ID. If they cancel the transaction, delete the record from the database. That's really the only reliable way to reserve an ID in a database thats multi-user.

Posted 11-Jun-13 12:00pm

Ron Beyer