Mike,
Thank you, Thank you. The part I was missing was: RETURN TEXT(30)
PUT temp.prc AS temp vp_choose_title RETURN TEXT(30) works as
expected.
Duey
From: "MikeB" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] (RBASE-L Mailing List)
Subject: [RBASE-L] - Re: Stored procedure returns only 8 characters?
Date sent: Wed, 23 Jul 2003 16:49:32 -0500
Send reply to: [EMAIL PROTECTED]
> 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!
> > +
> > +
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ 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!
+
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
