Information Statement Problem

Landers, Dianne DLanders@pcc-structurals.com
Thu, 26 Dec 2002 15:52:38 -0800


This is a multi-part message in MIME format.

------_=_NextPart_001_01C2AD39.DEACA079
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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  =3D DEPT_CODE     OF =
TIME_ATTEND
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

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_01C2AD39.DEACA079
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.6249.1">
<TITLE>Information Statement Problem</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">Platform:&nbsp; Oracle 8.1.7, =
HPUX&nbsp; Version 11.0, PH 8.23.d7, VISIBILITY/6.36</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Anyone out there experienced this =
problem:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET =
DEPT_CODE&nbsp;&nbsp;&nbsp;&nbsp; OF LABOUR_HISTORY&nbsp; =3D =
DEPT_CODE&nbsp;&nbsp;&nbsp;&nbsp; OF TIME_ATTEND</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">info =3D 'dept code of time_att=3D ' + =
dept_code of time_attend now resp</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">info =3D 'dept code of lab_hist=3D ' + =
dept_code of labour_history now resp</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">when I try to display the value of =
Dept_code of labour_history it is blank.&nbsp; But Dept_code of =
Time_attend has the correct value.&nbsp; if I hard code something in the =
let statement, it displays.&nbsp; And other columns in the =
Labour_History table have the correct value.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">whats the deal?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Dianne Landers</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">PCC Structurals</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C2AD39.DEACA079--