Information Statement Problem
Landers, Dianne
DLanders@pcc-structurals.com
Thu, 26 Dec 2002 17:14:36 -0800
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2AD45.52887139
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
That is what I'm saying.....when the information statements are =
executed, the values aren't what I expect. I thought the
LET DEPT_CODE OF LABOUR_HISTORY =3D DEPT_CODE OF TIME_ATTEND =
statement would plug the value into the variable, so I should be able to =
display it, and use it. Are you saying that you think that it is just =
putting it into the record buffer? But other columns of the table =
LABOUR_HISTORY have the expected values in them when I display them with =
an INFO statement.
=20
=20
-----Original Message-----
From: Edis, Bob [mailto:BEdis@usbnc.org]
Sent: Thursday, December 26, 2002 4:36 PM
To: PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
Dear Dianne
=20
I'm not sure if I understand your question correctly. =20
Are you saying that the information statements, when executed, do not =
display the values you are expecting?
=20
I.e. when the code segment is executed you get something like:
dept code of time_att=3Dxyz
dept code of lab_hist=3D
=20
Is the code example you provide the exact syntax from the program code? =
If it is then I think the problem is that the LABOUR_HISTORY record has =
not yet been updated/committed so the change is still in a buffer. Try =
running the program and then check the row values in a PL/SQL SELECT =
statement. If the LABOUR_HISTORY row still has no value then there is a =
problem.
=20
Regards,
Blue
=20
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 5:53 PM
To: Powerh-L (E-mail)
Subject: Information Statement Problem
Platform: Oracle 8.1.7, HPUX Version 11.0, PH 8.23.d7, VISIBILITY/6.36 =
Anyone out there experienced this problem:=20
LET DEPT_CODE OF LABOUR_HISTORY =3D DEPT_CODE OF =
TIME_ATTEND=20
info =3D 'dept code of time_att=3D ' + dept_code of time_attend now resp =
info =3D 'dept code of lab_hist=3D ' + dept_code of labour_history now =
resp=20
when I try to display the value of Dept_code of labour_history it is =
blank. But Dept_code of Time_attend has the correct value. if I hard =
code something in the let statement, it displays. And other columns in =
the Labour_History table have the correct value.
whats the deal?=20
Dianne Landers=20
PCC Structurals=20
------_=_NextPart_001_01C2AD45.52887139
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Information Statement Problem</TITLE>
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D140270801-27122002><FONT face=3DArial color=3D#0000ff =
size=3D2>That=20
is what I'm saying.....when the information statements are executed, the =
values=20
aren't what I expect. I thought the</FONT></SPAN></DIV>
<DIV><SPAN class=3D140270801-27122002><FONT face=3DArial =
size=3D2> <STRONG>LET=20
DEPT_CODE OF LABOUR_HISTORY =3D=20
DEPT_CODE OF TIME_ATTEND</STRONG> =
<FONT=20
color=3D#0000ff>statement would plug the value into the variable, so I =
should be=20
able to display it, and use it. Are you saying that you think that =
it is=20
just putting it into the record buffer? But other columns of the =
table=20
LABOUR_HISTORY have the expected values in them when I display them with =
an INFO=20
statement.</FONT></FONT></SPAN></DIV><SPAN =
class=3D140270801-27122002></SPAN><FONT=20
face=3DTahoma>
<DIV><BR><SPAN class=3D140270801-27122002></SPAN> </DIV>
<DIV><FONT size=3D2><SPAN =
class=3D140270801-27122002></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN =
class=3D140270801-27122002> </SPAN>-----Original=20
Message-----<BR><B>From:</B> Edis, Bob =
[mailto:BEdis@usbnc.org]<BR><B>Sent:</B>=20
Thursday, December 26, 2002 4:36 PM<BR><B>To:</B> PowerHouse List=20
(E-mail)<BR><B>Subject:</B> RE: Information Statement=20
Problem<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>Dear=20
Dianne</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>I'm=20
not sure if I understand your question correctly. =
</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>Are=20
you saying that the information statements, when executed, do not =
display the=20
values you are expecting?</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>I.e.=20
when the code segment is executed you get something =
like:</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>dept=20
code of time_att=3Dxyz</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>dept=20
code of lab_hist=3D</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>Is=20
the code example you provide the exact syntax from the program =
code? If=20
it is then I think the problem is that the LABOUR_HISTORY record has =
not yet=20
been updated/committed so the change is still in a buffer. Try =
running=20
the program and then check the row values in a PL/SQL SELECT =
statement. =20
If the LABOUR_HISTORY row still has no value then there is a=20
problem.</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Blue</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Landers, Dianne=20
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, =
December 26,=20
2002 5:53 PM<BR><B>To:</B> Powerh-L (E-mail)<BR><B>Subject:</B> =
Information=20
Statement Problem<BR><BR></FONT></DIV><!-- Converted from text/rtf =
format -->
<P><FONT face=3DArial size=3D2>Platform: Oracle 8.1.7, =
HPUX Version=20
11.0, PH 8.23.d7, VISIBILITY/6.36</FONT> </P>
<P><FONT face=3DArial size=3D2>Anyone out there experienced this =
problem:</FONT>=20
</P>
<P><FONT face=3DArial size=3D2> LET=20
DEPT_CODE OF LABOUR_HISTORY =3D=20
DEPT_CODE OF TIME_ATTEND</FONT> <BR><FONT =
face=3DArial=20
size=3D2>info =3D 'dept code of time_att=3D ' + dept_code of =
time_attend now=20
resp</FONT> <BR><FONT face=3DArial size=3D2>info =3D 'dept code of =
lab_hist=3D ' +=20
dept_code of labour_history now resp</FONT> </P>
<P><FONT face=3DArial size=3D2>when I try to display the value of =
Dept_code of=20
labour_history it is blank. But Dept_code of Time_attend has =
the=20
correct value. if I hard code something in the let statement, =
it=20
displays. And other columns in the Labour_History table have =
the=20
correct value.</FONT></P>
<P><FONT face=3DArial size=3D2>whats the deal?</FONT> </P>
<P><FONT face=3DArial size=3D2>Dianne Landers</FONT> <BR><FONT =
face=3DArial=20
size=3D2>PCC Structurals</FONT> =
</P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2AD45.52887139--