File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Active/Inactive a record Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Active/Inactive a record" Watch "Active/Inactive a record" New topic

Active/Inactive a record

Murtaza Lokhandwala
Ranch Hand

Joined: Jan 28, 2010
Posts: 35
Can anybody tell me that how to make a record active/inactive in database using jdbc
Sudheer Bhat
Ranch Hand

Joined: Feb 22, 2011
Posts: 75
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

Joined: Mar 24, 2008
Posts: 3902

And welcome to CodeRanch, Murtaza Lokhandwala

[How to ask questions] [Twitter]
I agree. Here's the link:
subject: Active/Inactive a record
It's not a secret anymore!