But don't forget if you are passing in a text value over 8 characters, you have to
specify the
length of the argument variable as well..
----- Original Message -----
From: "Duey Heffelfinger" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 23, 2003 6:23 PM
Subject: [RBASE-L] - Re: Stored procedure returns only 8 characters?
> 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!
> +
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
