Ron, Tom :

>>
Well that's one place the manual and I disagree for the very reason
Ron mentions.   As the var from the CHOOSE cmd is often a non-text
value I make it a habit to always set the var to TEXT = NULL immediately
prior to the CHOOSE.
<<

I always predefine my variables :

SET var vchoix TEXT = NULL
....
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 (full length) in the CHOOSE list, but
what is returned
 in variable 'vchoix' is troncated to 20 char. (only the first 5 item
separated by 4 commas, like AAAA,BBBB,CCCC,DDDD,FFFF)


J.M. GRATIAS, Logimatique
================================================
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