>How do I recall a specific record in a table that has been deleted? My table has a primary key (e_id) that I need to lookup by, and then restore that record.
>
>Thanks
>Nick Patel
Your question itself was already answered.
However, in general, I find it practical to consider deleted records as "gone".
In other words, once the user confirms he wants to delete the record, your program need not provide a mechanism to recover them.
In emergency situations, of course, the programmer might do some maintenance - directly from the command window. But these emergencies should be rare.
If you distribute your application to hundreds of clients, this is not practical - in this case, the instruction should be something like: "to recover deleted data, you have to restore from your backup".
Finally, you should enable referential integrity. Thus, a record that has related data in other records CAN NOT be deleted.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)