Re: Displaying items?? - Victor

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

>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