pls help..im working on my inventory for my thesis..
pls help me about the database, i need to save the transaction on the databse and then whenver i saved the data on it, i need to delete it on the other...
the first datatbase is for sold products and the other databse is for available products...pls help
Create a transaction id on both sides.
Then just do a simple update/insert on one side and then do a delete on the other side once the update/insert is successful on the original.
pretty simple task.
is that database or table? please clarify...
if the database is oracle then can use a trigger for the purpose.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.