List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 2 2010 8:58pm
Subject:RE: Best method to keep totals
View as plain text  
>-----Original Message-----
>From: Jan Steinman [mailto:Jan@stripped]
>Sent: Thursday, September 02, 2010 1:52 PM
>To: mysql@stripped
>Subject: RE: Best method to keep totals
>
>> From: "Jerry Schwartz" <jerry@stripped>
>>
>> IMNSHO, never store dynamic data in a field unless you absolutely have to.
>
>I agree, and yet, it's so darned handy if it's a calculation you need quite
>often.
>
[JS] You run the risk of introducing inconsistencies.

>In FileMaker Pro (hold the "boos," please :-) you can have calculated 
>fields --
>a "pseudo field" that holds references to other fields in an equation.
>
[JS] I've used similar products. I suspect that the calculations are done on 
demand just as they would be with MySQL.

>To do something similar in MySQL, I've used views (which is somewhat clumsy),
>but is there a better way? Or is this necessarily part of domain knowledge
>programming in your interface language?
>
[JS] Wouldn't the appropriate place for the calculation be in whatever queries 
retrieve the data, or in a store procedure that they share? That's basically 
the same as a calculated field.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com



>----------------
>
>:::: Jan Steinman, EcoReality Co-op ::::
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




Thread
Best method to keep totalsTompkins Neil1 Sep
  • RE: Best method to keep totalsJerry Schwartz1 Sep
    • Re: Best method to keep totalsTompkins Neil1 Sep
  • Re: Best method to keep totalsJangita3 Sep
    • Re: Best method to keep totalsArthur Fuller3 Sep
      • Re: Best method to keep totalsMark Goodge3 Sep
        • Re: Best method to keep totalsArthur Fuller4 Sep
          • Re: Best method to keep totalsNeil Tompkins5 Sep
            • Re: Best method to keep totalsTompkins Neil6 Sep
RE: Best method to keep totalsJan Steinman2 Sep
  • RE: Best method to keep totalsJerry Schwartz2 Sep
    • Re: Best method to keep totalsJan Steinman3 Sep