Also, just to add. If it is going to be Program Flow, I make Certain the
First word is unique, then use the SSUB with -1 to get the value that flows
into a Switch/Endsw.


----- Original Message -----
From: "Javier Valencia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 10:48 AM
Subject: RE: Q. about CHOOSE command


> 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/
>

================================================
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/

Reply via email to