Information Statement Problem
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Sun, 29 Dec 2002 17:58:44 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2AF8D.D6C501C0
Content-Type: text/plain;
charset="iso-8859-1"
In what procedure is this code executed? If it's in the edit procedure of
dept_code of labour_history (and I very much approve of the way you
correctly spelled labour :-) then you might get weird results. I'd try it in
the process procedure or, even better, in the process procedure for a silent
field after the dept_code field.
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 5:15 PM
To: Edis, Bob; PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
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 = 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.
-----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
I'm not sure if I understand your question correctly.
Are you saying that the information statements, when executed, do not
display the values you are expecting?
I.e. when the code segment is executed you get something like:
dept code of time_att=xyz
dept code of lab_hist=
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.
Regards,
Blue
-----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:
LET DEPT_CODE OF LABOUR_HISTORY = DEPT_CODE OF TIME_ATTEND
info = 'dept code of time_att= ' + dept_code of time_attend now resp
info = 'dept code of lab_hist= ' + dept_code of labour_history now resp
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?
Dianne Landers
PCC Structurals
------_=_NextPart_001_01C2AF8D.D6C501C0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Information Statement Problem</TITLE>
<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=281560001-30122002><FONT face=Arial color=#0000ff size=2>In
what procedure is this code executed? If it's in the edit procedure of dept_code
of labour_history (and I very much approve of the way you correctly spelled
labour :-) then you might get weird results. I'd try it in the process procedure
or, even better, in the process procedure for a silent field after the dept_code
field.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, December 26,
2002 5:15 PM<BR><B>To:</B> Edis, Bob; PowerHouse List
(E-mail)<BR><B>Subject:</B> RE: Information Statement
Problem<BR><BR></FONT></DIV>
<DIV><SPAN class=140270801-27122002><FONT face=Arial color=#0000ff size=2>That
is what I'm saying.....when the information statements are executed, the
values aren't what I expect. I thought the</FONT></SPAN></DIV>
<DIV><SPAN class=140270801-27122002><FONT face=Arial size=2> <STRONG>LET
DEPT_CODE OF LABOUR_HISTORY =
DEPT_CODE OF TIME_ATTEND</STRONG> <FONT
color=#0000ff>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.</FONT></FONT></SPAN></DIV><SPAN
class=140270801-27122002></SPAN><FONT face=Tahoma>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><BR><SPAN
class=140270801-27122002></SPAN> </DIV>
<DIV><FONT size=2><SPAN class=140270801-27122002></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=140270801-27122002> </SPAN>-----Original
Message-----<BR><B>From:</B> Edis, Bob
[mailto:BEdis@usbnc.org]<BR><B>Sent:</B> Thursday, December 26, 2002 4:36
PM<BR><B>To:</B> PowerHouse List (E-mail)<BR><B>Subject:</B> RE: Information
Statement Problem<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Dear Dianne</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>I'm not sure if I understand your question correctly.
</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Are you saying that the information statements, when executed, do not
display the values you are expecting?</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>I.e. when the code segment is executed you get something
like:</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>dept code of time_att=xyz</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>dept code of lab_hist=</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Blue</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, December
26, 2002 5:53 PM<BR><B>To:</B> Powerh-L (E-mail)<BR><B>Subject:</B>
Information Statement Problem<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Platform: Oracle 8.1.7, HPUX
Version 11.0, PH 8.23.d7, VISIBILITY/6.36</FONT> </P>
<P><FONT face=Arial size=2>Anyone out there experienced this
problem:</FONT> </P>
<P><FONT face=Arial size=2> LET
DEPT_CODE OF LABOUR_HISTORY =
DEPT_CODE OF TIME_ATTEND</FONT> <BR><FONT
face=Arial size=2>info = 'dept code of time_att= ' + dept_code of
time_attend now resp</FONT> <BR><FONT face=Arial size=2>info = 'dept code
of lab_hist= ' + dept_code of labour_history now resp</FONT> </P>
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>whats the deal?</FONT> </P>
<P><FONT face=Arial size=2>Dianne Landers</FONT> <BR><FONT face=Arial
size=2>PCC Structurals</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2AF8D.D6C501C0--