Re: Displaying items?? - Manoj

[Victor Loghin <vgl_ca@HOTMAIL.COM>]

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