Ken - thank you for asking that question (Why ?) and Paul - thank you for lucid explanation !
Paul Newton Paul McNett wrote: > 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. > > _______________________________________________ Post Messages to: ProFox@leafe.com 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.
