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!
+
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
