Re: Displaying items??

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

It will work like this:


>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

     display &ibt.business_unit
>
>    do some_procedure
>
>from ps_pc_intfc_bl_tao ibt
>where ibt.process_instance = #prcs_process_instance
>end-select

If u put display out side of Begin-select, then it
will display Business_Unit, from the last row selected and
if select doesn't select anything then u will get error.

If u put display from within begin-select then it will
display values for all the rows selected, and won't errored
out if nothing fetched.

Hope this helps,
Manoj
>
>
>
>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?

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com