How to increment the field value based on the previous instance

Question

0.00/5 (No votes)

See more:

Hi,

I have a requirement where in an application, whenever user creates a new instance, it should assign the number value automatically. For Example, If we fill some details and save. Later another person will create a new instance fill the details and save it. then, for the current instance it should the assign the Instance field value to 2 (as previous one is 1).
It should increment based on the previous value.

Please let me know the workflow or how to do it?

What I have tried:

I'm not sure on this how to link up these all thing into one. Any help will be appreciated and thanks in advance.

Posted 19-Jun-16 17:49pm

Member 8010354

Updated 19-Jun-16 19:43pm

Add a Solution

Comments

Maciej Los 20-Jun-16 2:16am

What you mean by "user creates a new instance"? Instance of what: aaplication, object, ...?

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)

OriginalGriff · Answer 1 · 2016-06-19T19:43:00

Generally speaking, don't.
It's possible, but in most cases it's a bad idea. I assume you are using a database of some form, and if so then you will find the capability built into the DB: duplicating that is a recipe for real problems once software gets into production. For a DB, see the SQL IDENTITY field: IDENTITY (Property) (Transact-SQL)[^]