How to Increment String and Numeric Value with 1

Question

0.00/5 (No votes)

See more:

Hello To All,

I am Working in one windows Application inside that i have one purchase form, In purchase form i have bill no with auto increment.

For Example..

I have bill like SBN001 , SBN002 , SBN003 , SBN004

Now if i delete SBN003 billno i get SBN005 and it's work fine .. But i manually edit that no with SBN003. That Means in my database bill no stored like .

SBN001 , SBN002 , SBN004 , SBN003 now i want to check max no in this 4 bill means get SBN004 as max no and i want to Plus SBN004 with 1 ..

How i can do this please help me..

Thanks Regards

Posted 4-Aug-14 1:46am

Jay1902

Add a Solution

1 solution

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)

Bernhard Hiller · Answer 1 · 2014-08-04T02:02:00

Solution 1

Design problem. Do not use your "bill number" as the identifier and primary key in the database. Use an automatically generated id there. Then you can change the content of the "bill number" column as you like it.

Posted 4-Aug-14 2:02am

Bernhard Hiller

Comments

Jay1902 4-Aug-14 8:22am

i have sales_id as primary key and billno as another filed in my database..