<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:r_ansi;
panose-1:2 11 6 9 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:Calibri;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Calibri;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>How about using the FIRST function?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>As in:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>>item transit_number of
cobra_paylog_extract_aei final first(transit_number of cobra_paylog_extract_aei)</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3 face="Times New Roman"><span style='font-size:12.0pt;font-family:"Times New Roman"'>
<hr size=2 align=center>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com] <b><span style='font-weight:bold'>On Behalf Of </span></b>John Stires<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, May 27, 2009
10:35 AM<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: Use of TEMPS and their
resetting</span></font><font size=3 face="Times New Roman"><span style='font-size:12.0pt;font-family:"Times New Roman"'></span></font></p>
</div>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>Hi
All!</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>At
Bob’s request, I skinnied down my code until I had only the basics to
send out. It started working. Boy! It was not pretty, but it
works. I am going to have to do something for the FIND procedure to make
work a little more like the normal find or I am going to have a time retraining
my users for this one screen.</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>First
off, all fields update correctly. When you first come to the screen, it
displays only the records not yet updated, i.e. all records with blank Check
and Transit no blank. Entering the Check no and Transit no and then
entering the values for a couple of members and then updating works fine.</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>The
trick is when you do the FIND for find the updated records. You have to
enter the Check and Transit nos and the do the FIND. Granted, it is
looking for only those that match the TEMPS. The FIND process is little
backwards, but works. This also allows the users to make another entry
for a separate check no for other member of the same group, a good thing.
I will have to play with is a bit yet.</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>I
have included the code below for any comments on getting around the awkward
FIND process.</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>A
hearty thanks to all,</span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'>John</span></font></p>
<div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal><font size=2 face=Calibri><span style='font-size:11.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>CANCEL CLEAR</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SCREEN
QKOBJ:COBRA_PAYLOG_EXTRACT_AEI_MNT.QKC
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
RECEIVING T_PASS_TRUST,
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
T_PASS_TRUST_NAME</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TEMPORARY
T_PASS_TRUST CHAR*03</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TEMPORARY
T_PASS_TRUST_NAME CHAR*30</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TEMP
T_CHECK_NUMBER
CHAR*9 RESET AT STARTUP</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TEMP
T_TRANSIT_NUMBER CHAR*8 RESET
AT STARTUP</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FILE COBRA_PAYLOG_EXTRACT_AEI
PRIMARY OCCURS 4 TIMES</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ACCESS SEQUENTIAL</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
SELECT
IF
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
CHECK_NUMBER OF
COBRA_PAYLOG_EXTRACT_AEI = T_CHECK_NUMBER &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
AND TRANSIT_NUMBER OF COBRA_PAYLOG_EXTRACT_AEI =
T_TRANSIT_NUMBER</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TITLE "PM Rcd
No" AT 6,05</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TITLE "Amt
Billed" AT 6,19</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>TITLE "Amt Paid
" AT 6,35</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP TO 4</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ALIGN (2,5,21)</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
TRUST_CODE OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LABEL "Trust Code:"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
SCAN_DATE OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LABEL "Date
Scanned:"
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
FORM MMDDYYYY</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP TO 4</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ALIGN (32,35,53)</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
T_CHECK_NUMBER LABEL "Check Number:"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD T_TRANSIT_NUMBER LABEL
"Bank Transit #:"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>CLUSTER OCCURS WITH
COBRA_PAYLOG_EXTRACT_AEI AT 7,2</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ALIGN (2,,5)(,,17)(,,32)</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
PM_RECORD_NUM OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ALIGN
(,,17)(,,33)(,,49)(,,62)</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
AMT_BILLED OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ID
SAME
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
PICT " ^,^^^,^^^.^^"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD AMT_PAID
OF COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ID
SAME
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
PICT " ^,^^^,^^^.^^"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
CHECK_NUMBER OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ID SAME</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD
TRANSIT_NUMBER OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
ID SAME</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>CLUSTER</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>SKIP TO 23</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>ALIGN (2,5,19)(31,34,51)</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD DATE_ADDED
OF COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
FORM MMDDYYYY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LABEL "Date added:"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> </span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>FIELD DATE_LAST_UPDATE OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
DISPLAY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
FORM
MMDDYYYY
&</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LABEL "Last Updated:"</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>;=======================================</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>PROCEDURE UPDATE</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> BEGIN</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> FOR
COBRA_PAYLOG_EXTRACT_AEI</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
BEGIN</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
IF ALTEREDRECORD OF
COBRA_PAYLOG_EXTRACT_AEI &</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
AND AMT_PAID <> 0</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
THEN</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
BEGIN</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LET CHECK_NUMBER = T_CHECK_NUMBER</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LET TRANSIT_NUMBER = T_TRANSIT_NUMBER</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
LET DATE_LAST_UPDATE = SYSDATE</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
PUT COBRA_PAYLOG_EXTRACT_AEI</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'>
END</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> END</span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span style='font-size:10.0pt;font-family:r_ansi'> END</span></font></p>
<p class=MsoNormal><font size=2 face="r_ansi"><span style='font-size:10.0pt;
font-family:r_ansi'>BUILD</span></font></p>
</div>
</body>
</html>