Checking records during Append

[Lloyd, Gavin]

Karen,

Are you using Lookup Noton on the field statement or procedural code in the edit procedure?

If using lookup noton then Powerhouse will check the occurrences on the screen as well as the database (as long as the lookup references the primary or detail file).

For example:

scr x
file CURRENCIES pri occurs 10
ALIGN ( ID 1 , LABEL 4 , DATA 21 ) ( ,  , DATA 41 )
CLUSTER OCCURS WITH CURRENCIES
FIELD CURRENCY_CODE OF CURRENCIES &
      REQUIRED NOCHANGE &
      NULL VALUE NOT ALLOWED &
      LOOKUP NOTON CURRENCIES
FIELD CURRENCY_NAME OF CURRENCIES NULL VALUE NOT ALLOWED
go

Regards,
Gavin.

From: Karen Barrett [mailto:kbarrett00 at hotmail.com]
Sent: 21 November 2010 02:36
To: Pickering, John (NORBORD); PowerhouseList Post
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

________________________________
Registered No. 755780 England
Registered Office: FM Insurance Company Limited
1 Windsor Dials, Windsor,
Berkshire, UK, SL4 1RS
Regulated by the Financial Services Authority.
VAT No. G.B.: 792 4276 02
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20101122/93167348/attachment.htm