Information Statement Problem
Dave Browne
dbrowne@teamsoft.ie
Mon, 30 Dec 2002 09:17:15 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01C2AFE4.3EC07600
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Dianne,
I'm currently working on VISaer which is a product originally based upon
the Visibility code base. I'm also fairly familiar with the Visibility
application. What's the name of the screen you're having trouble with?
If I have access to it I'll see if I can find out what the problem is.
Regards,
Dave
Dave Browne
Development Director
Teamsoft Limited
Mobile: +353 87 243 2628
Phone: +353 1 457 3299
Fax: +353 1 457 3349
E-mail: dbrowne@teamsoft.ie
-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Landers, Dianne
Sent: 27 December 2002 17:27
To: Edis, Bob; PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
Its a batch quick, called from another batch quick program, so I can't
figure out how to use debug effectively. As I step thru the first
screen, it never executes the RUN SCREEN command to get me into the
program that is actually not working. I keep getting TRAP Encountered
messages. Thats why I'm fiddling around with INFO statements.
Visibility creates quick screens that run in batch mode, and this is a
customized quick screen. I thought about trying to make it interactive
just to see if I can somehow use debug, but that will probably be a
useless exercise as well.
The correct data does get written to the database. The info statements
are in the same procedure. I don't think there is anything special
about the columns that display compared to the columns that don't
display. I'm displaying CHAR(4), Dates, etc. DEPT_CODE of
labour_history is char(4).
I think i'm just going to have to rethink the methodology that is being
used to accomplish summarizing the data before it posts to the Database,
and try something different.
thanks for your help.
-----Original Message-----
From: Edis, Bob [mailto:BEdis@usbnc.org]
Sent: Thursday, December 26, 2002 5:25 PM
To: PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
What are the column definitions/properties? Are the other INFO
statements in the same procedure? Have you tried using DEBUG to examine
the data step by step? Is there anything special about the column?
E.g. is there a PHD definition that may mask the Oracle metadata? Does
this happen for every row in the table? Is anything actually written to
the column in the database?
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 7: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
CONFIDENTIALITY NOTICE
This email is private and confidential and may contain legally privileged information. If you are not named above as an addressee it may be unlawful for you to read, copy, distribute, disclose or otherwise use the information in this email. If you are not the intended recipient of this email please destroy it and contact the sender via the switchboard on +353 (0) 1 457 3299 or via e-mail return.
Any views or opinions presented are solely those of the author and do not necessarily represent those of the company or its associated companies unless otherwise specifically stated.
------=_NextPart_000_0005_01C2AFE4.3EC07600
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C2AFE4.3DCDD8A0">
<title>Information Statement Problem</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"date"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:16792199 0 0 0 65791 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-reply;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
@page Section1
{size:595.3pt 841.9pt;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */=20
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Dianne,<o:p></o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I’m currently working on =
<span
class=3DSpellE>VISaer</span> which is a product originally based upon =
the
Visibility code base. I’m also fairly familiar with the Visibility
application.<span style=3D'mso-spacerun:yes'> </span>What’s =
the name
of the screen you’re having trouble with?<span
style=3D'mso-spacerun:yes'> </span>If I have access to it =
I’ll see if
I can find out what the problem is.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Regards,<o:p></o:p>=
</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'><o:p> </o:p></=
span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Dave<o:p></o:p></sp=
an></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'><o:p> </o:p></=
span></font></p>
<p class=3DMsoNormal><st1:PersonName><font size=3D2 color=3Dnavy =
face=3DArial><span
=
style=3D'font-size:10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>=
Dave
Browne</span></font></st1:PersonName><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>=
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Development =
Director<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Teamsoft =
Limited<o:p></o:p></span></font></p>
<p class=3DMsoNormal><st1:City><st1:place><font size=3D2 color=3Dnavy =
face=3DArial><span
=
style=3D'font-size:10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>=
Mobile</span></font></st1:place></st1:City><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy;mso-no-proof:yes'>:<span style=3D'mso-tab-count:1'> =
</span>+353
87 243 2628<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Phone:<span
style=3D'mso-tab-count:1'> </span>+353 1 457 =
3299<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>Fax:<span
style=3D'mso-tab-count:1'> </span>+353 1 =
457 3349<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>E-mail:<span
style=3D'mso-tab-count:1'> </span><a =
href=3D"mailto:dbrowne@teamsoft.ie">dbrowne@teamsoft.ie</a></span></font>=
<font
color=3Dnavy><span =
style=3D'color:navy;mso-no-proof:yes'><o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> =
powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Landers, Dianne<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 27 December 2002 =
17:27<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Edis, Bob; PowerHouse =
List
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Information =
Statement
Problem</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Its a batch =
quick, called
from another batch quick program, so I can't figure out how to use debug
effectively. As I step thru the first screen, it never =
executes the RUN
SCREEN command to get me into the program that is actually not =
working. I
keep getting TRAP Encountered messages. Thats why I'm fiddling =
around
with INFO statements. Visibility creates quick screens that run in =
batch
mode, and this is a customized quick screen. I thought about =
trying to
make it interactive just to see if I can somehow use debug, but that =
will
probably be a useless exercise as well.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>The correct data =
does get
written to the database. The info statements are in the same
procedure. I don't think there is anything special about the =
columns that
display compared to the columns that don't display. I'm displaying
CHAR(4), Dates, etc. DEPT_CODE of labour_history is =
char(4).</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>I think i'm just =
going to
have to rethink the methodology that is being used to accomplish =
summarizing
the data before it posts to the Database, and try something =
different.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>thanks for your =
help.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
<div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3DTahoma><span
style=3D'font-size:12.0pt;font-family:Tahoma'><o:p> </o:p></span></f=
ont></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3DTahoma><span
style=3D'font-size:12.0pt;font-family:Tahoma'> <o:p></o:p></span></f=
ont></p>
</div>
<div>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'> -----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Edis, Bob
[mailto:BEdis@usbnc.org]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, December =
26, 2002
5:25 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> PowerHouse List =
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Information =
Statement
Problem<o:p></o:p></span></font></p>
</div>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>What are the =
column
definitions/properties? Are the other INFO statements in the same
procedure? Have you tried using DEBUG to examine the data step by
step? Is there anything special about the column? E.g. is =
there a
PHD definition that may mask the Oracle metadata? Does this happen =
for
every row in the table? Is anything actually written to the column =
in the
database?</span></font><o:p></o:p></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Landers, Dianne =
[mailto:DLanders@pcc-structurals.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, December =
26, 2002
7:15 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Edis, Bob; PowerHouse =
List
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Information =
Statement
Problem</span></font><o:p></o:p></p>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>That is what I'm
saying.....when the information statements are executed, the values =
aren't what
I expect. I thought the</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'> <strong><b><font =
face=3DArial><span
style=3D'font-family:Arial'>LET DEPT_CODE OF
LABOUR_HISTORY =3D DEPT_CODE OF =
TIME_ATTEND</span></font></b></strong>
<font color=3Dblue><span style=3D'color:blue'>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.</span></font></span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3DTahoma><span
style=3D'font-size:12.0pt;font-family:Tahoma'><br>
<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3DTahoma><span
style=3D'font-size:12.0pt;font-family:Tahoma'> <o:p></o:p></span></f=
ont></p>
</div>
<div>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'> -----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Edis, Bob
[mailto:BEdis@usbnc.org]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, December =
26, 2002
4:36 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> PowerHouse List =
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Information =
Statement
Problem<o:p></o:p></span></font></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Dear =
Dianne</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>I'm not sure if =
I
understand your question correctly. </span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Are you saying =
that the
information statements, when executed, do not display the values you are
expecting?</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>I.e. when the =
code
segment is executed you get something like:</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>dept code of =
time_att=3Dxyz</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>dept code of =
lab_hist=3D</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Regards,</span></=
font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Blue</span></font=
><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"12" Day=3D"26" Year=3D"2002"><font size=3D2 face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>Thursday, December 26, =
2002</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"17" Minute=3D"53"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>5:53 PM</span></font></st1:time><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> Powerh-L (E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Information =
Statement
Problem</span></font><o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'><!-- Converted from text/rtf format =
-->Platform:
Oracle 8.1.7, HPUX Version 11.0, PH 8.23.d7, =
VISIBILITY/6.36</span></font>
<o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Anyone out there experienced this =
problem:</span></font>
<o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'> LET
DEPT_CODE OF LABOUR_HISTORY =3D
DEPT_CODE OF TIME_ATTEND</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>info =3D
'dept code of time_att=3D ' + dept_code of time_attend now =
resp</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>info =3D
'dept code of lab_hist=3D ' + dept_code of labour_history now =
resp</span></font> <o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>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.</span></font><o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>whats the deal?</span></font> <o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Dianne Landers</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>PCC
Structurals</span></font> <o:p></o:p></p>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</div>
</body>
</html>
<html>
<br>
CONFIDENTIALITY NOTICE<br>
This email is private and confidential and may contain legally privileged information. If you are not named above as an addressee it may be unlawful for you to read, copy, distribute, disclose or otherwise use the information in this email. If you are not the intended recipient of this email please destroy it and contact the sender via the switchboard on +353 (0) 1 457 3299 or via e-mail return.<br>
<br>
Any views or opinions presented are solely those of the author and do not necessarily represent those of the company or its associated companies unless otherwise specifically stated.</html>
------=_NextPart_000_0005_01C2AFE4.3EC07600--