Re: Displaying items?? - Victor

[Victor Loghin <vgl_ca@HOTMAIL.COM>]

Manoj,

I never got an error, you did.

Thx,
Victor Loghin
VGL Consulting Inc.

----Original Message Follows----
From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
Subject: Re: Displaying items?? - Victor
Date: Wed, 27 Oct 1999 13:14:31 EDT

Oops, it works. Didn't give error even if no row selected.

Victor, here we have PS7.5, SQR4.3.x, Informix 7.3.

Send me exact piece of code, where u are getting error, and
let me see.

Regards,
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?? - Victor
>Date: Wed, 27 Oct 1999 12:04:59 EDT
>
>Manoj,
>
>You state:
>"it will give error. It is quite obvious"
>
>Well, this does not happen to me in the DB2/MVS environment. That is why I
>want to know your platform and the actual error message you are getting.
>
>We can reference the variable before the select executes and also after it
>executes and returns no rows and do not get an error. The column variable
>cobntains null.
>
>Thx,
>Victor Loghin
>VGL Consulting Inc.
>
>----Original Message Follows----
>From: Manoj Gurjar <mgurjar@HOTMAIL.COM>
>Subject: Re: Displaying items?? - Victor
>Date: Wed, 27 Oct 1999 11:20:02 EDT
>
>>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
>
>______________________________________________________
>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