The solution of adding a column es very good, but you can create a table to keep the closed tickets(deleted) and if you want to reopen it, just look it in that table and recreate it. Assuming that the quantity of reopened tickets is small this will work for you
Luck -----Original Message----- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Post, Ethan" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 5:08 PM To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Subject: RE: Ticket tracking system Manager to David... "David, this is your manager speaking. Larry says he opened 10 tickets last month to get the Brady report fixed. Is that true?" ok enough of that let's ponder some possible solutions... 1. Have everyone print out a copy of their ticket and then submit it back to you to re-enter if they want to re-open it. 2. Use log miner to log your archive logs. Find the SQL to recreate the ticket then run it again against the database. 3. This one is really just a better idea for #1...have everyone do a print screen of each ticket then create a database that allows people to upload the picture of the ticket. Save those and you can refer to them if you need to re-create a ticket. 4. This last solution is really dumb but also might work...instead of deleting the record perhaps you could just add a status column to the table and then mark it as closed. Then you could re-open it using an update statement. - Ethan -----Original Message----- Sent: Tuesday, April 02, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).