Bernie, I'd agree 103%. I often test queries of greater complexity than my balding noggin can grasp by breaking them down into their atomic statements (as possible), then testing each unit, with before and after viewing of the data (when applicable). Related to the Celko stuff, I'd add that, while there are plenty of examples of complex statements, I've taken more from the book at the level of concept or prinicple.
Call me superstitious, or maybe just pained, but I only agree 103% as the Challenger exploded at 104% ... Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Bernie Corrigan > Sent: Wednesday, March 27, 2002 2:01 PM > To: [EMAIL PROTECTED] > Subject: RE: Relational counting > > > >I'd also suggest to everyone, who doesn't have it, picking up a > copy of Joe > >Celko's "SQL For Smarties", as it contains lots of neat SQL > stuff, the vast > >majority of which will run in RBase. The ones that don't, if I > recall, are > >for the most part, from SQL (proposals) after ANSI-92. > > You have to be careful with complex SQL commands in RBase. Last year we > discussed one on this list that looked like it worked, produced no error > messages, but when subjected to scrutiny was sometimes providing erroneous > results and sometimes providing correct results depending on how the data > was organized. Be sure to test complex queries with differently ordered > versions of the same data set before accepting the query results as valid. > If you test the query on two or more orderings of the same data > set and get > the same results each time, then it is fairly safe to believe the > process is > valid. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
