R:BASE 2000 v6.5++ Windows (32-bit), U.S. Version, Build: 1.851xRT03 is what "show version" says, David.
Full_Name is TEXT (45) - I presume that the function takes on an Integer type. Regards, Alastair. ----- Original Message ----- From: "David Blocker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 8:11 PM Subject: Re: Sort by function question > Alastair > > Using RBWIN build 1.851 a similar command on a different database works > fine: > > SELECT DNameL, (SLEN(DNameL)) FROM Drivers ORDER BY 2 > > DNameL is a text data type. What datatype is your column? What build are > you using? > > David BLocker > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "R:Base ListServer" <[EMAIL PROTECTED]> > Sent: Wednesday, March 20, 2002 12:58 PM > 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/
