data in wrong file

Chris Sharman chris.sharman@ccagroup.co.uk
Fri, 11 Jun 2004 13:38:31 +0100


JOHAN Johan Koelewijn wrote:
> Sometimes we have the problem that the data of record A is written in record B
> Record B has a 1:n relation with record A but has a different layout (other items).
> 
> In both records there is substructure defined including an item that covers the whore record. The names of these items are not the same. There is no statement like :
> let a-record of a = b-record of b
> 
> Any ideas how this can happen?

No - not a problem I've seen.
Are you sure it's Powerhouse doing it ?
Are you sure it's quick, rather than qtp (or quiz if you're talking of 
subfiles) ?
Any external procedures which could be trampling data ?

Likely a programmer error, I'm afraid - you could try to narrow it down 
with some auditing, frequent backups to disk, etc.

Look out for use of accept, display, edit etc in procedures where you 
shouldn't, such as input, edit etc (there's warnings and cautions in the 
reference manuals which are best heeded) - you can trash the value of 
fieldtext, and thereby transfer data between unrelated fields.

> Openvms 7.1
> Powerhouse 7.10g
> RMS file structure

Ditto.

Chris


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.