consistency check

Functionality discussions and feature requests

Moderators: hugo, alexandre, rmvanarkel

Post Reply

consistency check

Post by jaime »

i have talk about this in the past, but now im tring to implement it.
i need to do this check:
if sum(Debit account) is diferent of sum(loans)+sum(bookeping) echo "error"

im not sure if it would be a mysqldb procedure scenario or not. (maybe a sh script + cron ? )

have anyone done something similar before?
can help with the script/sql ?

thanks in advance,
Post Reply