Re: Displaying items?? - Victor

[Rama Krishna <kris_narravula@HOTMAIL.COM>]

Manoj,

The column variables referred outside the Select Statement never give an
error irrespective of the select statement fetched any rows or not.

Kris

----- Original Message -----
From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Wednesday, October 27, 1999 8:20 AM
Subject: Re: Displaying items?? - Victor


> >Victor wrote:
>
> >The select does not return any rows. When we use the column variable it
is
> >null. We do not get an error. What error do you get?
>
> So if select does not return any row and if u reference
> that memory variable (&Field from select) outside of
> begin-select, it will give error. It is quite obvious.
>
> If no row selected then that memory variable is not defined
> at all and will give error if u reference it in Display statement.
>
> And Display works fine within Begin-select, as if no
> row selected then Display statement won't execute.
>
> HTH,
> Manoj
>
> >From: Victor Loghin <vgl_ca@HOTMAIL.COM>
> >Reply-To: SQR-USERS@list.iex.net
> >To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> >Subject: Re: Displaying items?? - Manoj
> >Date: Wed, 27 Oct 1999 08:58:45 EDT
> >
> >Manoj,
> >
> >The select does not return any rows. When we use the column variable it
is
> >null. We do not get an error. What error do you get?
> >
> >Victor Loghin
> >VGL Consulting Inc.
> >
> >
> >----Original Message Follows----
> >From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
> >Subject: Re: Displaying items?? - Victor
> >Date: Tue, 26 Oct 1999 15:38:17 EDT
> >
> >Victor,
> >
> >We have SQR 4.3.2, Informix 7.3.
> >
> >But this issue is not related to specific release.
> >It will work with any SQR and database.
> >
> >If u are getting NULL, then if u have access to backend
> >using some kind of SQL editor (like we use SQL*Plus with
> >Oracle), then do simple select for that field from the
> >table and see if u really have any value in that column.
> >
> >So basically :
> >
> >Begin-Select
> >Field1
> >
> >  display &Field1
> >
> >FROM TABLE1
> >where <criteria>
> >
> >End-Select
> >
> >This Display will give o/p in log file if any rows are
> >selected from the table, based on your selection criteria
> >for the Field1 values.
> >
> >Hope this helps,
> >Manoj
> >
> >>From: Victor Loghin <vgl_ca@HOTMAIL.COM>
> >>Reply-To: SQR-USERS@list.iex.net
> >>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> >>Subject: Re: Displaying items??
> >>Date: Tue, 26 Oct 1999 14:14:12 EDT
> >>
> >>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
> >>
> >
> >______________________________________________________
> >Get Your Private, Free Email at http://www.hotmail.com
> >
> >______________________________________________________
> >Get Your Private, Free Email at http://www.hotmail.com
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>