By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Problem with Inserting a record

P: 21
Hai everybody,

i like to insert some records into database from html form by entering data.my problem is how can i check , whether a record is available in database about a particular employee before inserting. if a employee record is available(for example based on employee num) , then if i try to insert again with that employee id, it should not enter into database(avoid duplicate records with same employee num)

can any one help me please, what should be the query.I am using java for inserting records and IDE is NETBEANS5.5
Jun 5 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hai everybody,

i like to insert some records into database from html form by entering data.my problem is how can i check , whether a record is available in database about a particular employee before inserting. if a employee record is available(for example based on employee num) , then if i try to insert again with that employee id, it should not enter into database(avoid duplicate records with same employee num)

can any one help me please, what should be the query.I am using java for inserting records and IDE is NETBEANS5.5
If you set the indexed property of the employee num field in the access database to Yes (No Duplicates) then Access will not allow the duplicate record to be added.
Jun 6 '07 #2

P: 21
If you set the indexed property of the employee num field in the access database to Yes (No Duplicates) then Access will not allow the duplicate record to be added.
Hai mmccarthy

Thanks for your answer, even i tried with access, i got the solution as u said. now its working perfectly. thanks for ur valuable time
Jun 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Hai mmccarthy

Thanks for your answer, even i tried with access, i got the solution as u said. now its working perfectly. thanks for ur valuable time
You're welcome.
Jun 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.