Re: Displaying items??

[Victor Loghin <vgl_ca@HOTMAIL.COM>]

Manoj,

What version of SQR, platform and database are you using? With both SQR 3
and 4.1.73 on MVS and DB2, I get the null value.

Victor Loghin
VGL Consulting Inc.

----Original Message Follows----
From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
Subject: Re: Displaying items??
Date: Tue, 26 Oct 1999 13:47:27 EDT

>Rick,
>
>What you have should work fine; indentation OUTSIDE a select
>doesn't matter.  The following works fine for me:

This will give error for display outside of begin-select
in NO row selected.

So better to put display within Begin-select.

>
>    begin-program
>
>    begin-select
>    dummy &a
>
>       display &a
>
>    from dual
>    end-select
>
>    display &a
>
>    end-program
>
>What error are you getting?   What version of SQR are you using?
>Does "show" work instead of "display"?
>
>Ray
>
> > 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?
> >
>
>----------------------------------------------------------------------
>Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
>Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

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

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