Member Avatar for bryt

Someone created a point of sale for a supermarket. Now i need to track all deletions made. We use f10 key to delete an entry.

Can someone please help me with an idea or solution?

Thanks in advance, your help will be highly appreciated.

  • 3 Contributors
  • 2 Replies
  • 77 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by DenisOxon
Member Avatar for AndreRet

We will have to get some more information from you.

What database is used, what fields in the table when deleting
Is the user deleting on the system, in other words in the database?

Are you using VB6?

Member Avatar for DenisOxon

Hi

I agree with AndreRet, but two suggestions to think about

1) Put an extra field on database table so when f10 pressed record is maked as deleted, but is not actually deleted. You then need to make sure these records are not selected in other parts of the system.

2) Have a deleted record table, which has same fields, but when f10 pressed you moves record to thi table.

Denis

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.