Re: Displaying items??

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Rick...
Why do you have on-error=sql-error?  I don't see you doing any SQL stuff.  Try running the select without that and see if you get what you want.
Sam

<<< "Love, Kristin" <klove@MSA.COM> 10/26  9:14a >>>
> This shouldn't be giving you an error. What exactly does it say?
>
> You are allowed to say display &whatever...
>
> By the way, you don't have to put the &ibt.business_unit in your select:
>
> Begin-select (etc.)
> ibt.business_unit
> ibt.project_id
>
> From (etc)
>
> display &ibt.business_unit
>
> If you want to give it a different name, then you would put &
>
> Maybe that's why it has an error?
> begin-select (etc.)
> ibt.business_unit  &busunit
>
> (etc)
>
> display &busunit
>
> :) Kristin
>
> -----Original Message-----
> From: Rick Creel [SMTP:Rick_Creel@AONCONS.COM]
> Sent: Tuesday, October 26, 1999 8:58 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Displaying items??
>
> I have a select and display statement similar to the following:
>
> begin-select on-error=sql_error
> ibt.business_unit     &ibt.business_unit
> ibt.project_id        &ibt.project_id
>
>    do some_procedure
>
> from ps_pc_intfc_bl_tao ibt
> where ibt.process_instance = #prcs_process_instance
> end-select
>
> display &ibt.business_unit
>
>
> I get an error on the display statement.
> Is there a way to display the  &ibt.business_unit   variable without
> having to
> move it to a $ type variable?