data in wrong file

JOHAN Johan Koelewijn j.koelewijn@thegreenery.com
Fri, 11 Jun 2004 15:14:28 +0200


Chris,

I'm sure it is Powerhouse and quite sure it is quick rather than qtp.
The problem comes up just for one or two records a week. In qtp this file is mass updated so I don't think it's qtp.
No external procedures used. Some 3gl used, but not for these records.

To answer Bob:

I recompiled everything last week (I thought that may be the case too) but that makes no difference. I even 'recovered' the dictionary with phdmaint, but that didn't help either.

> 
> 
> 
> -----Oorspronkelijk bericht-----
> Van: POWERH-L-ADMIN@LISTS.SOWDER.COM
> Datum: 11-6-04, 14:57
> Aan: powerh-l@lists.sowder.com
> Onderwerp: RE: Re: data in wrong file
> 
> 
> 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.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to powerh-l-
> request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>