data in wrong file

[Hamilton, Allison]

Could you send us the PDL for the records?

Allison Hamilton
Senior Software Engineer
Cognos Inc.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Deskin, Bob
Sent: Friday, June 11, 2004 9:18 AM
To: JOHAN Johan Koelewijn; powerh-l@lists.sowder.com
Subject: RE: Re: data in wrong file


- Are the records different layouts of the same file or are they two
different physical files?

- When you say the data from A ends up in B, are the items named the
same?

- Are there subscreens involved that could be causing problems?

Bob

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of JOHAN Johan
Koelewijn
Sent: June 11, 2004 9:14 AM
To: powerh-l@lists.sowder.com
Subject: RE: Re: data in wrong file


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.
> 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you. 
 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.