Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Active/Inactive a record

 
Murtaza Lokhandwala
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anybody tell me that how to make a record active/inactive in database using jdbc
 
Sudheer Bhat
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I dont think any DB has any in built flag to mark a record as active/inactive. Its something the DB user has to do. Either you have to flag your record as inactive, or end date a record or design some way to mark a record as active/inactive. But in any of these cases, you have to take care of marking the row as inactive/active. From jdbc, you will issue an update statement to do so.
 
Vijitha Kumara
Bartender
Posts: 3913
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And welcome to CodeRanch, Murtaza Lokhandwala
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic