Hi Mike, I'm glad to know that I've got company!! I, too, tried the # symbol in the command and got data but not sorted. It is weird, isn't it? Sorting both columns is not a problem - might even be a good thing - but I'm sure it's different from how it used to be.
Regards, Alastair. ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 7:16 PM Subject: RE: Sort by function question > Alastair: > > I tried your command and got the same results. I tried specifying #2 > instead of just 2 and the command gave me results but they were not ordered > correctly. > > I then created a temporary view with a column name for the actual column and > one for the length column and then selected the data and it worked > correctly. > > Puzzling isn't it? > > It's not an answer to your problem but at least you have company and a > workaround. > > Thanks -- Mike Ramsour > > -----Original Message----- > From: Alastair Burr [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 20, 2002 12:59 PM > To: R:Base ListServer > Subject: Sort by function question > > > > > > > Hi all, > > Has anybody got any idea why this gives a "Press OK to continue" message > (and no data): > > select Full_Name, (slen(Full_Name)) from All_Names order by 2 > > whereas this works: > > select Full_Name, (slen(Full_Name)) from All_Names order by 2,1 > > I am sure, but willing to be proved wrong <g>, that I didn't have to sort > both columns in v6.0a/Dos > > Thanks in advance, > 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/ > > ================================================ > 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/
