Hello all, I have always believed that it made no difference whether you wrote a command as:
select ... from ... where ... order by ... or as: select ... from ... order by ... where ... However, I have a report where it does appear to matter. If I use: PRINT Last100_HTML + WHERE COUNT > .vCount + ORDER BY MainName, FirstName, ReleaseSequence the sort that is applied appears to be by FirstName then MainName then ReleaseSequence! However, if I write the command as: PRINT Last100_HTML + ORDER BY MainName, FirstName, ReleaseSequence + WHERE COUNT > .vCount then the sort works as expected. There are no break points defined on the report. Is this something that has changed over the years and I simply haven't noticed or is it to do with the way that data is selected when compared to the count (or any other?) function? Thanks for any enlightenment, Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- ================================================ 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/
