Ron,
You are correct in what the reference manual states. However,
I recall that somewhere there is a statement that the datatype
of the choose variable is always TEXT. I cann't recall where
I found this it may just be RBase folkelore.
--
Jim Bentley
American Celiac Society
[EMAIL PROTECTED] - email
(973) 325-8837 voice
(973) 669-8808 Fax
---- "Ron Rose" <[EMAIL PROTECTED]> wrote:
> Has the CHOOSE variable been predefined?
> The 5.5 ref manual says: "Do not predefine the variable: the
> CHOOSE command
> defines the variable with its proper data type."
> If the variable existed, maybe that would confuse things.
>
> ----- Original Message -----
> From: "J.M. GRATIAS" <[EMAIL PROTECTED]>
> To: "Rbase List server" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 26, 2002 3: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/
>
================================================
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/
