Checking records during Append

[Karen Barrett]

Thank you John, a code example would be helpful.
 


Subject: Re: Checking records during Append
Date: Sat, 20 Nov 2010 22:10:16 -0500
From: John.Pickering at norbord.com
To: kbarrett00 at hotmail.com





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. 

JWP




From: Karen Barrett <kbarrett00 at hotmail.com> 
To: Pickering, John (NORBORD); PowerhouseList Post <powerh-l at lists.sowder.com> 
Sent: Sat Nov 20 21:35:50 2010
Subject: RE: Checking records during Append 

Hi John,
 
So in the edit I first check the stored records, then loop through whatever is displayed. Thanks!!!
Hey, I passed up turkey bingo to work tonight :-)
 
Karen
 


Subject: Re: Checking records during Append
Date: Sat, 20 Nov 2010 21:15:42 -0500
From: John.Pickering at norbord.com
To: kbarrett00 at hotmail.com; powerh-l at lists.sowder.com




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.

And why am I answering this on a Saturday evening? :-)

JWP 




To: PowerhouseList Post <powerh-l at lists.sowder.com> 
Sent: Sat Nov 20 21:06:21 2010
Subject: Checking records during Append 

Does anyone remember what the trick is to checking between records entered (occurs 10) during the Append process?
 
Alternately, is there a way to push update stay from inside the Append?  
 
Old record xx yy zz 11 22
Old record zz rr 33 44 77
New rec    zz qq 33 44 66 ;my edits work fine here, checking against the put records
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 
                                      ; records but the data is not saved yet.
 
Thanks for any tips,
 
Karen Barrett
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20101122/57e00546/attachment.htm