 |  |  |  |  |  |  |  |
About Unique Constraint
Please support our Java advertiser: Programming Forums - DaniWeb Sister Site
 |
Hello,
I want to check uniqueness of id at the time of entry only.And I want to give message to the user at that time only.How to do this?
I want to check uniqueness of id at the time of entry only.And I want to give message to the user at that time only.How to do this?
•
•
Join Date: Jul 2007
Posts: 1,175
Reputation: 
Solved Threads: 125
Either you generate the Id and assign it to the user yourself using an autoincrement or a UUID feature, but if you want the user to select his own ID you will have to perform a check in your records (database or files) to check if the ID has already been chosen by someone else.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
•
•
Originally Posted by stephen84s 
Either you generate the Id and assign it to the user yourself using an autoincrement or a UUID feature, but if you want the user to select his own ID you will have to perform a check in your records (database or files) to check if the ID has already been chosen by someone else.
yes.. but the problem is where should I perform this check,so that I can immediately inform user abt constraint violation.
•
•
Join Date: Jul 2007
Posts: 1,175
Reputation:
Solved Threads: 125
That depends, what are you working on right now, what type of application is it ? A web page, Swing form ? You want specific answers but you haven't yet given details specific to your application.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
|
Similar Threads
- Database schema for a store (Database Design)
- Help Understanding Constraints (Database Design)
- can u please tel how to make a particular column unique (MS SQL)
- Constraint Help Please (Oracle)
- UNIQUE vs. DISTINCT (Database Design)
- Its really a problem on INSERT statement (MySQL)
- Question about SELECT statement (MySQL)
Other Threads in the Java Forum
- Previous Thread: BoxLayout question
- Next Thread: Help with Flight management system
| Thread Tools | Search this Thread |
Latest Java Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Java
android api appinventor apple applet application arc arguments array arrays automation binary bluetooth c++ chat class classes client code codesnippet compiler component csv database doctype draw ebook eclipse error event exception fractal freeze game givemetehcodez graphics gui html ide image input integer intellij iphone j2me java java.xls javaprojects jni jpanel julia linux list login loop loops mac map method methods mobile netbeans newbie number online oracle page parameter print problem program programming project recursion reporting rotatetext scanner screen server set size sms socket sort sourcelabs sql string superclass swing system template test testautomation threads time title tree tutorial-sample windows working
