Kenneth Kixmoeller/fh wrote: > On Nov 6, 2007, at 11:06 AM, Ted Roche wrote: > >> ... but it's a very bad idea. > > PMFJI: Why?
PMTFJI: Because it mixes the gathering of the raw data with the processing of that data to get meaningful numbers. What if I issued that SQL, and then inserted a new row or changed the value of an amt field. As a user, I'd expect that totals record to update to reflect. Also, what if the user went to sort the cursor on an arbitrary expression? How do you keep the totals line at the bottom? I guess the simplest way to say why it is bad is that you now have a row with a different meaning from the rest, and we all know that different meanings really belong in different datasets. -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
