I prepend a (CHAR(254)) with following space and description for descending sorts, (CHAR(31)) for ascending sorts. It prepends a character, but maintains the sort just fine. I use code 0 for the special handling ID, but you could use -1 or some other such as 999999999 for integer selects. If the retcol is text, return the character and act on it.
CHOOSE ... + UNION SELECT (CHAR(254) & "Add New"),0 FROM FormDummy or CHOOSE ... + UNION SELECT (CHAR(31)) & "Add New"),0 FROM FormDummy "Gunnar Ekblad" <[EMAIL PROTECTED]> wrote: >Try Char(256) by best guess > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >On Behalf Of Ben Petersen >Sent: den 2 december 2002 11:17 >To: [EMAIL PROTECTED] >Subject: RE: Hard space > >Gunnar, > >I want to sort a list in decending order in a choose command. �If I >pre-pend a hard space I can force the literal to be first in the list >while �char(32) - space - �would be last. > >I'm going to modify the driving view to made this work. > >Thanks! > >Ben Petersen > > >On 2 Dec 2002, at 18:45, Gunnar Ekblad wrote: > >> Bill >> I just tied in i writ an screen and reports with (char(32)) To me >> seems to work or are you trieng to some other things I do not >> understand? >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >> On Behalf Of Ben Petersen Sent: den 2 december 2002 08:44 To: >> [EMAIL PROTECTED] Subject: Hard space >> >> Hi all, >> >> I need to use a hard space (char(255)) in a literal in a choose >> statement. But rather than a hard space it displays a "y" with two >> dots over it. The same character in a write statement displays as >> expected. Is there something I can do? >> >> Thanks, >> >> Ben Petersen >> ================================================ >> 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/ > >================================================ >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/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
