MySQL Forums
Forum List  »  Newbie

Re: Copying a SUM Value
Posted by: Barry Galbraith
Date: February 27, 2023 04:06PM

OK. Which row do you want to write the total tax to? Every row?
You say the value will change as more items are added to an invoice. Then just calculate the total tax when you retrieve the invoice fields for display. If you store that value, then it must be updated every time there's a change. Leaves it open to being wrong. If you calculate when it's retrieved for display then it will always be right.

Good luck,

Options: ReplyQuote

Written By
February 27, 2023 02:29PM
February 27, 2023 03:23PM
February 27, 2023 03:53PM
Re: Copying a SUM Value
February 27, 2023 04:06PM
February 27, 2023 06:00PM
February 27, 2023 07:12PM
February 28, 2023 05:44AM
February 28, 2023 10:08AM
March 01, 2023 09:23AM
March 01, 2023 09:34AM
March 02, 2023 05:28AM
March 02, 2023 01:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.