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.