The text length has to be of the format Text (33)
put SomeFileName as SomeProcName InPutVar text(30) return text(30)
----- Original Message -----
From: "Duey Heffelfinger" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 5:19 PM
Subject: [RBASE-L] - Stored procedure returns only 8 characters?
> Randy,
>
> Thanks for the response. Results are below.
>
> > Try:
> >
> > PUT temp.prc AS temp vp_choose_title TEXT 33
>
> In your PUT statement the 33 becomes the description of the
> procedure, not TEXT 33. I'm not sure you can set a specific text
> length on a variable? Also, TEXT 33 is refering to the
> vp_choose_title variable, not the vp_output variable which is the
> variable being returned.
>
> Duey
>
>
>
> Date sent: Wed, 23 Jul 2003 12:43:13 -0500
> From: randyp <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] (RBASE-L Mailing List)
> Subject: [RBASE-L] - Re: Stored procedure returns only 8 characters?
> Send reply to: [EMAIL PROTECTED]
>
> > Dear Duey,
> >
> > I counted the characters in "Will thi", there are 8.
> >
> > Perhaps your text is defaulting to 8 characters.
> >
> > Try:
> >
> > PUT temp.prc AS temp vp_choose_title TEXT 33
> >
> > Randy Peterson
> >
> > Duey Heffelfinger wrote:
> >
> > > I'm having some trouble getting a variable back from a stored
> > > procedure and wonder if I'm doing something wrong or if someone has
> > > a work around. The following test procedure will not return the
> > > entire string to the variable.
> > >
> > > Example 1:
> > >
> > > *(temp.prc)
> > > CHOOSE vp_choose +
> > > FROM #LIST 'Will this go beyond 8 characters?' +
> > > AT CENTER CENTER +
> > > TITLE .vp_output_title
> > > RETURN .vp_choose
> > >
> > > Here's my put: PUT temp.prc AS temp vp_choose_title TEXT
> > > Here's my call: SET VAR vtemp TEXT = (CALL temp ("Make a choice"))
> > >
> > > vtemp returns: Will thi
> > >
> > > The only way it will work is to eliminate the vp_choose_title
> > > variable in the put statement and eliminate if from the choose in
> > > the procedure. Example 2
> > >
> > > *(temp.prc)
> > > CHOOSE vp_choose +
> > > FROM #LIST 'Will this go beyond 8 characters?' +
> > > AT CENTER CENTER
> > > RETURN .vp_choose
> > >
> > > Here's my put: PUT temp.prc AS temp
> > > Here's my call: SET VAR vtemp TEXT = (CALL temp ())
> > >
> > > vtemp returns: Will this go beyond 8 characters?
> > >
> > > I really need to send some variables to a procedure and get the full
> > > result. Any ideas and help would be appreciated.
> >
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> + Duey Heffelfinger, Director of Computer Services
> +
> + E-mail: [EMAIL PROTECTED] Dana College
> +
> + Phone : 402-426-7289 2848 College Drive
> +
> + Blair, Nebraska 68008
> +
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> + If you can dream it, it can come true!
> +
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
