Member Avatar for vusa.m.mpofu

I have a table named Machines with fields: MACHINEID, MACHINEName MACHINECode, FACILITY where MACHINEID is a primary key. And i like to create a general stored procedure that does ADD, EDIT and DELETE operations and after updating i want the old record to be kept. How can i do that?

  • 5 Contributors
  • 4 Replies
  • 124 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by pssingh1001
Member Avatar for ChrisHunter

There's a massive amount of tutorials out there that cover what you need to do.

Have a look at these links to:

Insert new record.

Update an existing record.

Delete and existing record.

In the future you need to show us what you have done so we know you have attempted it yourself because the DaniWeb rules state that we can't do you're work for you but only help you and give you advice.

Good luck and let me know if you get stuck.

Member Avatar for adam_k

Instead of a stored procedure, why not use a trigger to keep a track of the changes? It will be a lot easier to track updates and you get access to DELETED and INSERTED.
You can still use the sproc, to do the operations and let the logging to the trigger.

Member Avatar for Lethugs

In deletion part, what I did before was to add a column status on my db, when i delete a record it will add the word 'Deleted" on its status part. The SQL statement in showing records includes where statement with the condition status is NULL, this way those the user thought deleted records are really deleted but inside the database they are present.

Member Avatar for pssingh1001

Hi All !

I have no any idea about stored procedure ;

regards
prem

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.