Deleting old Everest log transactions

[Sascha Deri]

One of the ways I used to clean up the Everest SQL database was removing unimportant or old user log transactions. However, a few years ago this snippet of code stopped working:

delete
from  tranhist
where func_id = 10326 and tranhist_date < getdate() - 1 and is_processed = 'T'

The code doesn't error out but always returns a 0 rows changed results. I'm not sure if I accidentally changed the code and saved it wrong. I am essentially SQL illiterate so can't identify the error. Any suggestions? 

[Info Akute]

You may use below

delete from  tranhist where func_id = 10326 and tranhist_date < getdate() - 1

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

--
--
Email sent to Google Groups: "Everest (Icode/Versata) ERP Users Group" group.
 
- Post: evere...@googlegroups.com
- Unsubscribe: everest-erp...@googlegroups.com
- More options: http://groups.google.com/group/everest-erp?hl=en
---
You received this message because you are subscribed to the Google Groups "Everest (Icode/Versata) ERP Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to everest-erp...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/everest-erp/CAKjXqbVMnmZkp94iKR6FvcLoCpMpF%2BbiiDFJ%2Bqxucv1k5b0kpQ%40mail.gmail.com.