<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Thank you John, a code example would be helpful.<BR> <BR>
<HR id=stopSpelling>
Subject: Re: Checking records during Append<BR>Date: Sat, 20 Nov 2010 22:10:16 -0500<BR>From: John.Pickering@norbord.com<BR>To: kbarrett00@hotmail.com<BR><BR>
<META name=Generator content="Microsoft SafeHTML">
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV><FONT color=navy size=2 face=Arial>I'd send you a code sample if I wasn't in a car half way between Montreal and Toronto. Ask me on Monday if you would still like an example. <BR><BR>JWP<BR></FONT></DIV><BR>
<DIV>
<HR align=center SIZE=2 width="100%">
<FONT size=2 face=Tahoma><B>From</B>: Karen Barrett <kbarrett00@hotmail.com> <BR><B>To</B>: Pickering, John (NORBORD); PowerhouseList Post <powerh-l@lists.sowder.com> <BR><B>Sent</B>: Sat Nov 20 21:35:50 2010<BR><B>Subject</B>: RE: Checking records during Append <BR></FONT><BR></DIV>Hi John,<BR> <BR>So in the edit I first check the stored records, then loop through whatever is displayed. Thanks!!!<BR>Hey, I passed up turkey bingo to work tonight :-)<BR> <BR>Karen<BR> <BR>
<HR id=ecxstopSpelling>
Subject: Re: Checking records during Append<BR>Date: Sat, 20 Nov 2010 21:15:42 -0500<BR>From: John.Pickering@norbord.com<BR>To: kbarrett00@hotmail.com; powerh-l@lists.sowder.com<BR><BR>
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV><FONT color=navy size=2 face=Arial>You will need to loop through the existing values on the screen in the EDIT PROCEDURE comparing FIELDVALUE with the data item of the other occurrences. You will need to check OCCURRENCE to avoid comparing FIELDVALUE with the data item in its own occurrence.<BR><BR>And why am I answering this on a Saturday evening? :-)<BR><BR>JWP </FONT></DIV><BR>
<DIV>
<HR align=center SIZE=2 width="100%">
<FONT size=2 face=Tahoma><BR><B>To</B>: PowerhouseList Post <powerh-l@lists.sowder.com> <BR><B>Sent</B>: Sat Nov 20 21:06:21 2010<BR><B>Subject</B>: Checking records during Append <BR></FONT><BR></DIV>Does anyone remember what the trick is to checking between records entered (occurs 10) during the Append process?<BR> <BR>Alternately, is there a way to push update stay from inside the Append? <BR> <BR>Old record xx yy zz 11 22<BR>Old record zz rr 33 44 77<BR>New rec zz qq 33 44 66 ;my edits work fine here, checking against the put records<BR>New rec zz qq 33 99 66 ; Here, the edits do not work because I am mid-append, data not yet stored. The value 33 is not allowed for the 2nd of paired <BR> ; records but the data is not saved yet.<BR> <BR>Thanks for any tips,<BR> <BR>Karen Barrett<BR> </body>
</html>