J.M. - Yes, there is that limit - I created an "abbreviated" column to use in the ListOf function and it works fine. for example,
ServiceCategory ServiceAbbv ------------------------------------------------------------- -------------- ----- School Services - Orientation & Mobility School Serv - O&M Special Education - Rehabilitation Teaching Spec Ed - Rehab Teach CHOOSE vwhich FROM #VALUES FOR (LISTOF(ServiceAbbv)) FROM ...... There is also a limit to the number of items returned in the list in a Report Variable - I don't remember what the limit is or if it applies in a Form and a SELECT statement as well. It's one of my favorite new functions - but it does have its limitations - so test it out and put in enhancement requests to the RDCC! Sami Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 Fax 913-962-9431 mailto:[EMAIL PROTECTED] ----- Original Message ----- From: "J.M. GRATIAS" <[EMAIL PROTECTED]> To: "Rbase List server" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 5:47 AM 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/
