In inventory project vb & sql server
I have to check for product at end of each month with qty (stock) &
Calculated qty( the current month transaction).
I am not familier with Transaction & rollback
How to resolve this
like if stock qty= calculated qty
do the transacton
else
roll back
there are
more than 5000 Products so on error
how to pause it , do the correction & Resume
Any link on transaction rollback would be highly appreciated
-M
I have to check for product at end of each month with qty (stock) &
Calculated qty( the current month transaction).
I am not familier with Transaction & rollback
How to resolve this
like if stock qty= calculated qty
do the transacton
else
roll back
there are
more than 5000 Products so on error
how to pause it , do the correction & Resume
Any link on transaction rollback would be highly appreciated
-M