Click here to Skip to main content
Search within:



Next

Need java code for setting specific values in that column in database
Sign Up to vote bad
good
See more: JavaJDBC
I connected a MS Access database with java code and now I want only specific values in database must be set, else it must throw an error with the details of that field
Posted 21 Dec '12 - 1:24
alexpandy1317
Add a Solution

Comments
Richard MacCutchan - 21 Dec '12 - 7:35
And what is the problem?
alexpandy1 - 21 Dec '12 - 7:52
In my database only specific values in particular columns should be displayed if there is different values, then it must generate a report with its record number
Richard MacCutchan - 21 Dec '12 - 8:09
So exactly what help are you asking for? No one can guess what these values are that you are talking about, or how you are supposed to check if they are valid.
joshrduncan2012 - 21 Dec '12 - 9:02
No one will provide the code unless we see some effort on your part first.

1 solution

Check out the Case-Statements for the SQL. I guess that's what you need pretty much.
 
http://www.tizag.com/sqlTutorial/sqlcase.php[^]
 
have fun.
  Permalink  
Posted 22 Dec '12 - 21:44
TorstenH.29.3K
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 286
1 Mohammed Hameed 208
2 Sergey Alexandrovich Kryukov 188
3 Santhosh G_ 108
4 Mayur_Panchal 98
0 Sergey Alexandrovich Kryukov 8,216
1 OriginalGriff 6,271
2 CPallini 3,528
3 Rohan Leuva 2,703
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 23 Dec 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid