I frequently use the CHOOSE command such as: =================== CHOOSE opt3 FROM #VALUES FOR (LJS (mmskey, 3) + ' - ' + LJS(mmsdesc, 60)) + FROM mmsmenus + WHERE mmssection = 'RP' ORDER BY mmscode ASC AT 4, 1 + TITLE 'SELECT REPORT...' CAPTION 'MMS REPORTS' LINES 30 =================== so the menu looks like: A - Report A B - Report B B1 - Report B1 C - Report C And so on. I use this menu to select different report options, which I now store in tables for easy maintenance. Normally, I just strip the first 2 characters (normally letter A-Z) to process the option selected so I do not worry about the length of the string. Also, it is easy for users (that prefer to use the keyboard) to go directly to the report they want by typing the first letter of the option. When I run this application, I also show the string on the screen and it correctly displays all characters (more than 25). You may want to try using: SHOW VAR vchoix=60 AT 1, 25 to display all the characters (in this case 60) and verify if it displays all characters. Try running TRACE and display the variable vchoix right after you do the CHOOSE and see if it is returning the entire string. Make sure that the variable vchoix is not defined as TEXT 20. As Indicated, I have not run into a problem with this command. I am running 6.5++ for Windows. Good luck.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of J.M. GRATIAS Sent: Wednesday, June 26, 2002 5:48 AM To: Rbase List server Subject: Q. about CHOOSE command Hi all, Is there a length limit with the value returned by the CHOOSE command ? Look at the following commands : CREATE TEMPORARY VIEW vt_cloture + (liste, dateope) + AS SELECT + (LISTOF(cdeclarant)), + dateope + FROM declarant WHERE ..... GROUPED BY dateope ... CHOOSE vchoix FROM #VALUE FOR + (CTXT(dateope) & '(' + liste + ')'), liste + FROM vt_cloture ORDER BY dateope AT 10, 20 + TITLE 'Choisir la date a reouvrir :' + CAPTION .vcaption LINE 10 .... Column 'liste' display correctly in the CHOOSE list, but what is returned in variable 'vchoix' is troncated to 20 char. Any informations appreciated .... TIA ================================================ 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/
