wood burning stoves*
The moose likes JDBC 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
Bookmark "Active/Inactive a record" Watch "Active/Inactive a record" New topic
Author

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
Bartender

Joined: Mar 24, 2008
Posts: 3817

And welcome to CodeRanch, Murtaza Lokhandwala


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Active/Inactive a record
 
Similar Threads
Name not found
Make Active n Inactive button using JavaScript
Why not use an ArrayList for caching instead of HashMap?
NX: Questions about deleted records
Dynamic Regular Expression ?