Alastair and Mike, "2" and "#2" do not refer to the same item when used in a sort clause. "2" refers to the second item in the select statement. "#2" is an alias and refers to the second column of the table used in the select statement.
by way of information I "order by 2" do not work in rbase dos ver 6.5+. "order by 2,1" does work however. you can also do: select Full_Name, (slen(Full_Name)) as l_name from + All_Names order by l_name,1 -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- "Alastair Burr" <[EMAIL PROTECTED]> wrote: > 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/ > __________________________________________________ Voicemail, email, and fax...all in one place. Sign Up Now! http://www.onebox.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/
