Multiple users doing some operations on single table, missing few records in the table

Question

0.00/5 (No votes)

See more:

Dear

All,

I am going to insert one record into the database (ex: table name : Student) by using a web application, here when am going to insert i will generate one RefNumber basing on the count of records +1 in that table and this RefNumber also inserted into the Student table. Fine, Here my problem is when two users accessing the same table going to insert a record into the Student table that RefNumber is missing to generate. So the problem is Same RefNumber is allocated to the two Students. Please let me know, how to handle two users accesing same table at same time.

I hope you all understand my problem. If anybody have an idea about this kind of issue let me know, it may helpful to me.

In Advance

Thanks and Regards,

Maria Vinod Bheemisetty

Posted 13-Nov-12 18:12pm

Maria Vinod

Add a Solution

Comments

Shanalal Kasim 14-Nov-12 0:18am

RefNumber is Student Table column?
Which table count your taking?

Maria Vinod 14-Nov-12 0:36am

Yes, RefNumber is also one of the column of "Student" table, am getting the count of the same table +1 as RefNumber and inserting this RefNumber updating in the same table.

SoumenBanerjee 14-Nov-12 0:44am

You can set RefNumber as Auincremented rather than count of records +1

__TR__ 14-Nov-12 0:52am

You can use the IDENTITY Property[^] to auto generate numbers.

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)

Shanalal Kasim · Answer 1 · 2012-11-13T18:47:00

Solution 1

In change your sql like below

SQL

Insert into student (RefNumber ) values ((Select count(RefNumber)+1 from student))

Or

Set Identity

Refer: http://msdn.microsoft.com/en-us/library/aa933196(v=sql.80).aspx[^]

Posted 13-Nov-12 18:47pm

Shanalal Kasim

Updated 13-Nov-12 18:50pm

v2